"Linux Notes" Nineth, add mariadb users, set permissions

First, log in to MySQL

Second, create the user

Create user [email protected] identified by ' Dev ';

Third, to the new user authorization database H_user permissions

Authorized

Grant all privileges the h_user.* to [email protected];

Refresh, take effect

Flush privileges;

can also be created and authorized at the same time (two or three steps)

Grant all privileges the h_user.* to [e-mail protected] identified by ' Dev ';

Four, to the local authority Dev

Authorized

Grant all privileges on * * to [email protected] identified by ' Dev ';

Refresh, take effect

Flush privileges;

"Linux Notes" Nineth, add mariadb users, set permissions