我们要将root账户设置为远程可访问

mysql> show databases;+--------------------+| Database           |+--------------------+| here               || information_schema || mysql              || performance_schema || sys                |+--------------------+ 选择mysql数据库

mysql> use mysql;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> show tables;+---------------------------+| Tables_in_mysql           |+---------------------------+| columns_priv              || component                 || db                        || default_roles             || engine_cost               || func                      || general_log               || global_grants             || gtid_executed             || help_category             || help_keyword              || help_relation             || help_topic                || innodb_index_stats        || innodb_table_stats        || password_history          || plugin                    || procs_priv                || proxies_priv              || role_edges                || server_cost               || servers                   || slave_master_info         || slave_relay_log_info      || slave_worker_info         || slow_log                  || tables_priv               || time_zone                 || time_zone_leap_second     || time_zone_name            || time_zone_transition      || time_zone_transition_type || user                      |+---------------------------+

mysql> update user set Host = '%' where User='root';Query OK, 1 row affected (0.13 sec)Rows matched: 1  Changed: 1  Warnings: 0 最后要刷新一下执行这个

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

然后就可以了