首页 > 数据库 > mysql > 正文

mysql数据库远程连接开启方法
2016-04-11 10:26:39 点击:

mysql -u root -p123456进入mysql后分别执行以下命令:MySQL>use mysql;MySQL>GRANT ALL PRIVILEGES ON * * TO & 39;root& 39;@&

进入mysql  

mysql -u root  -p123456




进入mysql后分别执行以下命令:
 
MySQL>use mysql;
 
MySQL>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION ;
 
MySQL>FLUSH PRIVILEGES;



相关热词搜索:数据库 方法 mysql

上一篇:mysql_connect(): The mysql extension is deprecated and will be removed in the fu
下一篇:重启mysql提示MySQL server PID file could not be found!