[mysql]使用MySQL时遇到的问题整理

楼主^#

更多发布于：2012-09-24 15:12


	使用MySQL时遇到的问题整理 1 ERROR 2002(HY000): Can't connect to local MySQL server through socket' /var/lib/mysql/mysql.sock'(2) 未启动MySQL MySQL的问题 2 ERROR 1045(28000): Access denied for user 'root'@'localhost' (using password: NO) 密码错了，修改root用户的密码： 2.1 方法一 mysqladmin -uroot -ppassword 'newpassword' 2.2 方法二 www.atcpu.com # /etc/init.d/mysql stop # mysqld_safe--user=mysql --skip-grant-tables --skip-networking ; # mysql -u root mysql mysql> UPDATE userSET Password=PASSWORD('newpassword') where USER='root'; mysql> FLUSHPRIVILEGES; mysql> quit # /etc/init.d/mysqlrestart # mysql -uroot -p Enter password: <输入新设的密码newpassword> 3 Can'tconnect to MySQL server on '192.168.10.31' (10060) IP写错了, 或者端口没有开放. 4 ERROR 1130:Host '192.168.1.3' is not allowed to connect to this MySQL server 4.1 改表法在localhost的那台电脑，登入mysql后，更改"mysql"数据库里的"user"表里的"host"项，从"localhost"改成"%" www.atcpu.com mysql -u root -p mysql> use mysql; mysql> update userset host = '%' where user = 'root'; mysql> select host,user from user; 4.2 授权法 mysql> grant all privilegeson . to 'yourname'@'%' identified by 'youpasswd'; Query OK, 0 rowsaffected (0.05 sec) mysql> flushprivileges; Query OK, 0 rowsaffected (0.06 sec) mysql> exit