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

mysql Íü¼ÇROOTÃÜÂëµÄ¼òµ¥½â¾ö·½°¸

1.Í£µômysqld
  service mysqld stop
2.ÖØÆômysqld£¬Ö¸¶¨²ÎÊý
  service mysqld start --skip-networking --skip-grant-tables
  »òÕß
  /opt/mysql/bin/mysqld_safe --skip-networking --skip-grant-tables &
  /opt/mysql/ÊÇÎÒµÄMYSQL°²×°Â·¾¶
  skip-grant-tables:Á¬½ÓÊ±Ìø¹ýÊÚȨ±í¼ì²é
  skip-networking:ÍêÈ«½ûÖ¹tcp/ipÁ¬½Ó£¬ÕâÊÇΪÁ˰²È«Æð¼û£¬ÒòΪskip-grant-tablesÆÚ¼äÈκÎÓû§¶¼¿ÉÒÔÒÔÈκη½Ê½µÇ¼¡£
3.ÐÞ¸ÄrootÃÜÂë 
  update mysql.user set password=password('newpasswd') where user='root';
  ÕâÀïÓÃpassword()¼ÓÃÜÊDZØÐëµÄ£¬Ò²Ã»±ØÒªflush privilegesÁË£¬ÒòΪÎÒÃÇÂíÉÏÖØÆô¡£
  ×¢Ò⣬set password forµÄ·½·¨²»ÊÊÓá£
4.mysqldÖØÆô£¬ok.


Ïà¹ØÎĵµ£º

ÎÅÃûåÚåǵÄMySQLÂÒÂëÎÊÌâ

ÎÅÃûåÚåǵÄMySQLÂÒÂëÎÊÌ⣨ת£©
2009-06-07 11:22
Ò»¡¢¸ÅÊö
¡¡¡¡¹«Ë¾Ð¹ºÁËÒ»ÅúPC£¬×¼±¸°Ñ¼¸¸öÐÔÄܽÏÓŵÄPCÉý¼¶ÎªÊý¾Ý¿â·þÎñÆ÷£¬Ìæ»»ÀϾɵĻúÆ÷¡£¹«Ë¾ÓÐÌ×POSÖÕ¶ËÈí¼þ£¬ºǫ́Êý¾Ý´æ´¢ÊÇ MySQL 3.23 °æ¡£ÎÒ×¼±¸Ó²¼þÉý¼¶µÄͬʱÉý¼¶Êý¾Ý¿âÈí¼þ¡£µ«ÊÇÉý¼¶¹ý³ÌÖÐÓöµ½ÎÅÃûµÄ MySQL µÄÂÒÂëÎÊÌâ¡£¾­¹ý²éÕÒ×ÊÁÏ£¬¼ÓÉÏ×Ô¼ºµÄÃþË÷ºÍ¾ ......

ÈçºÎÐÞ¸Ämysql rootÃÜÂ룿

1¡¢±à¼­MySQLÅäÖÃÎļþ£º
 windows»·¾³ÖУº%MySQL_installdir%\my.ini¡¡//Ò»°ãÔÚMySQL°²×°Ä¿Â¼ÏÂÓÐmy.ini¼´MySQLµÄÅäÖÃÎļþ¡£
linux»·¾³ÖУº/etc/my.cnf
ÔÚ[MySQLd]ÅäÖöÎÌí¼ÓÈçÏÂÒ»ÐУº
skip-grant-tables
±£´æÍ˳ö±à¼­¡£
2¡¢È»ºóÖØÆôMySQL·þÎñ
windows»·¾³ÖУº
net stop MySQL
net start MySQL
linux»·¾³ÖÐ ......

mysql ³£Óú¯Êý

Ò»¡¢³£ÓÃ×Ö·û´®º¯Êý
1.CONCAT(str1,str2,...)
mysql> ? concat;
mysql> SELECT CONCAT('My', 'S', 'QL');
+-------------------------+
| CONCAT('My', 'S', 'QL') |
+-------------------------+
| MySQL        ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ