bitsCN.com
使用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 方法二 # /etc/init.d/mysql stop# mysqld_safe--user=mysql --skip-grant-tables --skip-networking &# mysql -u root mysqlmysql> UPDATE userSET Password=PASSWORD(&#39;newpassword&#39;) where USER=&#39;root&#39;;mysql> FLUSHPRIVILEGES;mysql> quit # /etc/init.d/mysqlrestart# mysql -uroot -pEnter 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"改成"%" mysql -u root -pmysql> 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 bitsCN.com