首页 > 技术文章 > My sql添加远程用户root密码为password

realhope 2017-06-12 17:17 原文

添加远程用户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错误,无法连接的提示

 

推荐阅读