ÐÞ¸ÄmysqlÃÜÂëµÄ·½·¨
use mysql
update user set Password=password('newpassword') where User='root';
flush privileges;
1.ͨ¹ýÐÞ¸ÄMYSQLÊý¾Ý¿âÖÐMYSQL¿âµÄUSER±í
¾ÍÓÃÆÕͨµÄUPDATE¡¢INSERTÓï¾ä¾Í¿ÉÒÔ
2.ÔÚÃüÁîÐÐÖÐʹÓÃÈçÏÂÃüÁî
MYSQLADMIN -u root -p PASSWORD mypasswd
3.¿ÉÒÔÐÞ¸ÄMYSQLÎļþ¼ÐÖеÄMY.INIÎļþ
4.ʹÓÃSET PASSWORDÓï¾ä£¬
mysql> SET PASSWORD FOR myuser@localhost = PASSWORD('mypasswd');
5.ʹÓÃGRANT ... IDENTIFIED BYÓï¾ä
mysql> GRANT USAGE ON *.* TO myuser@localhost IDENTIFIED BY 'mypassword';
Ïà¹ØÎĵµ£º
http://linux.chinaitlab.com/MYSQL/524755_2.html
http://bbs.chinaunix.net/archiver/?tid-809159.html
ÔÚApache, PHP,
MySQLµÄÌåϵ¼Ü¹¹ÖУ¬MySQL¶ÔÓÚÐÔÄܵÄÓ°Ïì×î´ó£¬Ò²ÊǹؼüµÄºËÐIJ¿·Ö¡£¶ÔÓÚDiscuz!ÂÛ̳³ÌÐòÒ²ÊÇÈç´Ë£¬MySQLµÄÉèÖÃÊÇ·ñºÏÀíÓÅ»¯£¬Ö±½Ó
Ó°Ïìµ½ÂÛ̳µÄËٶȺͳÐÔØÁ¿£¡Í¬Ê±£¬MySQLÒ²ÊÇÓÅ»¯ÄѶÈ×î´ó ......
´Ómysql±¸·Ý³öÀ´µÄsqlÎļþ½øÐл¹Ô²Ù×÷ʱ±¨´í£¬²é¿´´íÎóÈÕÖ¾£¬ÄÚÈÝÈçÏ£º
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=50913 DEFAULT CHARSET=gbk' at li ......
ǰһƪÎÄÕÂÖÐ˵µ½ÁËLOADÃüÁÕâÀï¾ÍÀ´ÏêϸµÄ¸ø×Ô¼º£¬Ë³±ãÒ²¸ø´ó¼Ò½²½âÏÂLOADÃüÁîºÍÅú´¦ÀíµÄÊý¾Ýµ¼È빦ÄÜ¡£ÓõÄʱºò¸Ð¾õMySQLÓÃÆðÀ´ÕæµÄ±È½Ï×ÌÈ󡣡£¡£¡£
Åú´¦Àíµ¼ÈëÎļþ£¬´ÓsqlÎļþµ¼ÈëÊý¾Ýµ½Êý¾Ý¿âÖÐ £¬Åú´¦ÀíÊÇÒ»Öַǽ»»¥Ê½ÔËÐÐmysql³ÌÐòµÄ·½·¨£¬ ......
Ò»¡¢°²×°ÏµÍ³»·¾³
1¡¢ÏµÍ³£ºcentos5
2¡¢²âÊÔÔÚvm5.5
×¼±¸Èí¼þ
lighttpd-1.4.18
ÏÂÔØµØÖ·
mysql-5.0.41
part1ÏÂÔØµØÖ·
part2ÏÂÔØµØÖ·
part3ÏÂÔØµØÖ·
php-5.2.3
ÏÂÔØµØÖ·
SupeSite/X-Space
part1ÏÂÔØµØÖ·
part2ÏÂÔØµØÖ·
part3ÏÂÔØµØÖ·
discuz
ÏÂÔØµØÖ·
¶þ¡¢´î½¨web·þÎñÆ÷°²×°¹ý³Ì
1¡¢mysql5°²×°
$ tar zx ......
2009Äê10ÔÂ30ÈÕ ÐÇÆÚÎå 22:53
ÓÃmysql
ÄÚÖú¯Êýת»»ipµØÖ·ºÍÊý×Ö
ÀûÓÃÁ½¸öÄÚÖú¯Êý
inet_aton:½«ipµØÖ·×ª»»³ÉÊý×ÖÐÍ
inet_ntoa:½«Êý×ÖÐÍת»»³ÉipµØÖ·
³ä·ÖÀûÓÃmysqlÄÚÖõÄ
format
º¯Êý
ÓÈÆäÊÇÔÚ´¦Àí×Ö·û¸ñʽµÄʱºò,ÀýÈ罫12345ת»»³É12,345ÕâÑùµÄ,Ö»ÒªÓÃ:format(12345,0)¼´¿É,Èç¹ûÓÃformat(12345,2)ÔòÏÔÊ ......