Unable to connect to MySQL remotely, no permissions to create database after connection

Problem phenomenon:
Unable to connect to MySQL remotely, no permissions to create database after connection

Cause of the problem:
Mysql-server only allow native (localhost, 127.0.0.1) to connect access for security reasons. This is not a problem for the site architecture of Web-server and Mysql-server on the same server. However, as the site traffic increases, the late server architecture may place web-server and mysql-server on separate servers for greater performance, at which point Mysql-server is modified to allow web-server remote connections.

Workaround:
Log in to MySQL and add a super user to all IPs

Execute in turn, log in to MySQL with MySQL root account

GRANT  All Privileges  on *. *  to ' Root '@'%'by'123456'with  GRANTOPTIONprivileges;

Unable to connect to MySQL remotely, no permissions to create database after connection