MySQL Open remote connection

MySQL Open remote connection:

Log in as root user MySQL

GRANT all privileges The wang.* to ' Wang ' @ '% ' of ' identified by ' Wang ';

Flush privileges;

Modifying a configuration file

Vi/etc/mysql/my.cnf

Put bind-address = 127.0.0.1 this line off

Restart database

Service MySQL Restart

Local Test Connection 3306 Port

Telnet 192.168.1.77 3306 if connected

Determine if the MySQL client is installed

which MySQL

/usr/bin/mysql

And then

Mysql-uwang-h192.168.1.77-p See if you can log in

This article is from the "Youth Deng Yong" blog, please be sure to keep this source http://dengyong.blog.51cto.com/8409869/1713994

MySQL Open remote connection