mysql 5.7版本的 安装流程 和 官方文档说明

mysql install

ref

官方文档：

mysql_doc

zip安装方式

Installing and Upgrading MySQL

网页右上角可以选择mysql版本

官方资料

总体步骤：

1. Extract the main archive to the desired install directory

   Optional: also extract the debug-test archive if you plan to execute the MySQL benchmark and test suite

2. Create an option file

3. Choose a MySQL server type

4. Initialize MySQL

5. Start the MySQL server

6. Secure the default user accounts

具体步骤：

1. Extract the main archive to the desired install directory

 Traditionally, the MySQL server is installed in C:\mysql. If you do not install MySQL at C:\mysql, you must specify the path to the install directory during startup or in an option file

解压到安装目录，如果不是C:\mysql，就需要在开始的时候或者在配置文件(option file)中指定安装路径。

2. Create an option file

If you need to specify startup options when you run the server, you can indicate them on the command line or place them in an option file.

用于在运行服务器时设置启动参数

关于option file的具体使用： Section 4.2.2.2, “Using Option Files”

会在哪里找这个配置文件呢？

it looks for option files in several locations, such as the Windows directory, C:\, and the MySQL installation directory (for the full list of locations, Section 4.2.2.2, “Using Option Files”)

• Windows directory

  • C:\> echo %WINDIR%
    

  • 一般是C:\WINDOWS

• MySQL installation directory

MySQL looks for options in each location first in the my.ini file, and then in the my.cnf file.

• 先找my.ini文件，再找my.cnf文件
• 避免混淆，就用my.ini就行

option file常用配置

[mysqld]
# 设置安装路径
basedir=E:/mysql
# 设置数据目录
datadir=E:/mydata/data

As of MySQL 5.7.6, the ZIP archive no longer includes a data directory. To initialize a MySQL installation by creating the data directory and populating the tables in the mysql system database, initialize MySQL using either --initialize or --initialize-insecure. For additional information, see Section 2.10.1, “Initializing the Data Directory”.

创建data目录

3. Choose a MySQL server type

Binary	Description
mysqld	Optimized binary with named-pipe support
mysqld-debug	Like mysqld, but compiled with full debugging and automatic memory allocation checking

使用mysqld就行

4. Initialize MySQL

To initialize the data directory, use the instructions at Section 2.10.1, “Initializing the Data Directory”.

进入到安装目录的bin目录：

mysqld --initialize --console

会在最后一行输出密码：

2022-09-29T15:35:34.834474Z 1 [Note] A temporary password is generated for root@localhost: ?eL1Uss,:bNI

5. Start the MySQL server

6. Secure the default user accounts

安装

设置环境变量，第一次安装时没有进入到mysql安装目录的bin目录，安装没成功；

修改密码：

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root-password';

主体步骤：

解压文件

设置my.ini文件

设置系统变量

# 安装mysql服务
mysqld install
# 出错了就用 remove 卸载
mysqld remove

# 初始化mysql
# 会输出到控制台，最后一行有默认密码
mysqld --initialize --console 

# 开启mysql服务
# 注意，第一次启动时，应该进入到bin目录，否则可能会报：
# 			发生系统错误 2 系统找不到指定的文件
# 后面再次启动时，就只要在以管理员运行cmd的终端就行
net start mysql

# 登录
mysql -u root -p

# 修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root-password'

ALTER USER 'root'@'localhost' IDENTIFIED BY 'mysqlpbc'

其他命令：

# 关闭服务
mysqladmin -u root -p shutdown

一些问题

MySQL 服务正在启动 .MySQL 服务无法启动。