mysql

mysql权限速查

https://www.cnblogs.com/Richardzhu/p/3318595.html

更新权限

flush  privileges ;

更新密码
use mysql;

update user set password=password('新密码') where user='root';

查看用户权限

show grants for '用户名'@'localhost';

回收权限

revoke [权限1，权限2...] on 某库.某表 from 用户名@'主机名/IP';

mysql权限速查

https://www.cnblogs.com/Richardzhu/p/3318595.html