1.登陆数据库。mysql -uroot -p(密码)
2.创建用户用来远程连接
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
3.让更改的内容生效,到这里已经可以连接了
flush privileges;
也可以查看一下用户
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;