mysql账号管理

· 常用命令
创建数据库：create database databasename;
查看数据库：show databases;
创建用户：create user 'username'@'%' identified by 'password';
创建用户：grant select,insert,update,delete on dbname.* to username@'%' identified by "password";
分配权限：grant ALL PRIVILEGES on *.* to 'superadmin'@'%' with grant option;
设置生效：flush privileges;
查看用户：use mysql; select user,host,password from user; select user();
删除匿名账号：delete from user where user='';
更改密码：update user set password=password("newpwd") where user="root";
查看变量：show variables;
查看指定变量：select @@session.old_passwords,@@global.old_passwords;
设置指定变量：set @@session.old_passwords=0;
删除用户：drop user username;
查看权限：show grants;