修改root 密码
mysql -u root
>use mysql
> update user set password=PASSWORD('***') where user='root';
查看一下:
>select host,user from user;
修改:
>grant all privileges on *.* to 'root'@'%' identified by '*******';
>flush privileges;
再用远程转接时就可以发现OK了!
新增用户
insert into mysql.user(Host,User,Password) values("localhost","wordpress",password("kingdee"));
grant select ,insert,update,delete on wordpress.* to identified by '****';
阅读(2380) | 评论(0) | 转发(0) |