My sql添加远程用户root密码为password

添加远程用户root密码为password 
grant all privileges on *.* to root@localhost identified by '123321' with grant option 
grant all privileges on *.* to root@"%" identified by '123321' with grant option->

grant all privileges on *.* to root@'%' identified by '123321' with grant option

否则ODBC连接会出现10060错误,无法连接的提示

 

posted @ 2017-06-12 17:17  realhopezj  阅读(254)  评论(0编辑  收藏  举报