Windows 访问CentOS上MySQL配置说明

要完成Windows上的客户端访问CentOS上的MySQL，就需要做到两点：关闭CentOS上防火墙；赋予数据库用户远程访问的权限，并清除权限的缓存，具体配置如下：[root@mysql ~]# service iptables stop
iptables: Flushing firewall rules: [ OK ]
iptables: Setting chains to policy ACCEPT: filter [ OK ]
iptables: Unloading modules: [ OK ]
[root@mysql ~]# mysql -uroot -proot
ERROR 1045 （28000）: Access denied for user"root"@"localhost"（using password:
[root@mysql ~]# mysql
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 4
Server version: 5.1.66 Source distributionCopyright （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> set password=password（"rootroot"）;
Query OK, 0 rows affected （0.00 sec）mysql> quit
Bye
[root@mysql ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 6
Server version: 5.1.66 Source distributionCopyright （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> quit
Bye
[root@mysql ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 11
Server version: 5.1.66 Source distributionCopyright （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> grant all on *.* to"root"@"%"identified by "rootroot";
Query OK, 0 rows affected （0.00 sec）mysql> flush privileges;
Query OK, 0 rows affected （0.00 sec）mysql>更多CentOS相关信息见CentOS 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=14Order By 的使用Oracle 11g RHEL 6.3 装缺少pdksh-5.2.14-1.i386.rpm相关资讯 Windows CentOS 本文评论查看全部评论（0）