MySQL A typical database build table build user process

• CMD command does not answer ";"
• MySQL command followed by ";"

1. Log in to MySQL as an administrator

Mysql-u root–p

2. Select MySQL Database

Use MySQL;

3. Create a user and set a password

Create user ' test ' @ ' localhost ' identified by ' 123456 ';

4. Make the Operation effective

Flush privileges;

5. Create a database for users

Create DATABASE TestDB;

6, give the user the operation database testdb all permissions

Grant all privileges the testdb.* to test@localhost identified by ' 123456 ';

7. Make the Operation effective

Flush privileges;

8. Log in with a new user

Mysql-u test–p

9. View all users and permissions in MySQL database

SELECT DISTINCT CONCAT (' User: ', user, ' @ ', host, '; ') as query from Mysql.user;

10. Display Database List

show databases;

11. Display the data table in the library

Use MySQL;

Show tables;

12. Quit MySQL

Quit

MySQL A typical database build table build user process