MySql:局域网和权限用户管理
MySql 5.6(XP)/5.7(win7) 添加用户和设置局域访问权限操作.请在 http://sourceforge.net/ 下载MySql Control Center(不是安装版本).
1 use mysql; 2 3 select * from user; 4 5 update user set authentication_string=password(‘0214‘) where user=‘geovindu‘; 6 7 update user set plugin=‘mysql_native_password‘ where user=‘geovindu‘;
1 #20150320 涂聚文 2 #系统数据库 MYSQL 5.6,5.7 3 4 use mysql; 5 6 select ‘host‘ from user where user=‘root‘; 7 8 select * from user where user=‘root‘; 9 #设置局域网访问 10 update user set host = ‘%‘ where user =‘root‘; 11 flush privileges; 12 13 select * from user; 14 #5.6 15 select Host,User,password from mysql.user; 16 #5.7 17 select Host,User,authentication_string from mysql.user;
use mysql; select * from user; #5.6以下 update user set password=password(‘0214‘) where user=‘geovindu‘; #5.7 update user set authentication_string=password(‘0214‘) where user=‘geovindu‘;
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。