MySql: Lan and permission user management, mysql permission user management
MySql 5.6 (XP)/5.7 (win7) Add users and set local access permissions operations. Please in http://sourceforge.net/download MySql Control Center (not installed ).
Http://dev.mysql.com/doc/refman/5.7/en/grant.html
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 tu juwen 2 # System database 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 # set LAN access 10 update user set host = '%' where user = 'root'; 11 flush privileges; 12 13 select * from user; 14 #5.615 select Host, User, password from mysql. user; 16 #5.717 select Host, User, authentication_string from mysql. user;
Use mysql; select * from user; # update user set password = password ('000000') where user = 'geovindu' below 5.6 '; #5.7 update user set authentication_string = password ('20140901') where user = 'geovindu ';