mysql常用命令

1、创建用户并赋权限

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

2、导入导出数据库

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