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';