MySQL 8.0 的安装及使用

admin

1. 安装了MySql 8，想用SqlYog远程连接，中途遇到问题，最终不仅重新安装了实例，还要保重如下：
用户（我用的root）host为%且plugin为mysql_native_password.


2.存储Json
https://www.cnblogs.com/Soy-technology/p/11050118.html


----
my.ini的位置

1. C:\ProgramData\MySQL\MySQL Server 8.0

复制代码

查看是否安装成功：

C:\Users\Administrator>mysqld -install
Service successfully installed.

启动MySql：

C:\Users\Administrator>net start mysql
MySQL 服务正在启动 .
MySQL 服务无法启动。

C:\Program Files\MySQL\MySQL Server 8.0\data 报错

2019-08-12T11:57:34.282069Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld (mysqld 8.0.17) starting as process 2824
2019-08-12T11:57:34.454669Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2019-08-12T11:57:34.455573Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2019-08-12T11:57:34.464049Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-08-12T11:57:34.466151Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld: Shutdown complete (mysqld 8.0.17)  MySQL Community Server - GPL.

参考文章:https://blog.csdn.net/github_38832708/article/details/83037241

移除MySQL服务：

1. C:\Users\Administrator>mysqld -remove MySQL
   
2. Service successfully removed.

复制代码

重新安装mysql服务：

1. C:\Users\Administrator>mysqld -remove MySQL
   
2. Service successfully removed.
   
3. 
   
4. C:\Users\Administrator>mysqld --initialize-insecure
   
5. 
   
6. C:\Users\Administrator>mysqld --install
   
7. Service successfully installed.
   
8. 
   
9. C:\Users\Administrator>net start mysql
   
10. MySQL 服务正在启动 ..
    
11. MySQL 服务已经启动成功。
    
12. 
    
13. 
    
14. C:\Users\Administrator>

复制代码

1. mysql> show databases
   
2.     -> ;
   
3. +--------------------+
   
4. | Database           |
   
5. +--------------------+
   
6. | information_schema |
   
7. | mysql              |
   
8. | performance_schema |
   
9. | sys                |
   
10. +--------------------+
    
11. 4 rows in set (0.01 sec)
    
12. 
    
13. mysql> select host,user,plugin from user;
    
14. ERROR 1046 (3D000): No database selected
    
15. mysql> use mysql
    
16. Database changed
    
17. mysql> select host,user,plugin from user;
    
18. +-----------+------------------+-----------------------+
    
19. | host      | user             | plugin                |
    
20. +-----------+------------------+-----------------------+
    
21. | localhost | mysql.infoschema | caching_sha2_password |
    
22. | localhost | mysql.session    | caching_sha2_password |
    
23. | localhost | mysql.sys        | caching_sha2_password |
    
24. | localhost | root             | caching_sha2_password |
    
25. +-----------+------------------+-----------------------+
    
26. 4 rows in set (0.00 sec)
    
27. 
    
28. mysql> alter user 'root'@'localhost' identified with mysql_native_password by '0314';
    
29. Query OK, 0 rows affected (0.03 sec)
    
30. 
    
31. mysql> flush privileges;
    
32. Query OK, 0 rows affected (0.02 sec)
    
33. 
    
34. mysql> select host,user,plugin from user;
    
35. +-----------+------------------+-----------------------+
    
36. | host      | user             | plugin                |
    
37. +-----------+------------------+-----------------------+
    
38. | localhost | mysql.infoschema | caching_sha2_password |
    
39. | localhost | mysql.session    | caching_sha2_password |
    
40. | localhost | mysql.sys        | caching_sha2_password |
    
41. | localhost | root             | mysql_native_password |
    
42. +-----------+------------------+-----------------------+

复制代码

进入数据库 ，将root的用户的host 属性  设置为%

1. mysql> use mysql
   
2. Database changed
   
3. mysql> update user set host='%' where user = 'root';
   
4. Query OK, 1 row affected (0.06 sec)
   
5. Rows matched: 1  Changed: 1  Warnings: 0
   
6. 
   
7. mysql> flush privileges;
   
8. Query OK, 0 rows affected (0.02 sec)
   
9. 
   
10. mysql>

复制代码