1、去官網(wǎng)https://www.mysql.com/downloads/下載安裝包,選擇社區(qū)版,選擇32位或者64位,因?yàn)槲业碾娔X是64位,所以我選擇的是64位下載



2、下載后的安裝包解壓,將文件放在指定目錄(自由選擇)下,我放在了D:\XXT\MySQL目錄下

3、管理員權(quán)限下啟動(dòng)cmd命令行窗口,然后進(jìn)入mysql的bin目錄下(D:\XXT\MySQL\mysql\bin)


4、輸入安裝命令mysqld -install,提示【Service successfully installed】表明已經(jīng)安裝成功,如果已經(jīng)安裝過了則提示【The service already exists!】

5、輸入命令mysqld –initialize,我這里有報(bào)錯(cuò)【can not create test file ......?can not set datadir to?D:\XXT\MySQL\mysql\data ....Abroting],然后百度一搜解決方案是更換命令為【mysqld --initialize --user=mysql --console】,這里命令行給出了root賬戶的登陸密碼,啟動(dòng)服務(wù)后用該密碼登陸


6、在MYSQL的解壓目錄mysql下新建一個(gè).ini格式文件my.ini,然后以記事本格式打開寫入下面代碼:?

[mysqld]
basedir=D:\XXT\MySQL\mysql
datadir=D:\XXT\MySQL\mysql\data
port=3306
7、輸入net start mysql ,啟動(dòng)服務(wù),我這里報(bào)錯(cuò)可能是之安裝啟動(dòng)過服務(wù),現(xiàn)在又重新安裝了一次,解決辦法是輸入【mysqld –remove】命令將原本已安裝的mysql服務(wù)卸載掉,再輸入【mysqld –install】命令將服務(wù)重新安裝

8、輸入命令【mysql -u root -p】登錄,密碼為步驟5的米密碼

9、修改root賬戶密碼, set password for root@localhost='123456';【set password for root@localhost=pssword('123456');會(huì)報(bào)語法錯(cuò)誤ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'password('123456')' at line 1】

10、至此mysql的安裝工作正式完成,可以安裝個(gè)連接數(shù)據(jù)庫軟件比如navicat、CRT
11、navicat連接數(shù)據(jù)庫報(bào)錯(cuò),用以下命令輸入mysql之后可以連接成功
use mysql;
alter user 'root'@'localhost' identified with mysql_native_password by '********';
flush privileges;


