Remote access to the MySQL database

After MySQL is installed, there is only one root user with super management permissions, and the root user is only allowed to be used on the local database. If we want remote management or other users need to access MySQL on my local machine, then we need to add a Super User with super management permissions and remote access. Here is a solution:

Log On with the root user, and then:
Grant all privileges on *. * to create the username @ "%" identified by "password ";

Flush privileges; * refresh the content just now *
Format: grant permission on database name. Table name to user @ login host identified by "User Password ";
@ Is followed by the IP address (or host name) of the client accessing MySQL; % represents any client. If localhost is set to local access (then this user cannot remotely access the MySQL database ).