mysql the default profile of the database My.cnf (Linux) bind-address defaults to 127.0.0.1, so even if you create a user that can remote access,
You also can not use the mysql-h command to access, if the access will have problems, because at this time MySQL only accept localhost, so need to put bind-address shielding. MY.CNF is generally under/etc/mysql, if the locate MY.CNF lookup is not used, the MY.CNF profile before the modification is: MY.CNF profile code before modification # Instead of skip-networking the Defaul
"T is" now "listen Only" # localhost which is more compatible and isn't less secure. bind-address = 127.0.0.1 # Instead of skip-networking ' The default is ' now ' to ' listen Only ' # localhost which is-more co
Mpatible and is not less secure. Bind-address = 127.0.0.1 What we need to do is block this bind-address code, after shielding code is: After shielding my.cnf configuration file code # Instead of skip-networking of the default
are now to listen only on # localhost which are more compatible and are not less secure. #bind-address = 127.0.0.1 # Instead of skip-networking ' The default is ' now ' to ' listen Only ' # localhost which is-more C
Ompatible and is not less secure. #bind-address = 127.0.0.1 Now you can use the mysql-h command to do what you want to do.