安装多个mysql及mysql服务

不念不忘少年蓝@ 2023-10-06 13:38 11阅读 0赞

### 在windows环境下安装多个mysql及mysql服务 ###

第一步：到官网下载所需的mysql，里面含有最新版本和历史版本  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 1]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 2]  
第二步：解压mysql文件创建data文件夹，和my.ini 文件  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 3]  
当多个mysql 服务时，一定要注意端口号不能相同  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 4]

# For advice on how to change settings please see
    # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
    # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
    # *** default location during install, and will be replaced if you
    # *** upgrade to a newer version of MySQL.
    
    [mysqld]
    #skip-grant-tables
    
    # Remove leading # and set to the amount of RAM for the most important data
    # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
    # innodb_buffer_pool_size = 128M
    
    # Remove leading # to turn on a very important data integrity option: logging
    # changes to the binary log between backups.
    # log_bin
    
    # These are commonly set, remove the # and set as required.
    basedir=H:\gzrj\mysql-5.7.30-winx64
    datadir=H:\gzrj\mysql-5.7.30-winx64\data
    # port = .....
    # server_id = .....
    
    max_connections=200
    # 允许连接失败的次数。这是为了防止有人从该主机试图攻击数据库系统
    max_connect_errors=10
    # 服务端使用的字符集默认为UTF8MB4
    character-set-server=UTF8MB4
    # 创建新表时将使用的默认存储引擎
    default-storage-engine=INNODB
    # 默认使用“mysql_native_password”插件认证
    default_authentication_plugin=mysql_native_password
    [mysql]
    # 设置mysql客户端默认字符集
    default-character-set=UTF8MB4
    [client]
    # 设置mysql客户端连接服务端时默认使用的端口
    port=3306
    default-character-set=UTF8MB4
    
    # Remove leading # to set options mainly useful for reporting servers.
    # The server defaults are faster for transactions and fast SELECTs.
    # Adjust sizes as needed, experiment to find the optimal values.
    # join_buffer_size = 128M
    # sort_buffer_size = 2M
    # read_rnd_buffer_size = 2M 
    
    #sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

第三步：打开开始，输入cmd,以管理员身份启动，在进去mysql的bin文件中  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 5]  
执行MySQL初始化命令，在指定的目录中（数据目录配置my.ini配置文件中）初始化数据库，及生成root用户和无密码；

mysqld --initialize --console

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 6]  
注意！\[注意\] \[MY-010454\] \[服务器\]为root @ localhost生成临时密码：hGlpK5tN)t>e，hGlpK5tN)t>e就是初始密码。在没有更改密码前，需要记住这个密码，后续登录需要用到。复制密码先保存起来!!!

安装mysql服务

执行下面的命令：

mysqld -install mysql5.7

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 7]

加入服务错误可以使用命令sc delete mysql5.7删除  
![在这里插入图片描述][20200726162244128.png]

这个时候会发现可执行文件路径会指向以往的mysql配置文件  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 8]  
需要到注册表那边修改

regedit

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 9]  
在该路径下有刚创建的mysql5.7服务，修改如图下的数值数据路径  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 10]  
修改后如图下  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 11]  
执行启动服务命令如图下，服务启动成功

net start mysql

![在这里插入图片描述][2020072616492875.png]  
至此安装成功  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 12]

修改密码可参考如下  
windows：

1，停止MYSQL服务，CMD打开DOS窗口，输入 net stop mysql  
2，在CMD命令行窗口，进入MYSQL安装目录 比如E:\\Program Files\\MySQL\\MySQL Server 5.0\\bin  
示范命令:  
输入 e:回车,  
输入cd “E:\\Program Files\\MySQL\\MySQL Server 5.0\\bin”  
注意双引号也要输入,这样就可以进入Mysql安装目录了.  
3，进入mysql安全模式，即当mysql起来后，不用输入密码就能进入数据库。  
命令为： `mysqld --console --skip-grant-tables --shared-memory` (注意-nt前面的空格!)  
4，重新打开一个CMD命令行窗口，输入mysql -u root -p，使用空密码的方式登录MySQL（不用输入密码，直接按回车）  
5，输入以下命令开始修改root用户的密码（注意：命令中mysql.user中间有个“点”）  
mysql> update mysql.user set password=PASSWORD(‘新密码’) where User=‘root’;

如果修改密码是不成功，就使用 ：

alter user 'root'@'localhost' identified by '新密码';

![在这里插入图片描述][dde3c7c717dd460e8d55136553e156d5.png]

6，刷新权限表  
mysql> flush privileges;  
7，退出  
mysql> quit  
这样MYSQL超级管理员账号 ROOT已经重新设置好了，接下来 在任务管理器里结束掉 mysql-nt.exe 这个进程，重新启动MYSQL即可！（也可以直接重新启动服务器）  
MYSQL重新启动后，就可以用新设置的ROOT密码登陆MYSQL了！

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200726153632762.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200726154250885.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200726154339710.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20200726155856819.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20200726173813899.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20200726155658556.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20200726164251182.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 7]: https://img-blog.csdnimg.cn/20200726162508835.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz,size_16,color_FFFFFF,t_70
[20200726162244128.png]: https://img-blog.csdnimg.cn/20200726162244128.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 8]: https://img-blog.csdnimg.cn/20200726162012859.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 9]: https://img-blog.csdnimg.cn/20200726162050467.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 10]: https://img-blog.csdnimg.cn/20200726162610355.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 11]: https://img-blog.csdnimg.cn/2020072616271029.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz,size_16,color_FFFFFF,t_70
[2020072616492875.png]: https://img-blog.csdnimg.cn/2020072616492875.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz_size_16_color_FFFFFF_t_70 12]: https://img-blog.csdnimg.cn/20200726173520424.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2ODk4MDMz,size_16,color_FFFFFF,t_70
[dde3c7c717dd460e8d55136553e156d5.png]: https://img-blog.csdnimg.cn/dde3c7c717dd460e8d55136553e156d5.png