Wordpress Tutorial

Step 4: Set database and database users

Now login in your HostMonster account and find section »Databases«. Click the »MySQL Databases« icon.

First create new database. Just write »mydb« and click »Create Database«

Database was created. Click »Go Back«.

To make new user write desired username in the Username filed and desired passord in the field Password.

Retype password in the »Password (Again)« field.

Now in the Add User to Database section choose the database and user that you have just created.

Click on the Add button.

Write down on piece of paper your database name and user. As you might notice user and db have gotten prefix similar to »yourdomain1_«.

Now just check »ALL PRIVILEGES« checkbox and then click »Make Changes« button.

Now go back to the »FreeCommander« and right click on the »wp-config.php« file and then click »Edit..«

Now in the line »define('DB_NAME', 'putyourdbnamehere');« replace putyourdbnamehere with the database you have made.

Be careful to write whole username including prefix »yourdomain1_«. In my case db name is »futuris1_mydb«.

In the line »define('DB_USER', 'usernamehere');« replace username with your db username. In my case it’s »futuris1_frenky«.

In the line »define('DB_PASSWORD', 'yourpasswordhere');« replace password with your db password. In my case it’s »notgonnatellyou;)«.

The line containing »define('DB_COLLATE', '');« replace with: »define('DB_COLLATE', 'utf8_general_ci');«

Lines containing »AUTH_KEY, SECURE_AUTH_KEY, LOGGED_IN_KEY and NONCE_KEY« replace with randomly generated lines on this website: https://api.wordpress.org/secret-key/1.1/

Now your »wp-config.php« file will look similar to this:

Click »File->Save« to save file and then close it.