目錄

1. 下載離線安裝包

2. 上傳解壓

3 配置 my.ini 文件

4 設(shè)置系統(tǒng)環(huán)境變量

5 安裝 MySQL

6 登錄 MySQL

?

客戶(hù)環(huán)境是內(nèi)網(wǎng)環(huán)境，不能訪問(wèn)外網(wǎng)，只能離線安裝 MySQL 了。

1. 下載離線安裝包

MySQL 離線壓縮包官網(wǎng)下載地址：MySQL :: Download MySQL Community Server (Archived Versions)

此次安裝 8.0.20 版本！

2. 上傳解壓

解壓后的文件目錄：

??????? 可以看到，默認(rèn)是沒(méi)有 data 文件夾和 my.ini 文件的，則需要我們自己手動(dòng)創(chuàng)建這兩個(gè)目錄和文件即可：

3 配置 my.ini 文件

[mysqld]
# 設(shè)置 3306 端口
port=3306

# 設(shè)置 mysql 的安裝目錄，即 bin 目錄
basedir="mysql 安裝目錄"

# 設(shè)置 mysql 數(shù)據(jù)庫(kù)的數(shù)據(jù)的存放目錄，即 data 目錄
datadir="mysql 安裝目錄再加上 \data"

# 允許最大連接數(shù)
max_connections=200

# 允許連接失敗的次數(shù)
max_connect_errors=10

# 服務(wù)端使用的字符集默認(rèn)為 utf8
character-set-server=utf8

# 創(chuàng)建新表時(shí)將使用的默認(rèn)存儲(chǔ)引擎
default-storage-engine=INNODB

# 默認(rèn)使用 “mysql_native_password” 插件認(rèn)證
#mysql_native_password
default_authentication_plugin=mysql_native_password

[mysql]
# 設(shè)置 mysql 客戶(hù)端默認(rèn)字符集
default-character-set=utf8

[client]
# 設(shè)置 mysql 客戶(hù)端連接服務(wù)端時(shí)默認(rèn)使用的端口
port=3306
default-character-set=utf8

4 設(shè)置系統(tǒng)環(huán)境變量

?

5 安裝 MySQL

以管理員身份啟動(dòng) cmd 或 PowerShell 進(jìn)行以下操作：

Windows PowerShell
版權(quán)所有 (C) Microsoft Corporation。保留所有權(quán)利。

PS C:\Users\Administrator> cd E:\keymanTech\dbs\mysql-8.0.20-winx64\bin
PS E:\keymanTech\dbs\mysql-8.0.20-winx64\bin> mysqld --initialize --console
2023-02-14T06:59:51.688125Z 0 [System] [MY-013169] [Server] E:\keymanTech\dbs\mysql-8.0.20-winx64\bin\mysqld.exe (mysqld 8.0.20) initializing of server in progress as process 16856
2023-02-14T06:59:51.688225Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file 'E:\keymanTech\dbs\mysql-8.0.20-winx6in\share\errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2023-02-14T06:59:51.689181Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2023-02-14T06:59:51.712993Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-02-14T06:59:52.262250Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-02-14T06:59:53.741675Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: s-fqTBh.=7?e

但是在安裝過(guò)程中有報(bào)錯(cuò)信息：

[ERROR] [MY-010338] [Server] Can't find error-message file 'E:\xxx\mysql-8.0.20-winx6in\share\errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.

解決辦法：

查了很多教程最后發(fā)現(xiàn)是轉(zhuǎn)義字符出現(xiàn)了問(wèn)題：MySQL Bugs: #90364: Can't find error-message file

????????因?yàn)槲覀冊(cè)谂渲?MySQL 安裝目錄的時(shí)候，沒(méi)有將安裝目錄配置到根目錄下（就是 MySQL 解壓文件根目錄）或者沒(méi)有加雙斜杠：

• 錯(cuò)誤路徑：basedir="D:\\InstalledDevsoftware\\XXX"? 或 D:\InstalledDevsoftware\XXX
• 正確路徑：basedir="D:\\Devsoft\\mysql-8.0.20-winx64\\XXX"

還需要在 my.ini 多加一行內(nèi)容：

······
# 設(shè)置 mysql 的安裝目錄，即 bin 目錄
basedir="E:\\xxx\\mysql-8.0.20-winx64\\bin"

# 設(shè)置 mysql 數(shù)據(jù)庫(kù)的數(shù)據(jù)的存放目錄，即 data 目錄
datadir="E:\\xxx\\mysql-8.0.20-winx64\\data"

lc-messages-dir="E:\\xxx\\mysql-8.0.20-winx64\\share\\english"
······

再次執(zhí)行 mysqld --initialize --console 命令：

報(bào)另外一個(gè)錯(cuò)誤信息： [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.

解決辦法：清空 data 文件夾下的內(nèi)容即可！

再次執(zhí)行 mysqld --initialize --console 命令：

PS E:\keymanTech\dbs\mysql-8.0.20-winx64\bin> mysqld --initialize --console
2023-02-14T07:17:13.196681Z 0 [System] [MY-013169] [Server] E:\keymanTech\dbs\mysql-8.0.20-winx64\bin\mysqld.exe (mysqld 8.0.20) initializing of server in progress as process 19932
2023-02-14T07:17:13.196777Z 0 [Warning] [MY-010339] [Server] Using pre 5.5 semantics to load error messages from E:\keymanTech\dbs\mysql-8.0.20-winx64\share\english\. If this is not intended, refer to the documentation for valid usage of --lc-messages-dir and --language parameters.
2023-02-14T07:17:13.197450Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2023-02-14T07:17:13.219796Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-02-14T07:17:13.717398Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-02-14T07:17:15.254780Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: h5(rJyMiFKn0
PS E:\keymanTech\dbs\mysql-8.0.20-winx64\bin> mysqld --install
Service successfully installed.
PS E:\keymanTech\dbs\mysql-8.0.20-winx64\bin> net start mysql
MySQL 服務(wù)正在啟動(dòng) ...
MySQL 服務(wù)已經(jīng)啟動(dòng)成功。

在任務(wù)管理器中庫(kù)看到名為 MySQL 的服務(wù)：

6 登錄 MySQL

用前面隨機(jī)生成的密碼登錄：

PS E:\xxx\mysql-8.0.20-winx64\bin> mysql -u root -p
Enter password: ************

# 修改密碼
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '新密碼';

# 用新密碼登錄
PS E:\xxx\mysql-8.0.20-winx64\bin> mysql -u root -p
Enter password: **********

至此 MySQL 8 安裝成功！?。?span toymoban-style="hidden">文章來(lái)源地址http://www.zghlxwxcb.cn/news/detail-451132.html

到了這里，關(guān)于Windows 離線安裝 MySQL 8的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！