root@mysql-dev-854848545-54vdq:/# mysql -uroot
mysql: [Warning] World-writable config file'/etc/mysql/my.cnf' is ignored.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 8.0.27 MySQL Community Server - GPL
Copyright (c)2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h'for help. Type '\c' to clear the current input statement.
mysql>
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
#如果没有host=%的,说明没有启用远程登陆的账户
update user sethost='%' where user='root';#给远程账户授权
Grant all privileges on root.* to 'root'@'%';#设置密码
ALTER USER'root'@'%' IDENTIFIED WITH mysql_native_password BY '${your password}';#刷新权限
flush privileges;exit;