mysql8.0 命令行不能进_8.0 以上版本 mySQL数据库导致的命令行可连接，NaviCat不可连接的问题...

错误代码: client does not support authentication

原因： 没有开启Mysql的远程连接配置

解决办法:

1 使用命令行进入数据库

C:\Users\wushaopei>mysql -u root -p

Enter password: ****

2 选着数据库  mysql   --> user mysql

mysql> use mysql;

Database changed

mysql> 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 |

+---------------------------+

33 rows in set (0.00 sec)

3 alter user 'root'@'localhost' identified with mysql_native_password by 'root';

mysql> alter user 'root'@'localhost' identified with mysql_native_password by 'root';

Query OK, 0 rows affected (0.01 sec)

4 flush privileges;

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)