MySQL8设置允许远程连接

创建一个远程连接用户，‘hadoop’@’%’（hadoop是用户名，%是允许任意远程主机连接）

mysql> create user 'hadoop'@'%' identified by '123456';
Query OK, 0 rows affected (0.08 sec)

mysql> grant all PRIVILEGES on hadoop.* to 'hadoop'@'%' with grant option;
Query OK, 0 rows affected (0.09 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)

mysql>

允许本地连接

mysql> create user 'hadoop'@'localhost' identified by '123456';
Query OK, 0 rows affected (0.13 sec)

mysql> grant all PRIVILEGES on hadoop.* to 'hadoop'@'localhost' with grant option;
Query OK, 0 rows affected (0.10 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.18 sec)

mysql>

备注：hadoop.* 中hadoop是数据库名称，*是任意表名，即表示将hadoop数据库的所有表操作权限授予

【参考】