MySQL Database common operations

1. Authorization for all Users

GRANT all privileges on * * to ' user name ' @ '% ' identified by ' password '

2. Database-based operations

(1) Login MySQL database: mysql-u root-p, enter the password before entering

(2) View all databases: show databases;

(3) Delete a database: Drop database name

(4) Entering a database: Use database name

(5) View all tables for a database: show tables;

(6) View all records in a table: SELECT * FROM table name

(7) View all records in a table: Desc table Name

3. Import and export of data

Export of data

With command: mysqldump-u root-p database name > Export file name. sql

If you export the form, enter the table name after the database name.

Import of data

Create an empty database under the MySQL interactive command, and use this database to enter the command: The file name of the source import.

MySQL Database common operations