使用 MySQL Workbench 新增 MySQL 資料庫
連線到 MySQL。
![](https://i0.wp.com/infoqme.com/wp-content/uploads/2020/05/image-3.png?fit=1024%2C769&ssl=1)
點選「Schemas」,在「sys 」按滑鼠右鍵,點選「Creat Schemas」。
![](https://i2.wp.com/infoqme.com/wp-content/uploads/2020/05/image-4.png?fit=1024%2C774&ssl=1)
輸入資料庫名稱,按「Apply」。
![](https://i2.wp.com/infoqme.com/wp-content/uploads/2020/05/image-5.png?fit=1024%2C774&ssl=1)
連續「Apply」即可。
![](https://i0.wp.com/infoqme.com/wp-content/uploads/2020/05/image-6.png?fit=1024%2C773&ssl=1)
![](https://i2.wp.com/infoqme.com/wp-content/uploads/2020/05/image-7.png?fit=1024%2C774&ssl=1)
建立資料庫 Entry
點選「Adminstration」\「User and Privileges」。
選擇 User ,點選「Schema Privileges」、「Add Entry…」。
![](https://i2.wp.com/infoqme.com/wp-content/uploads/2020/05/image-9.png?fit=1024%2C680&ssl=1)
點選「Selected schema」,選擇剛剛建立的 Schema。
![](https://i0.wp.com/infoqme.com/wp-content/uploads/2020/05/image-10.png?fit=1024%2C681&ssl=1)
點選「Select “ALL”」,即可完成新增資料庫。
![](https://i1.wp.com/infoqme.com/wp-content/uploads/2020/05/image-11.png?fit=1024%2C693&ssl=1)
使用 MySQL Workbench 刪除 MySQL 資料庫
點選「Schemas」,在想要刪除的資料庫上面按滑鼠右鍵,選「Drop Schema」。
![](https://i1.wp.com/infoqme.com/wp-content/uploads/2020/05/image-12.png?fit=1024%2C696&ssl=1)
點選「Drop Now」就會刪掉資料庫。
![](https://i0.wp.com/infoqme.com/wp-content/uploads/2020/05/image-13.png?fit=1024%2C697&ssl=1)