# 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> ```