MySQL 5.7.22加压缩版安装方法

1.下载压缩包

可以使用中科大的镜像网址：http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-5.7.22-winx64.zip

2.系统环境配置

加压缩文件
在系统变量中配置：D:\Apps\mysql-5.7.22-winx64\bin
在D:\Apps\mysql-5.7.22-winx64下新建my.ini文件并做相应配置

3.初始化安装

mysql install

出现错误：
计算机丢失MSVCP120.dll，MSVCR120.dll
安装vcredist_x64.exe，下载地址：Visual C++ Redistributable Packages for Visual Studio 2013

D:\Apps\mysql-5.7.22-winx64\bin>mysqld install
Service successfully installed.

D:\Apps\mysql-5.7.22-winx64\bin>mysqld --initialize

D:\Apps\mysql-5.7.22-winx64\bin>net start mysql
MySQL 服务正在启动 .........
MySQL 服务已经启动成功。


D:\Apps\mysql-5.7.22-winx64\bin>mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.22 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, 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> update mysql.user set authentication_string=password('mysql123') where us
er='root';
Query OK, 1 row affected, 1 warning (0.02 sec)
Rows matched: 1  Changed: 1  Warnings: 1

4.配置远程登录

如果my.ini中注释掉bind-address 一般是可以远程登录的，注意，由于家庭网络和校园网络一般都是多个用户共用一个ip所以其他外网用户无法远程登录你的mysql，但是内网用户可以使用内网地址登录你的mysql

mysql -h 172.29.231.45 -uroot -p