记录一下已有mysql8的情况下安装mysql5

最新推荐文章于 2024-07-16 14:09:23 发布

Smallzhou？

最新推荐文章于 2024-07-16 14:09:23 发布

阅读量123

点赞数

文章标签： mysql sql

本文链接：https://blog.csdn.net/weixin_44264204/article/details/134660770

版权

E:\mysql-5.7.44-winx64\bin>mysqld --initialize --console
2023-11-28T01:58:18.443097Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-11-28T01:58:18.515512Z 0 [Warning] InnoDB: New log files created, LSN=45790
2023-11-28T01:58:18.535227Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2023-11-28T01:58:18.615933Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 99dbb680-8d91-11ee-935b-9c2dcd7086ce.
2023-11-28T01:58:18.620646Z 0 [Warning] Gtid table is not ready to be used. Table ‘mysql.gtid_executed’ cannot be opened.
2023-11-28T01:58:19.096781Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2023-11-28T01:58:19.097037Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2023-11-28T01:58:19.099256Z 0 [Warning] CA certificate ca.pem is self signed.
2023-11-28T01:58:19.165470Z 1 [Note] A temporary password is generated for root@localhost: i=nL*Q1Pg:qz

E:\mysql-5.7.44-winx64\bin>mysqld --install mysql5
Service successfully installed.

E:\mysql-5.7.44-winx64\bin>mysql -u root -p
Enter password: ************
ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)

E:\mysql-5.7.44-winx64\bin>mysql -u root -p
Enter password: ************
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.44 MySQL Community Server (GPL)

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

成功！！！