mysql添加用户和用户权限和远程访问权限

From admin on 2014-01-07 20:35:19

1. 添加、修改用户

1.1 添加
insert into user(Host,User,Password) values('%','name','password');
1.2 修改密码
UPDATE user SET password=PASSWORD('123456') WHERE user='root';
2. 用户权限
grant 权限 on 数据库对象 to 用户
grant 权限 on 数据库对象 to 用户 identified by "密码"
eg.(newpassword为新密码)
grant all privileges on *.* to root@'%' identified by "newpassword";
<strong>最重要的：修改权限之后，不要忘记</strong>
FLUSH PRIVILEGES;