目錄
一.確認(rèn)Windows是否安裝MySQL
二.下載MySQL安裝包?
三.添加配置文件并安裝MySQL
四.登錄數(shù)據(jù)庫(kù)，修改密碼
五.配置環(huán)境變量
六.啟動(dòng)MySQL
一.確認(rèn)Windows是否安裝MySQL
1.按【W(wǎng)in+R】打開(kāi)運(yùn)行
2.輸入【services.msc】打開(kāi)服務(wù)
?3.在服務(wù)列表中查找MySQL，如果有mysql服務(wù)則表示W(wǎng)indows已經(jīng)安裝MySQL，如果沒(méi)有MySQL服務(wù)則表示W(wǎng)indows沒(méi)有安裝MySQL
?
二.下載MySQL安裝包?
1.進(jìn)入MySQL官網(wǎng)：點(diǎn)擊進(jìn)入，選擇Windows系統(tǒng)，點(diǎn)擊下載
2.選擇 No thanks, just start my download.
三.添加配置文件并安裝MySQL
1.將下載的zip包,解壓到想要安裝的目錄下
2.進(jìn)入解壓后的目錄，在bin同等級(jí)目錄下新建my.ini
3.編輯my.ini,將以下配置粘貼到my.ini
ps:需要注意的是basedir mysql的安裝路徑,要選擇你自己mysql 的安裝路徑,datadir 選擇數(shù)據(jù)存放的路徑,basedir?, datadir路徑使用正斜杠/ 或雙斜杠\\ 否則起不來(lái)服務(wù)
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[mysqld]
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
# These are commonly set, remove the # and set as required.
# 設(shè)置mysql的安裝目錄
basedir = D:/mysql-8.0.33-winx64/mysql-8.0.33-winx64
# 設(shè)置mysql數(shù)據(jù)庫(kù)的數(shù)據(jù)的存放目錄
datadir = D:/mysql-8.0.33-winx64/mysql-8.0.33-winx64/data
# 設(shè)置3306端口
port = 3306
# server_id = .....
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
# 允許最大連接數(shù)
max_connections = 200
# 允許連接失敗的次數(shù)。這是為了防止有人從該主機(jī)試圖攻擊數(shù)據(jù)庫(kù)系統(tǒng)
max_connect_errors = 10
# 服務(wù)端使用的字符集默認(rèn)為UTF8
character-set-server = utf8mb4
# 創(chuàng)建新表時(shí)將使用的默認(rèn)存儲(chǔ)引擎
default-storage-engine = INNODB
# 默認(rèn)使用“mysql_native_password”插件認(rèn)證
default_authentication_plugin = mysql_native_password
[mysql]
# 設(shè)置mysql客戶端默認(rèn)字符集
default-character-set = utf8mb4
[client]
# 設(shè)置mysql客戶端連接服務(wù)端時(shí)默認(rèn)使用的端口
port=3306
default-character-set = utf8mb44.在mysql安裝路徑下的bin目錄中使用cmd打開(kāi),輸入cmd并回車
5.輸入以下命令獲取生成的初始密碼,最好保存下,后期可能會(huì)用
mysqld --initialize --console
6.執(zhí)行第二條命令,安裝mysql服務(wù)并啟動(dòng)
mysqld --install mysql
?7.查看mysql服務(wù)是否已經(jīng)啟動(dòng),沒(méi)有啟動(dòng)的話,手動(dòng)啟動(dòng)mysql服務(wù)
四.登錄數(shù)據(jù)庫(kù)，修改密碼
1.在MySQL安裝目錄下的bin目錄下，啟動(dòng)cmd，進(jìn)入命令提示符后執(zhí)行以下命令
#連接數(shù)據(jù)庫(kù)
mysql -u root -p
#修改MySQL數(shù)據(jù)庫(kù)密碼，這里設(shè)置的用戶名為root，密碼為123456
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';五.配置環(huán)境變量
1.進(jìn)入系統(tǒng)高級(jí)設(shè)置,進(jìn)入環(huán)境變量設(shè)置
2.配置環(huán)境變量，這里變量值填寫MySQL的安裝路徑
3.?修改path變量,編輯path
六.啟動(dòng)MySQL
1.打開(kāi)cmd,執(zhí)行mysql -uroot -p輸入密碼,進(jìn)入MySQL
2.新增數(shù)據(jù)測(cè)試
【總結(jié)】
以上就是在Windows上安裝MySQL的全部步驟了。文章來(lái)源：http://www.zghlxwxcb.cn/news/detail-642166.html
如果哪里有不明白的可以私信哦~文章來(lái)源地址http://www.zghlxwxcb.cn/news/detail-642166.html
到了這里，關(guān)于在Windows上安裝MySQL數(shù)據(jù)庫(kù)（最最最詳細(xì)，超級(jí)簡(jiǎn)單）的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
