# MySQL 建立新使用者及更改權限
* 創建使用者及設定密碼
`mysql> CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';`
* 提供使用者權限
`mysql> GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';`
* 重新載入權限
`mysql> FLUSH PRIVILEGES;`
參考自 [How To Create a New User and Grant Permissions in MySQL](https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql)
###### tags: `MySQL`