Create a Super User in mysql

After mysql is installed, a Super User Created in MySql has only one ROOT user with super management permissions, and the ROOT limit can only be used on the local database. What should we do if we want to remotely manage MySql? In fact, we need to add a Super User with super management permissions and remote access. We will add a super permission management user admin as an example. You can add new users by issuing the GRANT statement: first log ON to MySql with the ROOT user ON the database machine, and then: mysql> grant all privileges on *. * TO [email = admin @ localhost] admin @ localhost [/email] identified by 'something' with grant option; www.2cto.com mysql> grant all privileges on *. * TO [email = admin @ "%] admin @" % [/email] "identified by 'something' with grant option; in the first sentence, an admin user is added to authorize access through a local machine (localhost) with the password "something ". The second sentence is to authorize the admin user to initiate access from any other host (wildcard % ).