linux mysql 8.0启动不了_【Linux】【mysql】mysql8.0开启远程访问及常见问题

1.连接数据库

1 [root@localhost ~]# mysql -uroot -p2 Enter password:3 Welcome to the MySQL monitor. Commands end with ; or \g.4 Your MySQL connection id is 175 Server version: 8.0.17 MySQL Community Server - GPL6

7 Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.8

9 Oracle is a registered trademark of Oracle Corporation and/or its10 affiliates. Other names may be trademarks of their respective11 owners.12

13 Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.14

15 mysql>

2.在mysql8版本中更改用户密码需要加入with mysql_native_password

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

';2 Query OK, 0 rows affected (0.04 sec)

3.修改root用户的host为‘%’

1 mysql> show databases;2 +--------------------+3 | Database |4 +-------------