1. 问题:mysql启动报错
[root@localhost ~]# service mysqld restart
Another MySQL daemon already running with the same unix socket.
Starting mysqld: [FAILED]
解决方法:
[root@localhost ~] mv /var/lib/mysql/mysql.sock/var/lib/mysql/mysql.sock.bak
[root@localhost ~]# service mysqld restart
2. 问题:navicat连接mysql:报1130错误
1130: Host xxx.xxx.xxx.xxx is notallowedto connect to this MySQL server
解决方法:
mysql>usemysql
mysql>update user set host = '%' where user ='root';
mysql>flush privileges;
mysql>select 'host','user' from user where user='root';
mysql>quit
3.问题: navicat连接mysql:报1045错误
1045 Accessdenied for user 'root'@'localhost' (using password:YES)
解决方法:
/etc/init.d/mysqldstop
mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('123456') where USER='root';
mysql> FLUSHPRIVILEGES;
mysql> quit
/etc/init.d/mysqldrestart
4.问题: navicat连接mysql:报10060错误
Can't connect toMySQL server (10060)
解决方法:
http://database.51cto.com/art/201107/274565.htm(重点检查3306端口是否已经开放)
5.问题:如何创建其他账号远程连接mysql服务器
mysql>use mysql
mysql>GRANT ALL PRIVILEGES ON *.* TO 'sems_mysql'@'%' IDENTIFIED BY 'gziscassems' WITH GRANT OPTION;