mysql常用命令

anmile

1、创建用户并赋权限

1. 1、 create user 'root'@'192.168.1.%' identified by 'password';
   
2. 2、 grant privileges on 数据库名[.表名] to user_name
   
3.        grant all privileges on *.* to 'root'@'192.168.1.%' identified by 'password';
   
4.        grant all privileges on *.* to 'root'@'192.168.1.%' identified by 'password' with grant option;
   
5. 3、 revoke privileges ON 数据库名[.表名] FROM user_name
   
6.        revoke all privileges on *.* from 'root'@'192.168.1.%'
7. 4、 flush privileges;
   
8. 5、 show grants for 'root'@'192.168.1.%';

2、导入导出数据库

1. 1、导出
   
2.    mysqldump -uroot -p'password' --opt --single-transaction database_name>database_name.sql
   
3.    或
   
4.    mysqldump -uroot -p -f --add-drop-tables database_name>database_name.sql
   
5. 2、导入
   
6.    mysql -uroot -p'password' -e "create database database_name default charset utf8;"
   
7.    mysql -uroot -p'password' database_name<database_name.sql