Windows下MySQL 5.6 免安装配置步骤

素颜马尾好姑娘i 2022-05-26 12:48 512阅读 0赞

###### 1.首先下载MySQL 5.6 免安装版 ######

我用的版本：链接：[https://pan.baidu.com/s/1vZ2EcadTq4Z–xhJF2mOtg][https_pan.baidu.com_s_1vZ2EcadTq4Z_xhJF2mOtg] 密码：6g1x  
如果需要其他版本的，可以自行到官网下载。

###### 2.解压MySQL压缩包 ######

将MySQL压缩包解压到自己指定的位置。  
我的位置为：D:\\DevelopmentTools\\mysql-5.6.19-winx64

###### 3.配置环境变量 ######

在Windows环境变量中配置path,在path后面增加MySQL的bin目录，例如：  
;D:\\DevelopmentTools\\mysql-5.6.19-winx64\\bin;  
**注意用分号“;”隔开**

###### 4.新建my.ini文件 ######

在MySQL目录下，新建一个my.ini

# 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]
    
    # 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:\\DevelopmentTools\\mysql-5.6.19-winx64
     datadir = D:\\DevelopmentTools\\mysql-5.6.19-winx64\\data
     port = 3306
    # server_id = .....
    
    
    # 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

###### 5.使用管理员身份打开cmd窗口并切换至MySQL\\bin目录 ######

进入MySQL的bin目录下，安装mysql

C:\Users\echo>D:
    D:\>cd Dev\mysql-5.6.19-winx64\bin
    D:\Dev\mysql-5.6.19-winx64\bin>mysqld –install // 安装mysql

###### 6.启动MySQL服务 ######

net start mysql

###### 7.初始化MySQL数据库 ######

mysqld --initialize-insecure --user=mysql;

###### 8.重启MySQL服务,重新打开一个cmd窗口 ######

###### 9.登录 ######

密码可为空，第一次登录，密码是空就行了

mysql -u root -p

###### 10.更改密码 ######