MySQL Setup does not connect after remote login

MySQL Setup does not connect after remote login

Reference: http://www.jb51.net/article/33813.htm

Http://www.jb51.net/article/58096.htm

By default, MySQL only allows log on locally, and if you want to turn on remote connections, you need to modify the/etc/my.cnf file

sudo vim/etc/mysql/my.cnf
Comment This line: bind-address=127.0.0.1

Save exit.
Mysql-u root-p

To grant permissions to users who require remote logins:

The code is as follows: Mysql>use mysql;mysql>Delete from user where user= ';(delete anonymous user)
Mysql> Grant all privileges on * * to ' root ' @ '% ' identified by ' 123 ' with GRANT option; (123 for password)
mysql> flush Privileges;

Exit MySQL (exit)

Then restart the MySQL service (sudo service MySQL restart)

Telnet command:
Mysql-h 125.216.231.188-u root-p (-H followed by the IP address of the host to be logged in)

MySQL Setup does not connect after remote login