1.进入bin目录打开MYSQL
mysql -u root -p
2.创建远程连接用户
GRANT ALL PRIVILEGES ON *.* TO MAO@'%' IDENTIFIED BY 'MIAOMIAO' WITH GRANT OPTION;
3.使命令立刻执行
FLUSH PRIVILEGES;
4.查询数据库用户
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;