---
# System prepended metadata

title: 0519 mysql 環境設置與安裝

---

# 0519 mysql 環境設置與安裝 

mysql 下載方式

https://dev.mysql.com/downloads/mysql/
https://dev.mysql.com/downloads/windows/installer/8.0.html

![](https://hackmd.io/_uploads/SkVxXqBBn.png)

這兩個差在哪啊?
一個是離線下載
一個是直接下載完整檔案

---


![](https://hackmd.io/_uploads/BJP-m9BB2.png)
![](https://hackmd.io/_uploads/HyAZX5HS2.png)

---

新增一個使用者帳戶，並設置權限
![](https://hackmd.io/_uploads/SJhfQcrr2.png)

![](https://hackmd.io/_uploads/HJTN7qrBn.png)

![](https://hackmd.io/_uploads/S1wPQcrSh.png)

![](https://hackmd.io/_uploads/ry9YQqSSn.png)

![](https://hackmd.io/_uploads/Hy-q7qHBn.png)


---


市場上三大主流網頁和搭配的資料庫
php+MySQL
JSP+MySQL /SQL Server/Oracle....
ASP.Net+SQL Server


![](https://hackmd.io/_uploads/Bkp575HB2.png)

![](https://hackmd.io/_uploads/Hkqa7qBr2.png)
上圖演示了有沒有設定起始值的差異

![](https://hackmd.io/_uploads/r1f149BHn.png)

![](https://hackmd.io/_uploads/rJjyVqSr2.png)

![](https://hackmd.io/_uploads/S1zgEcBSn.png)

---

資料庫介面叫schmas

---

預設帳號root
帳號watcher
要記得密碼: 
密碼統一:P@ssw0rd
P@ssw0rd

## 設定登入環境
不用root，而是自己建立的帳號登入
![](https://hackmd.io/_uploads/HJ2m4cBr3.png)
![](https://hackmd.io/_uploads/Hk84VqBSn.png)
測試完畢後，就會把帳號加到登入目錄
測試完就會跳出一個測試成功嗎?
就可以加入了?
是的，之後就會跳回首頁
測試完一遍密碼就結束了

---

![](https://hackmd.io/_uploads/r1PDVcSr2.png)



---

https://mvnrepository.com/artifact/mysql/mysql-connector-java/8.0.33
```
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.33</version>
</dependency>


```
