-- 登录默认账号 # mysql -uroot -p123456-- 创建用户 mysql> CREATE USER 'test'@'%' IDENTIFIED BY '123456'; mysql> flush privileges;mysql> use mysql;mysql> update user set host='%' where user='test'; mysql> flush privileges;-- 赋予远程访问权限 mysql> grant all privileges on *.* to test@'%'; mysql> flush privileges;mysql> create database db_test; mysql> use db_test; mysql> alter database db_test default character set utf8; mysql> set names utf8; mysql> exit -- 重启MySQL服务器 # systemctl restart mysqld-- 赋予远程访问权限快捷方式,不行就按上面的一步一步的操作,就行了 Mysql > GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION; Mysql > grant all privileges on *.* to 'test'@'%' identified by '123456' with grant option;