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

Íü¼ÇÁËMySQLµÄrootÃÜÂëÓ¦µ±ÈçºÎÈ¡»Ø

ÎÊ£ºÈç¹ûÍü¼ÇÁËMySQLµÄrootÃÜÂëÓ¦µ±ÈçºÎÈ¡»Ø£¿
´ð£º½â¾ö·½·¨ÈçÏ£º
·¨1£ºÔÚmy.cnfµÄ[mysqld]×ֶμÓÈ룺
skip-grant-tables
È»ºóÖØÆôÄãµÄmysqld,ÕâÑù¾ÃûÓÐÃÜÂëÁË.
È»ºó½øÈëmysql¡£
UPDATE mysql.user SET Password=PASSWORD
('password') WHERE User='root';
³É¹¦ºó
FLUSH PRIVILEGES;
×îºóÈ¥µômy.cnfÖеÄskip-grant-tables
ÖØÆômysqld¡£
·¨2£º./bin/mysqld_safe --skip-grant-tables --user=root


Ïà¹ØÎĵµ£º

mysqlÌí¼ÓÓû§

mysqlÌí¼ÓÓû§·½·¨ 
½¨Á¢Êý¾Ý¿âgamesp
create database gamesp;
Ìí
¼ÓÓû§
grant  all  on  Êý¾Ý¿âÃû.*   to   Óû§
Ãû
@localhost  identified  by  'ÃÜÂë';
grant all on gamesp.* to
newuser@localhost
identified by
'pas ......

½â¾öÖÐÎÄ´æÈëMySql³öÏÖÂÒÂëÎÊÌâ

½â¾ö°ì·¨£ºÔÚÁ¬½Ó×Ö·û´®ÖÐ˵Ã÷Á¬½Ó×Ö·ûµÄÊôÐÔ£¬È磺
    <add name="server_mysql" connectionString="server=127.0.0.1;user id=root; password=123; database=baiduemail; pooling=false;charset=gbk"/>
»òÕßÊÇ;charset=gb2312
ÁíÍâ×¢Ò⣺ÔÚ´´½¨mysqlÊý¾Ý¿âµÄ±íµÄʱºòÑ¡Ôñ±àÂ뼯gbk ......

MySQL Óû§¹ÜÀí

Ê×ÏÈÒªÉùÃ÷һϣºÒ»°ãÇé¿öÏ£¬ÐÞ¸ÄMySQLÃÜÂ룬ÊÚȨ£¬ÊÇÐèÒªÓÐmysqlÀïµÄrootȨÏ޵ġ£
²âÊÔ»·¾³£ºWIN32 mysql5.0.45
×¢£º±¾²Ù×÷ÊÇÔÚWINÃüÁîÌáʾ·ûÏ£¬phpMyAdminͬÑùÊÊÓá£
    Óû§£ºphplamp  Óû§Êý¾Ý¿â£ºphplampDB
1.н¨Óû§¡£
//怬MYSQL
@>mysql -u root -p
@>ÃÜÂë
//´´½¨Óû§
mys ......

mysql noinstall°æ°²×°

mysql noinstall°æ°²×°
1¡¢Èí¼þµÄÏÂÔØ
¡¡¡¡µ½mysqlµÄ¹Ù·½ÍøÕ¾ÏÂÔØMySQLµÄ½âѹ°ü£¬Èçmysql-noinstall-5.0.51b-win32.zip
¡¡¡¡È»ºó½«Æä½âѹµ½ÄãÏ£ÍûÊý¾Ý¿âËùÔÚµÄij¸öλÖã¬ÈçC:\
¡¡¡¡ÕâÑùÔÚC:ÅÌÏÂÃæ¾ÍÓÐÁËC:\mysql-5.0.51b-win32ÕâÑùµÄÒ»¸öĿ¼£¬ÀïÃæ¾ÍÊÇMySQLÊý¾Ý¿âµÄÈ«²¿ÄÚÈÝ¡£
2¡¢ÅäÖÃ
¡¡¡¡Ê×ÏÈÎÒÃÇÀ´¿´MySQLµÄ¸ùĿ ......

MySQL³ÌÐòÆÊÎö£¨Profiling£©

ÎÒÃǽ«ÒªÏêϸµÄ½²µ½MySQLµÄÆÊÎö(Profiling),ÒòΪËüºÜÉÙÒÀÀµÓÚÄãµÄÓ¦Óá£Ó¦ÓúͷþÎñÆ÷¼¶±ðµÄÆÊÎöÓеÄʱºò¶¼ÊÇÓбØÒªµÄ¡£ËäȻӦÓü¶±ðµÄÆÊÎö¿ÉÒÔ¸øÄãÕû¸öÓ¦ÓÃÐÔÄܵÄ×ÜÀ¿¡££¬µ«ÊǶÔMySQLµÄÆÊÎöÌṩÁËÐÅÏ¢ÊÇ·þÎñÆ÷¼¶±ðËùÌṩ²»Á˵ġ£±ÈÈ磬¶ÔPHP´úÂë½øÐÐÆÊÎö²»»áÏÔʾMySQLÓжàÉÙÐÐÓï¾äÖ´ÐÐÁË¡£
 
ÓëÓ¦ÓÃÆÊÎöÒ»Ñù£¬Ä¿±êÊÇ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ