Show all users, MySQL basic operation

Can be implemented to display all users in the database. Select User from Mysql.user;select User,host,password from Mysql.user;to create a user for a table, authorize:

The Create user command:

<!---->mysql> CREATE USER yy identified by '123';

YY indicates the user name you want to create, and the following 123 indicates the password

The user created above can log in anywhere.

If you want to restrict landing at a fixed address, such as localhost login:

<!---->mysql> CREATE USER [email protected] identified by '123';

Grant

<!---->mysql> GRANT all privileges on *. * to user; @localhost

<!---->Grant Select,insert,update,delete on * * to [e-mail protected] "%" identified by "ABC";

Grant Select,insert,update,delete on * * to [e-mail protected] "%" identified by "ABC";

Format: Grant Select on database. * To User name @ login host identified by "password"

Change Password:

<!---->mysql> Grant all privileges the pureftpd.* to [e-mail protected] identified by ' Mimi ';

Flush

<!---->mysql> Flushprivileges;

To view user information:

<!---->mysql> Select Host,user from Mysql.user;

Show all users, MySQL basic operation