Attackers can remotely access the MySQL database by breaking the ROOT user's restriction. After installing MySQL, only the ROOT user with the super management permission can be used only on the local database, if you want to remotely manage or access MySQL on your local machine, you need to add a Super User with super management permissions and remote access. The following is a solution: run the following SQL statement after logging on to MySQL as the root user:
Grant all privileges on *. * to the created username @ "%" identified by "password"; flush privileges; // refresh the content.
Statement format: grant permission on Database Name. table name to user @ login host identified by "User Password"; @ is followed by the Client IP address (or host name) to access MySQL; % represents any client, if localhost is set to local access (this user cannot remotely access the MySQL database ).