解压版mysql的配置与设置密码开启远程连接

mysql默认是没有密码的，用户名是 root。

进入shell

.\mysql –u root
mysql>show databases;
mysql>use mysql;
mysql> UPDATE user SET password = PASSWORD ( "123456" ) WHERE user = 'root' ;
mysql>FLUSH PRIVILEGES ; 
mysql>QUIT

 select host,user,plugin from mysql.user;

开启远程登录

update mysql.user set host ='%' where user='root' and host='localhost';