The method of online I tried all I can't, the current database user table two records below

Firewall I also shut down, as for the my. The CNF configuration file I didn't find, only to find a my under the installation directory. The ini and my - default. Inimy. Ini configuration below

Really don't know how to configure, forget to know the answer, I use sqllog

Sqllog connection as shown in figure

CodePudding user response:

The bind - address uncomment this line

CodePudding user response:

By definition you comment the bind - should address is ok, you change my. The CNF after restart the service?
Need to restart the mysql configuration file instead

CodePudding user response:

Look at the current information
Show variables like 'bind_address';

CodePudding user response:

The

reference 3 floor ZJCXC response:

take a look at the current informationShow variables like 'bind_address';

Configuration is right

CodePudding user response:

Telnet the port 3360 is not pass, is there a firewall

CodePudding user response:

The remote server firewall ports didn't open it, it is better to remote even look at the server port is not open

CodePudding user response:

Or screening from beginning to end.
1. By netstat to check on the server LISTEN 3306 information
2. The client can test whether PING server
3. P client to test whether a Telnet server port 3306