个人博客网:https://wushaopei.github.io/ (你想要这里多有)
错误代码: 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)