Confluence 6 MySQL CREATE DATABASE and database user

Once you have successfully installed and configured the MySQL database server, you need to create a database and database user for your confluence:

2. Run ' with Superuser in MySQL mysql . The default user is ' root ' and the password is empty.

4. Create an empty Confluence db instance (for example confluence ):
   

   CREATE DATABASE <database-name> CHARACTER SET utf8 COLLATE utf8_bin;

6. Create a Confluence database user (for example confluenceuser ):
   

   GRANT ALL PRIVILEGES ON <database-name>.* TO '<confluenceuser>'@'localhost'IDENTIFIED BY '<password>';

   If confluence does not run on the same server as your MySQL database, you will need to replace localhost to access your MySQL database's confluence server hostname or IP address for your confluence server.

Https://www.cwiki.us/display/CONFLUENCEWIKI/Database+Setup+For+MySQL

Confluence 6 MySQL CREATE DATABASE and database user