使用mysql时会遇到的问题_使用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 方法二

# /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:

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"改成"%"

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