½â¾ömysql¡°Access denied for user
½â¾ömysql“Access denied for user
ÎÒµÄϵͳÊÇubuntu6.06£¬×î½üÐÂ×°ºÃµÄmysqlÔÚ½øÈëmysql¹¤¾ßʱ£¬×ÜÊÇÓдíÎóÌáʾ:
# mysql -uroot -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
ʹÓÃÍøÉϽéÉܵķ½·¨ÐÞ¸ÄrootÓû§µÄÃÜÂ룺
# mysqladmin -uroot -p password 'newpassword'
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
ÏÖÔÚÖÕÓÚ±»ÎÒÕÒµ½Á˽â¾ö·½·¨£¬ÈçÏ£¨ÇëÏȲâÊÔ·½·¨Èý£¬Ð»Ð»£¡£©£º
·½·¨Ò»£º
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password: <ÊäÈëÐÂÉèµÄÃÜÂënewpassword>
mysql>
·½·¨¶þ£º
Ö±½ÓʹÓÃ/etc/mysql/debian.cnfÎļþÖÐ[client]½ÚÌṩµÄÓû§ÃûºÍÃÜÂë:
# mysql -udebian-sys-maint -p
Enter password: <ÊäÈë[client]½ÚµÄÃÜÂë>
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
# mysql -uroot -p
Enter password: <ÊäÈëÐÂÉèµÄÃÜÂënewpassword>
mysql>
Ïà¹ØÎĵµ£º
2009-12-08 18:53
sql½Å±¾Êǰüº¬Ò»µ½¶à¸ösqlÃüÁîµÄsqlÓï¾ä£¬ÎÒÃÇ¿ÉÒÔ½«ÕâЩsql½Å±¾·ÅÔÚÒ»¸öÎı¾ÎļþÖУ¨ÎÒÃdzÆÖ®Îª“sql½Å±¾Îļþ”£©£¬È»ºóͨ¹ýÏà¹ØµÄÃüÁîÖ´ÐÐÕâ¸ösql½Å±¾Îļþ¡£»ù±¾²½ÖèÈçÏ£º
1¡¢´´½¨°üº¬sqlÃüÁîµÄsql½Å±¾Îļþ
ÎļþÖаüº¬Ò»Ð©ÁеÄsqlÓï¾ä£¬Ã¿ÌõÓï¾ä×îºóÒÔ;½á⣬ÎļþÄÚÈÝʾÀýÈçÏ£º
--´´½ ......
mysqlÆô¶¯ºÍ¹Ø±ÕÔ¼ÊøµÄ·½·¨(FOREIGN_KEY_CHECKS)
2009-07-06 16:43
MySQL»¹ÔÊý¾Ý¿â£¬½ûÓÃºÍÆôÓÃÍâ¼üÔ¼ÊøµÄ·½·¨(FOREIGN_KEY_CHECKS)
ÓÐʱ»¹ÔÊý¾Ý¿âʱ£¬ÒòΪ±íÓÐÔ¼Êøµ¼ÖÂ40014´íÎ󣬿ÉÒÔͨ¹ý¹Ø±ÕÍâ¼üÔ¼Êø£¬»¹Ô³É¹¦Ê±ÔÙÆôÓÃ
½ûÓÃ
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0
ÆôÓÃ
S ......
Ê×ÏÈÈ¥MySQL¹ÙÍøÏÂÔØMySQL connector/C++
http://dev.mysql.com/downloads/connector/cpp/1.0.html
ÏÂÔØµÚ¶þ¸ö°ü£¬windows32λ·Ç°²×°°æ£¨¸öÈ˾õµÃÕâ¸ö°ü¸É¾»£©¡£Ä¿Ç°µÄ°æ±¾ÊÇConnector/C++ 1.0.5¡£
Windows (x86, 32-bit), ZIP Archive
(mysql-connector-c++-noinstall-1.0.5-win32.zip)
½«Õû¸ö°ü½âѹµ½ÏîÄ¿Îļþ¼Ðϵ ......
mysql·þÎñÆ÷°²×°ÅäÖãº
1. sudp apt-get install mysql-server-5.0
2. ´´½¨¿âsecond_proxy, ΪsecProxyÌí¼ÓÓû§£ºgrant all privileges on second_proxy.* to secProxy@'%' identified by 'passwd';
3. ÉèÖÃmysql.user±íÈçÏ£º
+-----------+------------------+-------------------------------------------+
| Host& ......
±¸·ÝÓë»Ö¸´ÔÚÈκÎÊý¾Ý¿âÀïÃæ¶¼ÊǷdz£ÖØÒªµÄÄÚÈÝ£¬ÌرðÊÇËæ×ÅÊý¾ÝÁ¿µÄÔö¼Ó£¬±¸·ÝÎÊÌâ»áÔ½À´Ô½Í»³ö£¬Òò´Ë£¬ºÃµÄ±¸·Ý·½·¨Ó뱸·Ý²ßÂÔÊǷdz£ÖØÒªµÄ¡£½áºÏÎÒËù×öµÄÏîÄ¿±¾Éí£¬ÏÂÃæÖ÷Òª¾Íwindowsƽ̨ÏÂMySQL(5.0)Êý¾Ý¿âµÄ³£Óñ¸·ÝÓë»Ö¸´×öһЩ×ܽᡣ
1 Ïà¹Ø×¼±¸¹¤×÷
......