Windows 安装 mysql 5.7.27

转载自：https://zhangboyi.blog.csdn.net/article/details/100079636

1. 安装软件下载

百度云盘:  https://pan.baidu.com/s/1Bob80HghfLtKJ2l8FEiB4Q  密码:spvf

官网下载: https://dev.mysql.com/downloads/mysql/5.7.html#downloads

选择自己的版本下载

 

选这里跳过登录

 

2. 将下载后的压缩包解压

如图路径: D:\Tools\mysql-5.7.27-winx64

 

3. 创建配置文件  my.ini

创建一个空的文件 my.ini 内容如下 . 自行更改安装目录以及数据存放目录.

 数据存放目录需要自己手动创建 : D:\Tools\mysql-5.7.27-winx64\data

[mysql]
 
# 设置mysql客户端默认字符集
 
default-character-set=utf8 
 
[mysqld]
 
#skip-name-resolve
skip-grant-tables
 
#设置3306端口
 
port = 3306 
 
# 设置mysql的安装目录
 
basedir=D:\Tools\mysql-5.7.27-winx64
 
# 设置mysql数据库的数据的存放目录
 
datadir=D:\Tools\mysql-5.7.27-winx64\data
 
# 允许最大连接数
 
max_connections=200
 
# 服务端使用的字符集默认为8比特编码的latin1字符集
 
character-set-server=utf8
 
# 创建新表时将使用的默认存储引擎
 
default-storage-engine=INNODB

从C:\Program Files\Common Files\microsoft shared\ClickToRun 目录下
把 msvcr120.dll 和 msvcp120.dll
这两个文件复制到mysql的bin文件夹里面

 

4.配置环境变量

 

MYSQL_HOME

D:\Tools\mysql-5.7.27-winx64

 

 

 

Path

%MYSQL_HOME%\bin;

 

 

 

 

5. 注册 mysql 服务

管理员权限打开cmd命令
1.输入 mysqld --initialize-insecure --user=mysql 然后回车
2.再输入 mysqld -install 命令再回车

如果以上两个命令执行.如上图所示,说明mysql安装成功。

 

6. 开启 mysql 服务

 

启动MySQL服务，cmd命令窗口执行 net start mysql命令回车

 

7. 修改密码 

初始化root用户没有密码,密码为空.输入 mysql -u root -p 命令直接回车即可

出现以上情况说明你已进入MySQL服务

 

输入 ALTER user 'root'@'localhost' IDENTIFIED BY '123456' 命令直接回车
mysql> ALTER user 'root'@'localhost' IDENTIFIED BY '123456'

 

8. 开启远程登录

更改 mysql 数据库中的user 表, 使得 name 为 root 的账户对应的 host 为'%'

D:\Tools\mysql-5.7.27-winx64\bin>mysql -u root -proot
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.27 MySQL Community Server (GPL)
 
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
 
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
mysql>
mysql>
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)
mysql>
mysql>
mysql>
mysql> use mysql
Database changed
mysql>
mysql>
mysql> select user, host  from  user ;
+---------------+-----------+
| user          | host      |
+---------------+-----------+
| mysql.session | localhost |
| mysql.sys     | localhost |
| root          | localhost |
+---------------+-----------+
3 rows in set (0.00 sec)
mysql>
mysql>
mysql>
mysql> update user set host = '%' where user = 'root' ;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0
mysql>
mysql>
mysql>
mysql> select user, host  from  user ;
+---------------+-----------+
| user          | host      |
+---------------+-----------+
| root          | %         |
| mysql.session | localhost |
| mysql.sys     | localhost |
+---------------+-----------+
3 rows in set (0.00 sec)
mysql>
mysql>
mysql>
mysql> exit
 
 
Bye