官網(wǎng)下載mysql8,https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.11-winx64.zip
1.解壓zip包到安裝目錄
比如我的安裝目錄是：D:\Program Files\MySQL
2.編寫配置文件
在D:\Program Files\MySQL目錄下創(chuàng)建my.ini文件
image
內(nèi)容如下:
[mysqld]
# 設(shè)置3306端口
port=3306
# 設(shè)置mysql的安裝目錄
basedir=D:\Program Files\MySQL
# 設(shè)置mysql數(shù)據(jù)庫的數(shù)據(jù)的存放目錄
datadir=D:\Program Files\MySQL\Data
# 允許最大連接數(shù)
max_connections=200
# 允許連接失敗的次數(shù)巷屿。這是為了防止有人從該主機(jī)試圖攻擊數(shù)據(jù)庫系統(tǒng)
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)證
default_authentication_plugin=mysql_native_password
[mysql]
# 設(shè)置mysql客戶端默認(rèn)字符集
default-character-set=utf8
[client]
# 設(shè)置mysql客戶端連接服務(wù)端時(shí)默認(rèn)使用的端口
port=3306
default-character-set=utf8
注意丸冕，里面的 basedir 是我本地的安裝目錄割坠，datadir 是我數(shù)據(jù)庫數(shù)據(jù)文件要存放的位置眉抬，各項(xiàng)配置需要根據(jù)自己的環(huán)境進(jìn)行配置遍略。
使用default_authentication_plugin=mysql_native_password是為了后續(xù)navicat可以遠(yuǎn)程連接
3.使用管理員身份打開CMD窗口初始化安裝
注意,一定要使用管理員身份
然后cd到D:\Program Files\MySQL\bin目錄下
執(zhí)行
mysqld --initialize --console
成功之后輸入如下:
D:\Program Files\MySQL\bin>mysqld --initialize --console
2018-12-04T03:26:47.785247Z 0 [System] [MY-013169] [Server] D:\Program Files\MySQL\bin\mysqld.exe (mysqld 8.0.13) initializing of server in progress as process 7748
2018-12-04T03:26:47.922126Z 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.
2018-12-04T03:27:05.431061Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: _nv04Hp%DXuc
2018-12-04T03:27:19.755014Z 0 [System] [MY-013170] [Server] D:\Program Files\MySQL\bin\mysqld.exe (mysqld 8.0.13) initializing of server has completed
注意,里面有一句
A temporary password is generated for root@localhost: _nv04Hp%DXuc
這個(gè)_nv04Hp%DXuc就是mysql為我們生成的一個(gè)臨時(shí)root密碼,務(wù)必記住
如果忘記了,就把mysql目錄刪掉重頭再來
4.安裝mysql服務(wù)
mysqld --install mysql
這里的mysql可以改為你想要自定義的,比如你機(jī)器上有很好幾個(gè)mysql,你可以起名為mysql8
安裝成功后,輸出是這樣的:
D:\Program Files\MySQL\bin>mysqld --install mysql
Service successfully installed.
5.啟動(dòng)mysql服務(wù)
直接執(zhí)行
net start mysql
6.登錄連接mysql
在命令行輸入:
mysql -u root -p
然后會(huì)提示你輸入密碼
這里的密碼就是第2步讓你記住的密碼
登錄成功后輸出如下
D:\Program Files\MySQL\bin>mysql -u root -p
Enter password: ************
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.13
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
可以執(zhí)行下
show databases
檢測下
7.修改root密碼
連接進(jìn)入后,直接輸入下面語句,我這里是將默認(rèn)密碼設(shè)置為123456,你可以修改為自己想要定義的.
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
8.允許遠(yuǎn)程連接訪問
執(zhí)行
use mysql;
然后查看下當(dāng)前連接允許情況
select host, user, authentication_string, plugin from user;
我這里的輸出如下:
mysql> select host, user, authentication_string, plugin from user;
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
| host | user | authentication_string | plugin |
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
| localhost | mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
| localhost | mysql.session | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
| localhost | mysql.sys | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
| localhost | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | mysql_native_password |
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
4 rows in set (0.00 sec)
然后執(zhí)行
CREATE USER 'root'@'%' IDENTIFIED BY 'root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
FLUSH PRIVILEGES;
這個(gè)時(shí)候再查看下權(quán)限,輸出如下
mysql> select host, user, authentication_string, plugin from user;
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
| host | user | authentication_string | plugin |
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
| % | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | mysql_native_password |
| localhost | mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
| localhost | mysql.session | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
| localhost | mysql.sys | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password |
| localhost | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | mysql_native_password |
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
5 rows in set (0.00 sec)
這個(gè)時(shí)候使用其他機(jī)器的客戶端工具,例如navicat就可以連接mysql了,如果還是連接不上,需要檢查windows防火墻是否是開啟的.
作者：程序魚
鏈接：http://www.reibang.com/p/2f3d3001599c
來源：簡書
著作權(quán)歸作者所有第焰。商業(yè)轉(zhuǎn)載請(qǐng)聯(lián)系作者獲得授權(quán)屹蚊，非商業(yè)轉(zhuǎn)載請(qǐng)注明出處末捣。
