mysql5.8 zip版本部署搭建

清疚 2022-11-15 12:51 97阅读 0赞

参考博文

[https://www.jianshu.com/p/1f7a6b0a8d6d][https_www.jianshu.com_p_1f7a6b0a8d6d]

上面链接写的很详细了，不赘述了。

我记录下最关键的几步，备份下：

第1步：解压zip。创建配置文件放在 D:\\common\\mysql-8.0.23-winx64\\  目录下

[mysqld]
    # 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 = D:\common\mysql-8.0.23-winx64\
    datadir = D:\common\mysql-8.0.23-winx64\data
    port = 3306
    # server_id = .....
    
    default_authentication_plugin=mysql_native_password
    
    # 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 
    
    character-set-server = utf8mb4
    
    performance_schema_max_table_instances = 600
    table_definition_cache = 400
    table_open_cache = 256
    
    [mysql]
    default-character-set = utf8mb4
    
    [client]
    default-character-set = utf8mb4

第2步：初始化数据库

-- 注意：执行日志会生成root账户的初始密码
    D:\common\mysql-8.0.23-winx64\bin\mysqld --initialize --console

会得到下图的临时密码：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3JhaW55c3ByaW5nNDU0MA_size_16_color_FFFFFF_t_70][]

第3步：安装服务（用管理员的cmd）

D:\common\mysql-8.0.23-winx64\bin\mysqld --install mysql8

第4步：启动服务

net start mysql8

补充 ：停掉服务是

net stop mysql8

第5步：用刚刚的临时密码登录 ，然后修改密码

mysql -uroot -p 回车后，输入刚刚的临时密码 -- 就是步骤2生成的临时密码
    
    -- 注意配置选项【my.ini】
    -- [mysqld]
    -- 设置默认使用mysql_native_password插件认证
    -- default_authentication_plugin=mysql_native_password
    ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'j2ee';
    
    --退出
    exit;

--------------------

如果中间过程出了问题，想重来一遍，可以将服务停止后移除服务，再将data目录全部删除，从第2步重来一遍

[https_www.jianshu.com_p_1f7a6b0a8d6d]: https://www.jianshu.com/p/1f7a6b0a8d6d
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3JhaW55c3ByaW5nNDU0MA_size_16_color_FFFFFF_t_70]: /images/20221022/6f6e66ad56cd4c1ca32ca5e0496b92bb.png