MySQL常用命令

1. 给root加密码：/usr/bin/mysqladmin -u root password 123456

2. 导出：mysqldump -u root -p dbname > file.sql

3. 导入：mysql -u root -p dbname < backup-file.sql

4. 授权：grant all on *.* to root@"%" identified by "密码";

         例如： grant select on pk.video to video@"localhost" identified by "video";

5. 收回权限：revoke all privileges on *.* from root@"%";

6. 登录：mysql -u root -p

7. 查看数据库：show databases;

8. 使用数据库：use test;

9. 查看表：show tables;

10.查看数据库详细表信息：SHOW FULL TABLES FROM dbname WHERE table_type = 'BASE TABLE';
11.查看字段详细信息：SHOW FULL FIELDS FROM dbname.tablename;

12.查看主键：SHOW KEYS FROM  dbname.tablename;

13查看建表语句：SHOW CREATE TABLE dbname.tablename;