AUASOFT的博客

MySQL函数大全，MySQL常用函数汇总http://c.biancheng.net/mysql/function/

用户与授权：create user'rdroot'@'localhost' identified by 'auasoft#$89QW!'; 　　　　create user'rdroot'@'%' identified by 'auasoft#$89QW!';GRANT SELECT ON demo.aps_pudplan TO 'rdroot'@'%' IDENTIFIED BY ...

mysql7以前版本密码修改：set password for root@localhost = password('123');MySql8.0 root密码修改update user set authentication_string='' where user='root';--将字段置为空ALTER user 'root'@'localhost' IDENTIFIED ...