Create a user and assign permissions to MySQL under Linux

Fe_group User Name
Fe database name
123456 Password

1. Create a new user

Login mysql@>mysql-u root-p@> Password//create user mysql> insert into Mysql.user (Host,user,password) VALUES (' localhost ', ' Fe_group ', password (' 123456 '));//Refresh the System permissions table Mysql>flush privileges; This creates a user named: fe_group password 123456. Log in after exiting mysql>exit;@>mysql-u fe_group-p@> Enter password 123456mysql> login success

2. Authorizing the user

Log in to MySQL (with root privileges). I am logged in as root. @>mysql-u root-p@> Password//First create a database for the user (Fe) mysql>create db fe;//Authorization Fe_group user has all the permissions of the FE database @>grant all  privileges on fe.* to [e-mail protected] identified by ' 123456 ';//localhost is local access, other addresses cannot access,% is all @>grant all privileges on Fe.* to [e-mail protected] '% ' identified by ' 123456 ';//Refresh the System permissions table Mysql>flush privileges;

　　

Create a user and assign permissions to MySQL under Linux