Mysql > query user name

Procedure 1 Query users in the mysql database

SELECT host,user,authentication_string from mysql.user;

2 Create a mysql user

CREATE user ‘username ‘@’%’ IDENTIFIED BY’ username ‘;

3 Granting Permissions to the mysql user 3.1 Granting all permissions to the mysql user

GRANT ALL PRIVILEGES ON. TO ‘PRIVILEGES ‘@’%’ WITH GRANT OPTION;

3.2 Granting read, Delete, and update permissions to the specified database to the mysql user

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE,ALTER,DROP ON database name.* TO ‘username ‘@’%’ IDENTIFIED BY’ username ‘;