qq_44621891的博客

# 添加用户：insert into mysql.user(Host,User,Password,ssl_cipher,x509_issuer,x509_subject) values ("%","ysk",password("123456"),'','',''); #授权：grant select on test.* to 'ysk'@'%';#刷新：flush privileges;#查看授权情况SHOW GRANTS FOR allen;#删除用户：DROP USER allen;