本文已参与「新人创作礼」活动，一起开启掘金创作之路。
mysql install
ref
官方文档：
Installing and Upgrading MySQL
网页右上角可以选择mysql版本
官方资料
总体步骤：
-
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
-
Create an option file
-
Choose a MySQL server type
-
Initialize MySQL
-
Start the MySQL server
-
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_HOME
输入安装目录
# path中add
%MYSQL_HOME%/bin
但第一次安装时，除了以管理员安装cmd，还应该进入到bin目录执行安装目录，否则可能执行不成功，报：
发生系统错误 2。 系统找不到指定的文件。
修改密码：
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
一些问题
\
