前提
之前一直用的是的是5.7,后来需要用到8.0,结果跟着网上资料一顿操作,自己的5.7也不能用了…后面又研究了下(装的时候我的电脑是没mysql的,都被我删干净了)
步骤
我下载的解压缩版本的mysql,5.7+8.0,我是都解压到D盘截图如下:
然后环境变量配置 如下
path中配置如下
我是常用mysql8.0所以配置成home的形式,
先正常安装 8.0,具体操作之前文章有写过,安装完成后自己检查下,成功安装后再进行下面的步骤.
第二个mysql(5.7)的安装
配置文件我还是用的是第一个的
只不过端口改成了3307,端口不能相同.
[mysqld]
port = 3307
basedir=D:\Mysql-5.7
datadir=D:\Mysql-5.7\data
max_connections=200
character-set-server=utf8
default-storage-engine=INNODB
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysql]
default-character-set=utf8
先管理员身份运行cmmd,停止mysql的服务,命令
net stop mysql
提示:在安装第二个mysql之前一定要先停止之前的mysql服务
- 切换到 mysql5.7的bin目录对mysql进行初始化
mysqld --defaults-file=D:\Mysql-5.7\my.ini --initialize --console
提示:执行完结果如下,记住这时候生成 的随机密码!
D:\Mysql-5.7\bin>mysqld --defaults-file=D:\Mysql-5.7\my.ini --initialize --console
2024-07-18T03:10:50.359928Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2024-07-18T03:10:50.360589Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2024-07-18T03:10:50.360596Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2024-07-18T03:10:50.477639Z 0 [Warning] InnoDB: New log files created, LSN=45790
2024-07-18T03:10:50.503622Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2024-07-18T03:10:50.583527Z 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: 561506b8-44b3-11ef-946f-00ffb4907943.
2024-07-18T03:10:50.585142Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2024-07-18T03:10:52.061117Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2024-07-18T03:10:52.061489Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2024-07-18T03:10:52.066779Z 0 [Warning] CA certificate ca.pem is self signed.
2024-07-18T03:10:52.508171Z 1 [Note] A temporary password is generated for root@localhost: ro7O,kjeg8;%
- 注册5.7的服务
之前是因为已经安装了8.0,mysql的服务名称是mysql所以这里要起个别的名字,为了方便,我这边叫的mysql57
mysqld --install MYSQL57
运行成功会显示Service successfully installed
提示:下面最重要的部门就是修改注册表了
3. win+r,输入regedit,回车打开注册表后找到
\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MYSQL57
然后修改ImagePath的值,根据自己的路径配置修改
"D:\Mysql-5.7\bin\mysqld.exe" --defaults-file=D:\Mysql-5.7\my.ini MySQL57
提示:注意双引号不要丢了!
后面就是将两个服务都启动,正常使用就行了,只不过采用可视化工具连接时记得端口号是3307.
小结
从头到尾安装没出错,要是有出错的留言可以一起探究讨论.