There are two major strides in opening MySQL's remote login account:
1. Determine that the firewall on the server does not block port 3306.
MySQL default port is 3306, need to determine the firewall does not block 3306 port, otherwise remote is unable to connect via 3306 port to MySQL.
If you specified a different port when you installed MySQL, open the port number that you specified for MySQL in the firewall.
If you don't know how to set up a firewall on your server, check with your server administrator.
2, add to allow remote connection to MySQL users and authorized.
1) First log in to MySQL with the root account
In the Windows Host, click Start menu, Run, enter "cmd", go to the console, MySQL Bin directory, and enter the following command.
In the Linux host, enter the following command at the command prompt line.
> mysql-uroot-p123456
123456 is the root user's password.
2) Create a remote login user and authorize
> Grant all privileges the discuz.* to [email protected] ' 123.123.123.123 ' identified by ' 123456 ';
The above statement means that all permissions to the Discuz database are granted to the TED user, allowing the TED user to remotely log on to the 123.123.123.123 IP and set the TED user's password to 123456.
All parameters are analyzed below:
All privileges means giving all permissions to the specified user, which can also be replaced by assigning a specific permission, such as: Select,insert,update,delete,create,drop, and so on, with the "," half-width comma separated by the specific permissions.
Discuz.* means that the above permissions are for which table, discuz refers to the database, followed by the * for all tables, it can be inferred that: for all of the database is authorized as "*. *" For all tables, the entire table for a database is authorized as "database name. *", A table for a database is authorized as the database name. Table name.
Ted indicates which user you want to authorize, and this user can be either an existing user or a non-existent user.
123.123.123.123 represents the IP address that allows remote connections, or "%" if you want to limit the IP of the link.
123456 is the user's password.
After executing the above statement, execute the following statement before it can take effect immediately.
> Flush Privileges;
Ps:
Installed MYSQL5.0, but others in the access to my database server, always reported 10060 error, the Internet to check, the original is Windows Firewall Port 3306 to intercept the MySQL, the specific opening method is as follows:
Start-Settings-control Panel-windows Firewall, click "Exceptions"-"Add Port", Name: MySQL, Port: 3306,tcp protocol, click "OK" on it.
windows open 3306 port access MySQL