首先登陆
mysql -h 127.0.0.1 -P 4000 -u root -D test
show databases;
然后:
如果ip地址问题
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'test' WITH GRANT OPTION;
flush privileges;
如果没有密码:
use mysql;
update user set password=password('111111') where user='root';
flush privileges;