mysql root远程登陆

修改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 '****';