暖暖爸爸的博客

方法1：用UPDATE直接编辑user表首先登录MySQL。mysql> use mysql; mysql> update user set password=password('root') where user='root' and host='localhost'; mysql> flush privileges;

创建用户create user 'sqy'@'%' identified by 'sqy';用户授权语法格式：GRANT privileges ON databasename.tablename TO 'username'@'host' ;例1：授予全部权限grant all on *.* to 'sqy'@'%';grant all on *.* to 'sqy'@'localhost';例2：