1. Create a new user
Log in to MySQL
@>mysql-u root-p
@> Password
Create user
mysql> INSERT INTO Mysql.user (Host,user,password) VALUES (' localhost ', ' Tanzuai ', Password (' 123456 '));
Refresh System Permissions Table
Mysql>flush privileges;
This creates a user named: Tanzuai with a password of: 123456.
Log in after exiting
mysql>exit;
@>mysql-u tanzuai-p
@> Enter password
Mysql> Login Successful
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 (TANZUAIDB)
Mysql>create database tanzuaidb;
Authorizing JEECN users to have all rights to the JEECN database
@>grant all on tanzuaidb.* to [e-mail protected] identified by ' 123456 ';
Refresh System Permissions Table
Mysql>flush privileges;
Mysql> Other operations
If you want to specify partial permissions to a user, you can write:
Mysql>grant select,update on tanzuaidb.* to [e-mail protected] identified by 123456;
Refreshes the System permissions table.
Mysql>flush privileges;
Mysql> grant permissions 1, permissions 2,... Permission n on the database name. Table name to User name @ user address identified by ' connection password ';
Permissions 1, Permissions 2,... Permission n represents 14 permissions, such as Select,insert,update,delete,create,drop,index,alter,grant,references,reload,shutdown,process,file.
When permissions 1, permissions 2,... Permission n is replaced by all privileges or all to give the user full permission.
When the database name. The table name is replaced by *. *, which indicates that the user is given permission to manipulate all tables on the server.
The user address can be localhost, or it can be an IP address, a machine name, and a domain name. You can also use '% ' to indicate connections from any address.
' Connection password ' cannot be empty, otherwise the creation failed.
For example:
Mysql>grant Select,insert,update,delete,create,drop on Vtdc.employee to [e-mail protected] identified by ' 123′;
Assign the user Tanzuai from 10.163.225.87 the ability to select,insert,update,delete,create,drop the employee table VTDC the database, and set the password to 123.
Mysql>grant all on vtdc.* to [e-mail protected] identified by ' 123′;
Assign the user Tanzuai from 10.163.225.87 to all operations on the database VTDC all tables, and set the password to 123.
Mysql>grant all on * * to [e-mail protected] identified by ' 123′;
Assign the user Tanzuai from 10.163.225.87 to all operations on all tables in all databases, and set the password to 123.
Mysql>grant all privileges on * * to [e-mail protected] identified by ' 123′;
Assign the native user Tanzuai permissions to all operations on all tables in all databases, and set the password to 123.
3. Delete a user
@>mysql-u root-p
@> Password
Mysql>delete from user WHERE user= "JEECN" and host= "localhost";
Mysql>flush privileges;
Delete a user's database
Mysql>drop database tanzuaidb;
4. Modify the specified user password
@>mysql-u root-p
@> Password
Mysql>update Mysql.user Set Password=password (' New password ') where user= "Tanzuai" and host= "localhost";
Mysql>flush privileges;
mysql>quit;
5. Build a table
CREATE TABLE Receive_user
(
Waybillno varchar (a) NOT null check (waybillno!= "),
Model varchar (NOT NULL),
UserID varchar () is not NULL,
Create_time datetime default NULL,
Primary KEY (Waybillno)
) Engine=innodb default Charset=utf8 auto_increment=1;
MySQL build user, build library, build table, authorize