mysql服务器装好以后,默认只能在localhost上登录,如果你要是从另外的IP地址登录,即使是本机登录也会出现问题。
mysql -h 192.168.2.48 -u root -pwow8;
ERROR 1130 (00000): Host '192.168.2.48' is not allowed to connect to this MySQL server
查看mysql手册,1130表示如下
· 错误:1130 SQLSTATE: HY000 (ER_HOST_NOT_PRIVILEGED)
消息:不允许将主机'%s'连接到该MySQL服务器。
所以需要在mysql服务器上打开相应的权限,下面几步可以是root用户在所有的机器上以wow8登录
[zhoulei@localhost ~]$ mysql -u root;
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.1.59-log Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'wow8' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> quit;
Bye