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