Rented a VPS, ready to practical remote connection mysql error 10060 (account permissions have %), found no open port 3306 VPS, VPS on login after added in the Windows firewall exceptions and mysql port 3306, there is still no open port 3306, then simply turn off the Windows firewall, found 3306 still did not open, the server had been restarted, exactly what went wrong?

CodePudding user response:

Reprinted an article, you consider, perhaps useful

Open MySQL remote login account has two step:
1, make sure the firewall on the server didn't stop port 3306,
MySQL default port is 3306, you need to determine the firewall didn't stop port 3306, otherwise the remote is not through port 3306 to connect to the MySQL,
If you are installing a MySQL specifies the other port, please open you specify in the firewall MySQL to use the port number,
If you don't know how to set up your firewall on the server, please consult your server administrator,
2, increase allow remote connection MySQL user and authorization,
1) the first landing MySQL as root account
Click on the start menu in Windows host, run, type "CMD", enter the console, MySQL under the bin directory, and then enter the following command,
In the Linux host under the line command prompt enter the following command,
MySQL - uroot - p123456

123456 for the root password,
2) create a remote login user and authorize
Grant all PRIVILEGES on discuz. * to ted @ '123.123.123.123 identified by' 123456 '.

The above statement said it will discuz all permissions granted the authority to ted this user database, allowing ted user at this IP for remote login 123.123.123.123, ted a user's password is 123456, and set the
Following the analysis of all parameters:
All the PRIVILEGES that gives all permissions to the specified users, here also can be replaced by giving a specific permissions, such as: the select, insert, update, delete, create, drop, etc., the specific permission to use ", "half Angle between commas,
Discuz. * said permission is for which table above, discuz refers to a database, at the back of the * said to all the tables, which can reason out: all the table for all database authorization for "*. *", all for a database table authorization for "database name. *", for a certain table of a database authorization for "database name. The name of the table,"
You want to which user authorization, ted said it was user, the user can also can be non-existent user,
123.123.123.123 said to allow the IP address of the remote connection, if not restricted link of IP is set to "%",
123456 for the user's password,
Carried out the above statement, then perform the following statement, shall be effective immediately,
flush privileges;

Ps:
Installed MYSQL5.0, but other people when they visit my database server, always quote 10060 error, check the online, turned out to be the Windows firewall to MYSQL port 3306 to intercept, open the specific method is as follows:
Start - - the Windows firewall Settings - control panel, click on the "exception" - "add port", the name is: mysql, port: 3306, TCP protocol, and click "ok",
From: http://faq.comsenz.com/viewnews-140

CodePudding user response:

These all have no help to me, thank you

CodePudding user response:

Oh, shame

CodePudding user response:

Do you have a problem dealt with, I also met the same problem,

CodePudding user response:

1, use open the CMD, first to see if the port 3306 to monitor


2, close the firewall

3, still won't do, it is looking for a Linux server, using nmap tool sniffer port is on
Nmap -p 3306 IP

CodePudding user response:

1)

2) closed,
3) I is system of Windows server 2008 r2,

CodePudding user response:

Finally solved excuse me? Can provide the train of thought, thank you

CodePudding user response:

User table will root/localhost into root/%