MySQL常用命令

-- 创建数据库用户test
mysql> create user test identified by 'password';

-- 删除数据库用户test
mysql> drop user 'test'@'%';;

-- 将数据库test赋予用户qhmydbuser经由192.168.*.*的ip远程访问
mysql> grant all privileges on test.* to 'test'@'192.168.%.%' identified by 'password';

 
-- 查看用户授权表
mysql > select user, password, host from user; 

-- 取消授权
mysql> revoke update on test.* from 'test'@'192.168.%.%';

-- 创建数据库test
mysql> create database test default character set utf8 collate utf8_general_ci;

-- 删除数据库
mysql > drop database test;

-- 备份数据库test至backup.sql
shell> mysqldump -hlocalhost -uroot -p test > backup.sql

-- 将bakcup.sql导入test数据库
shell> mysql -hlocalhost -uroot -p test < backup.sql