====== MySQL: Create User ======

==== Create User ====

<code sql>
CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}';
</code>

==== Create User and Database ====

  * Usually, ''{user}'' == ''{db}''

<code sql>
CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}';

GRANT USAGE ON * . * 
TO '{user}'@'%' 
IDENTIFIED BY '{passwd}' 
WITH 
  MAX_QUERIES_PER_HOUR 0 
  MAX_CONNECTIONS_PER_HOUR 0 
  MAX_UPDATES_PER_HOUR 0 
  MAX_USER_CONNECTIONS 0 ;

CREATE DATABASE IF NOT EXISTS `{db}`;

GRANT ALL PRIVILEGES ON `{db}` . *  TO '{user}'@'%';
</code>

Simpler Alternative:

<code sql>
CREATE DATABASE IF NOT EXISTS `dbname` DEFAULT CHARACTER SET = 'utf8';
GRANT ALL ON `dbname`.* TO 'dbuser'@'dbhost' IDENTIFIED BY 'dbpass';
</code>

{{tag>admin database mysql sql}}