Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysql µÄ×Ö·û±àÂë

 === ÉÔºóÔÙÕûÀí
mysql
4.0µ½mysql
5.0µÄÊý¾Ýµ¼Èë³öÏÖÂÒÂëµÄ½â¾ö·½°¸
×ÖÌå´óС£º´ó
| ÖÐ
| С
2007-02-08 17:09 -
ÔĶÁ£º485 - ÆÀÂÛ
£º0
×î½ü×ömysql
4.0µ½mysql
5.0µÄÊý¾Ýת»¯¹¤×÷£¬·¢ÏÖÂÒÂë
ÎÞÊý£¬¹Û²©¿ÍÎÞÊýÐĵÃÈçÏ£º
£ªmysql
ÖÐÎÄ亂碼µÄÔ­Òò
mysql
會³ö現ÖÐÎÄ亂碼µÄÔ­Òò²»ÍâºõÏÂÁÐ幾點£º
-mysql
server±¾Éí設¶¨問題£¬ÀýÈç還Í£ÁôÔÚ latin1
-mysql
table µÄ語ϵ設¶¨問題(°üº¬ character 與 collation)
-¿Í戶¶Ë³Ìʽ(ÀýÈç php) µÄ連線語ϵ設¶¨問題
ÕâÊÇÓÉÓÚ mysql
5.0ĬÈÏÊÇlantinÈðµäÓïϵ£¬Òò´ËÔÚmysql
4.0µ¼³öµÄsqlÎļþÀïÃæÐèÒª¼ÓÈëDEFAULT CHARSET
=utf8 collate
utf8_unicode_ci
ÀýÈ磺
CREATE TABLE IF NOT EXISTS `user_right` (
  `user_right_id` int(11) NOT NULL auto_increment,
  `user_id` varchar(11) default NULL,
  `right_id` varchar(11) default NULL,
  PRIMARY KEY  (`user_right_id`)
) TYPE=MyISAM DEFAULT CHARSET
=utf8 collate
utf8_unicode_ci
AUTO_INCREMENT=11 ;
È»ºóÔÚphpÁ¬½ÓÊý¾Ý¿â×î³õÖ´ÐÐ"SET NAMES 'utf8'"£»
ÎÊÌâ½â¾ö£¡ÒÔÉÏÕë¶Ôutf8±àÂëµÄÊý¾Ý¿â£¬±Ï¾¹ÊÇÇ÷ÊÆÂÆäËü±àÂëÓдýÉÔ¿ÕµÄʱºòÑо¿


Ïà¹ØÎĵµ£º

¼ÌÐøÕª³­£º½ÌÄãÓÃPHPдMySQLÊý¾Ý¿âµÄÓû§ÈÏ֤ϵͳ

Óû§ÈÏÖ¤µÄÔ­ÀíºÜ¼òµ¥£ºÊ×ÏÈÐèÒªÓû§ÔÚÒ³ÃæÉÏÌîÈëÓû§ÃûºÍÃÜÂ룬µ±È»Ã»×¢²áµÄÓû§ÐèÒªÏÈ×¢²á¡£È»ºóµ÷ÓÃÊý¾Ý¿âËÑË÷ÊÇ·ñÓÐÏàÓ¦µÄÓû§¡£Èç¹ûÓоÍÈ·ÈÏ£¬Ã»ÓÐÔòÌáÐÑÓû§ÏÈ×¢²á¡£Ê¹ÓÃPHPÀ´Íê³ÉÕâÒ»Çкܼòµ¥£¬µ«ÐèҪעÒâµÄÊÇÈç¹ûÏëÔÚÒÔºóµÄÒ³ÃæÖж¼ÄÜÈ·ÈÏÓû§Éí·Ý¡£
µÚÒ»²½ÊÇ×öÒ»¸öµÇ¼µÄÒ³Ãæ¡£
µÚ¶þ²½¿ªÊ¼µÇ¼ºóµÄÈ·ÈϳÌÐòµÄÉ ......

ËÄÖÖÔÚMySQLÖÐÐÞ¸ÄrootÃÜÂëµÄ·½·¨

 <>ÕûÀíÁËÒÔÏÂËÄÖÖÔÚMySQLÖÐÐÞ¸ÄrootÃÜÂëµÄ·½·¨,¿ÉÄܶԴó¼ÒÓÐËù°ïÖú!
·½·¨1£º ÓÃSET PASSWORDÃüÁî
¡¡¡¡mysql -u root
¡¡¡¡mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
·½·¨2£ºÓÃmysqladmin
 
¡¡¡¡mysqladmin -u root password "newpass"
¡¡¡¡Èç¹ûrootÒѾ­ÉèÖà ......

MySQLÐÞ¸ÄÃÜÂë·½·¨×ܽá

Ê×ÏÈÒªÉùÃ÷Ò»µã£¬´ó²¿·ÖÇé¿öÏ£¬ÐÞ¸ÄMySQLÊÇÐèÒªÓÐmysqlÀïµÄrootȨÏ޵ģ¬ ËùÒÔÒ»°ãÓû§ÎÞ·¨¸ü¸ÄÃÜÂ룬³ý·ÇÇëÇó¹ÜÀíÔ±¡£ ·½·¨Ò»Ê¹ÓÃphpmyadmin£¬ÕâÊÇ×î¼òµ¥µÄÁË£¬ÐÞ¸Ämysql¿âµÄuser±í£¬ ²»¹ý±ðÍüÁËʹÓÃPASSWORDº¯Êý¡£ ·½·¨¶þʹÓÃmysqladmin£¬ÕâÊÇÇ°ÃæÉùÃ÷µÄÒ»¸öÌØÀý¡£ mysqladmin -u root -p password mypasswd ÊäÈëÕâ¸ö ......

mysql ÖÐshow ÃüÁîÓ÷¨Ïêϸ½éÉÜ

 ÒÔÏÂËùÓÐÃüÁî¶¼ÊÇÔÚ½øÈëmysql¼à¿ØÆ÷ÖÐÖ´Ðеģº
  a. show tables»òshow tables from database_name; // ÏÔʾµ±Ç°Êý¾Ý¿âÖÐËùÓбíµÄÃû³Æ
  b. show databases; // ÏÔʾmysqlÖÐËùÓÐÊý¾Ý¿âµÄÃû³Æ
  c. show columns from table_name from database_name; »òshow columns from databa ......

MYSQL¸ß²¢·¢¼Ü¹¹

L1¡¢HTML¾²Ì¬»¯
Æäʵ´ó¼Ò¶¼ÖªµÀ£¬Ð§ÂÊ×î¸ß¡¢ÏûºÄ×îСµÄ¾ÍÊÇ´¿¾²Ì¬»¯µÄhtmlÒ³Ãæ£¬ËùÒÔÎÒÃǾ¡¿ÉÄÜʹÎÒÃǵÄÍøÕ¾ÉϵÄÒ³Ãæ²É Óþ²Ì¬Ò³ÃæÀ´ÊµÏÖ£¬Õâ¸ö×î¼òµ¥µÄ·½·¨ÆäʵҲÊÇ×îÓÐЧµÄ·½·¨¡£µ«ÊǶÔÓÚ´óÁ¿ÄÚÈݲ¢ÇÒÆµ·±¸üеÄÍøÕ¾£¬ÎÒÃÇÎÞ·¨È«²¿ÊÖ¶¯È¥°¤¸öʵÏÖ£¬ÓÚÊdzöÏÖÁËÎÒÃdz£¼ûµÄÐÅÏ¢ ·¢²¼ÏµÍ³CMS£¬ÏñÎÒÃdz£·ÃÎʵĸ÷¸öÃÅ»§Õ¾µãµÄÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ