mysql命令

连接数据库
mysql -h 127.0.0.1 -u root -p

创建数据库(先进入mysql)
create database db1;

删除数据库
drop database db1;

创建用户
create user 'user1'@'localhost' identified by '123456';
create user 'user1'@'%' identified by '123456'; #允许外网连接

授权
grant all on db1.* to 'user1'@'localhost';

显示用户权限
show grants for 'user1'@'localhost';

撤销用户权限
revoke all on db1.* from 'user1'@'localhost';

修改密码
set password for 'user1'@'localhost' = password('123456');
alter user 'user1'@'localhost' identified by 'Newpw.123'; #新版修改方式

修改全部初始账号密码
update user set password = password('123456');

删除用户
drop user 'user1'@'localhost';

刷新权限
flush privileges;

显示表结构
show fields from db1;