Linux系统MySQL数据库远程设置

Linux系统MySQL数据库远程设置

Linux系统MySQL数据库远程设置

1.启动服务和登陆 
[root@localhost ~]# /etc/init.d/mysqld restart
Stopping mysqld:                                          [  OK  ]
Starting mysqld:                                          [  OK  ]
[root@localhost ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.66 Source distribution
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

2.授权一个可以远程登陆的用户
mysql> grant all privileges on *.* to tong@'%' identified by 'system';    --创建一个远程用户
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;    --更新权限
Query OK, 0 rows affected (0.00 sec)
mysql>

3.关闭防火墙
[root@localhost ~]# /etc/init.d/iptables stop
iptables: Flushing firewall rules:                        [  OK  ]
iptables: Setting chains to policy ACCEPT: filter          [  OK  ]
iptables: Unloading modules:                              [  OK  ]
[root@localhost ~]#

4.用客户端工具可以登陆了
C:\Users\Administrator>mysql -h 远程IP -u tong -p    --tong是远程用户名
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 32
Server version: 5.5.19 MySQL Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

错误处理:

(1)防火墙没有关闭或防火墙没有过滤3306端口

图:

         
解决方法:   

[root@localhost ~]# /etc/init.d/iptables stop
iptables: Flushing firewall rules:                        [  OK  ]
iptables: Setting chains to policy ACCEPT: filter          [  OK  ]
iptables: Unloading modules:                              [  OK  ]
[root@localhost ~]#

或者:

[root@localhost ~]# vim /etc/sysconfig/iptables    --添加以下一行
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT

(2)密码输入错误

图:

       
解决方法:输入正确的密码，如果密码忘记了在服务器系统里修改一下

Linux 下MySQL的安装和远程设置