Ubuntu cannot remotely access after installing MySQL method
1.mysql>grant All privileges on * * to ' myuser ' @ '% ' identified by ' MyPassword ' with GRANT OPTION;
2.FLUSH rivileges;
3. See if the following record exists in the MySQL Library users table, and the presence of the representative setting is successful.
It should be ok under normal circumstances, but I still can't,
4. suspected network problem, run command test: Telnet IP address port
Return: Could not connect to ' xxx.xxx.xxx.xxx ' (Port 3306): Connection failed. Failure is a network problem.
5. go to Server Run command: NETSTAT-TPLN
There is a record: TCP 0 127.0.0.1:3306 0.0.0.0:* LISTEN 1601/mysqld in the middle of the 127.0.0.1:3306 description is local Listen, you need to change to 0.0.0.0:3306.
6. Modify the value of bind-address in the MySQL configuration file to 0.0.0.0
Configuration file location:/etc/mysql/my.cnf or/ETC/MYSQL/MYSQL.CONF.D/MYSQLD.CNF
Ubuntu cannot remotely access after installing MySQL method