Mysql安装window

Mysql安装在window，保姆级安装

一、Mysql安装包的下载

官网下载地址：mysql安装包下载

二、下载完毕后解压

如下图所示，但是还没有my.ini文件

不会新建记得把这个东西打开

所以下面我们新建一个my.ini文件,之后填入data注意(此处修改成自己的!!)

[mysqld]
# 设置3306端口
port=3306
# 设置mysql的安装目录   ----------是你的文件路径(此处修改成自己的!!斜杆方向不是\)------------- 
basedir=D:/mysql/mysql-5.7.44-winx64
# 设置mysql数据库的数据的存放目录  ---------是你的文件路径data文件夹(此处修改成自己的!!)自行创建
datadir=D:/mysql/mysql-5.7.44-winx64/data
# 允许最大连接数
max_connections=200
# 允许连接失败的次数。
max_connect_errors=10
# 服务端使用的字符集默认为utf8mb4
character-set-server=utf8mb4
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
# 默认使用“mysql_native_password”插件认证
#mysql_native_password
default_authentication_plugin=mysql_native_password
[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8mb4
[client]
# 设置mysql客户端连接服务端时默认使用的端口
port=3306
default-character-set=utf8mb4

三、Mysql初始化

进入上面mysql文件夹的bin目录下,然后就输入框上面打入cmd之后按下enter键进入命令行

输入指令↓

mysqld --initialize --console

如果出现ERROR/例如下面错误

D:xxx\xxx\mysql\mysql-5.7.44-winx64\bin>mysqld --initialize --console
mysqld: Can't create directory 'D:\soybean_file\software\mysql\mysql-5.7.44-winx64\bin\ oybean_file oftware\mysql\mysql-5.7.44-winx64\data\' (Errcode: 2 - No such file or directory)
2023-11-25T01:50:41.051652Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-11-25T01:50:41.052141Z 0 [ERROR] Can't find error-message file 'D:\soybean_file\software\mysql\mysql-5.7.44-winx64\bin\ oybean_file oftware\mysql\mysql-5.7.44-winx64\share\errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2023-11-25T01:50:41.059582Z 0 [ERROR] Aborting #出现以上错误说明ini文件打错了

检查自己的/是不是打成\了，如果出现了下面这个东西，那说明初始化成功了

D:xxx\xxx\mysql\mysql-5.7.44-winx64\bin>mysqld --initialize --console
2023-11-25T01:54:14.650990Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-11-25T01:54:15.561600Z 0 [Warning] InnoDB: New log files created, LSN=45790
2023-11-25T01:54:15.844174Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2023-11-25T01:54:16.026196Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 8a064627-8b35-11ee-bd4c-00ffc598a956.
2023-11-25T01:54:16.061171Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2023-11-25T01:54:16.828904Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2023-11-25T01:54:16.830905Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2023-11-25T01:54:16.835294Z 0 [Warning] CA certificate ca.pem is self signed.
2023-11-25T01:54:16.958387Z 1 [Note] A temporary password is generated for root@localhost: jwwl?Xws/1/u

而我这里的密码是：'jwwl?Xws/1/u’很难记到时候可以改

四、启动Mysql

直接输入两条指令:

mysqld --install #初始化
net start mysql #启动
mysql -uroot -p #输入密码 成功登录数据库
net stop mysql #停止mysql服务

成功示例:↓

D:xxx\xxx\mysql\mysql-5.7.44-winx64\bin>mysqld --install
Service successfully installed.

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

五、可视化工具链接

这边使用的是Navicat也可以使用其他如datagrip、sqlyog等工具:链接地址就为本地127.0.0.1(localhost),密码为上面mysql插件生成的密码

之后链接成功,开始编写sql语句吧

六、修改密码

mysql -uroot -p #输入密码 成功登录数据库
mysql> alter user 'root'@'localhost' identified by '你的密码'; #方式一
mysql> set password=password("你的密码"); 方式二

修改为你的密码即可

成功案例：↓

mysql> alter user 'root'@'localhost' identified by '123456';
Query OK, 0 rows affected (0.00 sec)