# 安裝 MySQL DB 兩種方式
###### tags: `public`

以下以win10為例

## ==1.XAMApp (較簡單)==
https://www.apachefriends.org/zh_tw/download.html

---

## ==2.MySQL官網 (不推薦)==
a.下載安裝管理器
https://dev.mysql.com/downloads/installer/
b.添加 MySQL Server和 Workbench
輸入密碼(要記好)
c.完成安裝

d.將b步驟2個執行起來
d-1 cmd輸入密碼，正確連線後的畫面
d-2 workbench 點設定，建立連線測試
完成後回到首頁會出現連線，點開
e.建表格和欄位
參考
https://ithelp.ithome.com.tw/articles/10215161

## 其他
express js 後端語法

  // "dependencies": {
  //   "express": "^4.18.1",
  //   "mysql": "^2.18.1"
  // }

var express = require("express");
var app = express();
app.listen(3000);
var mysql = require("mysql");
var conn = mysql.createConnection({
    user: "root",
    password: "你的密碼",
    host: "localhost",
    port: 3306,
    database: "class"
})
app.get('/', function (req, res) {
    conn.connect(function (error) {
        if (error) {
            res.send(JSON.stringify(error));
        }
        else {
            res.send("OK 3");
        }
    });
    
})

### Mysql 解决1251- Client does not support authentication protocol requested by server..

##### 原因 mysql8版本太新，加密模式改變
https://blog.csdn.net/lovedingd/article/details/106728292
https://waylau.com/node.js-mysql-client-does-not-support-authentication-protocol/

##### 解決 變更加密模式
select host,user,plugin,authentication_string from mysql.user;


ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '12345678';