mysql 5.7.17解压缩版本安装过程

Bertha 。 2022-06-14 02:39 94阅读 0赞

1.  第一步：去官网下载压缩包这个很简单，就不再赘述了 ，然后解压到一个合适的地方，我是直接在C盘解压的。
2.  第二步：配置环境变量 找到这个位置 C:\\Program Files (x86)\\Mysql\\mysql-5.7.17-winx64\\bin。你自己解压到什么地方就是哪个位置 。这是相对与我的电脑而言的，然后在系统变量的path中加上这个值。
3.  第三步：就是配置对应的my.ini文档，注意：5.7.17是有默认文档的，可以复制粘贴然后改为my.ini然后放入bin目录下
4.  不放入Bin目录会出错，反正我自己老是出问题。具体配置如下：
5.      # For advice on how to change settings please see
        # http://dev.mysql.com/doc/refman/5.7/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]
        
        # 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 = C:\Program Files (x86)\Mysql\mysql-5.7.17-winx64
        datadir = C:\Program Files (x86)\Mysql\mysql-5.7.17-winx64\data
        port = 3306
        character-set-server=utf8
        # server_id = .....
        
        
        [client]
        port=3306
        character-set=utf8
        
        
        # 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
    
    ![Image 1][]  
      
    
6.  第四步：在mysql根目录下新建data文件夹，安装前务必保证data为一个空文件夹。不新建也会出错的。
7.  第五：初始化以及安装步骤 ：
    
    以管理员身份运行cmd命令
    
    输入cd G:\\Program Files\\MySQL\\MySQL Server 5.7\\bin进入bin目录下
    
    输入mysqld --initialize --user=mysql --console
    
    记下最后一行产生的随机密码
    
    接着输入mysqld --install
    
    成功会显示Servers Successfully installed
    
    控制台下输入net start mysql 启动mysql服务
8.  可使用mysql -uroot -p命令来登录数据库，密码为上一步中生成的随机密码  
    
9.  第六步： 修改初始密码，按照随机密码登陆的很多操作不能进行。会报错：
    
    # [mac mysql error You must reset your password using ALTER USER statement before executing this statement.][] #
    
    需要按照以下操作改密码：
10. step 1: SET PASSWORD = PASSWORD('your new password');
    
    step 2: ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
    
    step 3: flush privileges;
    
    完成以上三步退出再登，使用新设置的密码就行了，以上除了红色的自己修改成新密码外，其他原样输入即可

[Image 1]: 
[mac mysql error You must reset your password using ALTER USER statement before executing this statement.]: http://www.cnblogs.com/debmzhang/p/5013540.html