1. View databases and tables

1. How to log in MySQL？

mysql -u  user name  -p  password 

2. How to view all current databases ？

show databases;

3. How to use the specified database ？

use  Database name ;

4. How to view all data tables in the current database ？

show tables;

5. How to display the database of the current operation ？

select database();

6. How to display the currently logged in user ？

select user();

7. How to import database script files ？

source /Users/Desktop/init.sql

8. How to view the structure of a table ？

desc  Table name ;

9. How to view all data in a table ？

select * from  Table name ;