====== More restrictive setup for [[sysadmin:mysql|MySQL]] ======

Create user
<code>
CREATE USER 'username'@'localhost' IDENTIFIED BY '&8hsdg';
</code>

Create database with utf-8
<code>
CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;
</code>

Grant rights
<code>
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, ALTER, DROP ON dbname.* TO 'username'@'localhost';
</code>