====== MySQL 添加/删除用户及修改用户权限 ======

<code>
mysql -p -u root
</code>


<code>
CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
</code>


<code>
CREATE DATABASE DBNAME;
</code>

<code>
GRANT ALL PRIVILEGES ON database.table TO 'user'@'localhost';
GRANT ALL PRIVILEGES ON database.* TO 'user'@'localhost';
GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost';

GRANT SELECT, INSERT, DELETE ON database.* TO 'user'@'localhost';
</code>


<code>
FLUSH PRIVILEGES;
</code>

<code>
DROP USER 'user'@'localhost'
</code>


===== Reference =====
  * https://kyup.com/tutorials/create-new-user-grant-permissions-mysql/