在Windows 10平台下的MySQL-5.7.15-winx64安装

一、下载

　　1.在官网上下载MySQL对应的版本：https://downloads.mysql.com/archives/community/

　　2.下载完成解压到指定路径：

二、配置MySQL

　　在mysql-5.7.15-winx64目录下，复制my-default.ini命名为my.ini。

　　配置my.ini文件

<span style="color: #ff0000">[</span><span style="color: #ff0000">mysql</span><span style="color: #ff0000">]</span><span style="color: #000000">
# 设置mysql客户端默认字符集
</span><span style="color: #0000ff">default</span><span style="color: #808080">-</span><span style="color: #0000ff">character</span><span style="color: #808080">-</span><span style="color: #0000ff">set</span><span style="color: #808080">=</span><span style="color: #000000">utf8
</span><span style="color: #ff0000">[</span><span style="color: #ff0000">mysqld</span><span style="color: #ff0000">]</span><span style="color: #000000">
# 设置3306端口
port </span><span style="color: #808080">=</span> <span style="color: #800000; font-weight: bold">3306</span><span style="color: #000000"> 
skip</span><span style="color: #808080">-</span><span style="color: #0000ff">grant</span><span style="color: #808080">-</span><span style="color: #000000">tables
# 设置mysql的安装目录
basedir</span><span style="color: #808080">=</span>D:\Program Files (x86)\mysql<span style="color: #808080">-</span><span style="color: #800000; font-weight: bold">5.7</span>.<span style="color: #800000; font-weight: bold">15</span><span style="color: #808080">-</span><span style="color: #000000">winx64
# 设置mysql数据库的数据的存放目录
datadir</span><span style="color: #808080">=</span>D:\Program Files (x86)\mysql<span style="color: #808080">-</span><span style="color: #800000; font-weight: bold">5.7</span>.<span style="color: #800000; font-weight: bold">15</span><span style="color: #808080">-</span><span style="color: #000000">winx64\data
# 允许最大连接数
max_connections</span><span style="color: #808080">=</span><span style="color: #800000; font-weight: bold">200</span><span style="color: #000000">
# 服务端使用的字符集默认为8比特编码的latin1字符集
</span><span style="color: #0000ff">character</span><span style="color: #808080">-</span><span style="color: #0000ff">set</span><span style="color: #808080">-</span>server<span style="color: #808080">=</span><span style="color: #000000">utf8
# 创建新表时将使用的默认存储引擎
</span><span style="color: #0000ff">default</span><span style="color: #808080">-</span>storage<span style="color: #808080">-</span>engine<span style="color: #808080">=</span>INNODB

三、安装MySQL服务

　　1.以管理员身份运行cmd，并指定到MySQL安装位置bin文件下，运行mysqld install 安装

　　2.使用mysqld --initialize 初始化data目录，在安装目录下出现data初始化数据文件夹

四、修改密码

　　1.启动mysql服务;

　　2.进入mysql 数据库，修改密码

mysql<span style="color: #808080">></span> <span style="color: #0000ff">use</span><span style="color: #000000"> mysql;
</span><span style="color: #0000ff">Database</span><span style="color: #000000"> changed
mysql</span><span style="color: #808080">></span> <span style="color: #0000ff">update</span> mysql.<span style="color: #ff00ff">user</span> <span style="color: #0000ff">set</span> authentication_string<span style="color: #808080">=</span>password(<span style="color: #ff0000">‘</span><span style="color: #ff0000">zxm5312</span><span style="color: #ff0000">‘</span>) <span style="color: #0000ff">where</span> <span style="color: #ff00ff">user</span><span style="color: #808080">=</span><span style="color: #ff0000">‘</span><span style="color: #ff0000">root</span><span style="color: #ff0000">‘</span><span style="color: #000000">;
Query OK, </span><span style="color: #800000; font-weight: bold">1</span> row affected, <span style="color: #800000; font-weight: bold">1</span> warning (<span style="color: #800000; font-weight: bold">0.00</span><span style="color: #000000"> sec)
Rows matched: </span><span style="color: #800000; font-weight: bold">1</span>  Changed: <span style="color: #800000; font-weight: bold">1</span>  Warnings: <span style="color: #800000; font-weight: bold">1</span><span style="color: #000000">
mysql</span><span style="color: #808080">></span> flush <span style="color: #0000ff">privileges</span><span style="color: #000000">;
Query OK, </span><span style="color: #800000; font-weight: bold">0</span> rows affected (<span style="color: #800000; font-weight: bold">0.00</span> sec)<br><br>mysql> set password=password(‘zxm5312‘);<br>Query OK, 0 rows affected, 1 warning (0.00 sec)

　　3.退出mysql 服务，注释掉配置文件中skip-grant-tables，然后重新启动mysql 服务登陆mysql 数据库。

<span style="color: #ff0000">[</span><span style="color: #ff0000">mysql</span><span style="color: #ff0000">]</span><span style="color: #000000">
# 设置mysql客户端默认字符集
</span><span style="color: #0000ff">default</span><span style="color: #808080">-</span><span style="color: #0000ff">character</span><span style="color: #808080">-</span><span style="color: #0000ff">set</span><span style="color: #808080">=</span><span style="color: #000000">utf8
</span><span style="color: #ff0000">[</span><span style="color: #ff0000">mysqld</span><span style="color: #ff0000">]</span><span style="color: #000000">
# 设置3306端口
port </span><span style="color: #808080">=</span> <span style="color: #800000; font-weight: bold">3306</span><span style="color: #000000"> 
# skip</span><span style="color: #808080">-</span><span style="color: #0000ff">grant</span><span style="color: #808080">-</span>tables <span style="color: #ff0000">[</span><span style="color: #ff0000">将此处注释掉</span><span style="color: #ff0000">]</span><span style="color: #000000">
# 设置mysql的安装目录
basedir</span><span style="color: #808080">=</span>D:\Program Files (x86)\mysql<span style="color: #808080">-</span><span style="color: #800000; font-weight: bold">5.7</span>.<span style="color: #800000; font-weight: bold">15</span><span style="color: #808080">-</span><span style="color: #000000">winx64
# 设置mysql数据库的数据的存放目录
datadir</span><span style="color: #808080">=</span>D:\Program Files (x86)\mysql<span style="color: #808080">-</span><span style="color: #800000; font-weight: bold">5.7</span>.<span style="color: #800000; font-weight: bold">15</span><span style="color: #808080">-</span><span style="color: #000000">winx64\data
# 允许最大连接数
max_connections</span><span style="color: #808080">=</span><span style="color: #800000; font-weight: bold">200</span><span style="color: #000000">
# 服务端使用的字符集默认为8比特编码的latin1字符集
</span><span style="color: #0000ff">character</span><span style="color: #808080">-</span><span style="color: #0000ff">set</span><span style="color: #808080">-</span>server<span style="color: #808080">=</span>utf8<br><br>

在Windows 10平台下的MySQL-5.7.15-winx64安装

标签：word   family   ring   安装   windows   注释   x86   ini文件   版本