MySQL configuration instructions for accessing CentOS on Windows

To access MySQL on CentOS from a Windows client, you need to disable the firewall on CentOS, grant the database user remote access permission, and clear the permission cache. The specific configuration is as follows:

[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 distribution

Copyright (c) 2000,201 2, 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 distribution

Copyright (c) 2000,201 2, 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 distribution

Copyright (c) 2000,201 2, 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>