1, remote connection to the Linux system, login database: mysql-uroot-p (password)
2, modify the root account settings:
GRANT all privileges on * * to ' root ' @ '% ' identified by ' 123456 ' with GRANT OPTION;
Where ' root ' is the MySQL user name, ' 123456 ' is the root account password, modify other users to modify the corresponding parameters.
3. Execute flush privileges; order immediate effect
4.
Exit MySQL using the exit command
Then open vim/etc/mysql/my.cnf.
Will bind-address = 127.0.0.1
Set to Bind-address = 0.0.0.0 (device address)
Reboot (command below):
/etc/init.d/mysql stop
/etc/init.d/mysql start
5, set navicat connection, if there is the same problem, it should be 3306 port is restricted by the firewall, need to do the following settings:
Execution Vi/etc/sysconfig/iptables:
-A rh-firewall-1-input-m state--state new-m tcp-p TCP--dport 3306-j ACCEPT
Add this to the sentence, and note that this sentence must be added to the last sentence above. Otherwise it will not take effect.
Also if the other port to the "3306" switch to the appropriate port.
Then reboot the firewall.
Service Iptables Restart
Test the connection and connect successfully!
Remote connection to MySQL root account error: 2003-can ' t connect to MySQL serve