How to Set Up a Database for WordPress on My Website

Database Setup
1. Launch phpMyAdmin or a similar MySQL database tool.
2. Click 'Privileges' from the list of tasks. Scroll to the bottom of the list of databases displayed and click 'Add a New User.'

3. Enter a user name, which will also become the name of the database. Type '%' for the host, enter a password and retype the password. Click the radio button next to 'Create Database With the Same Name and Grant All Privileges.' Click 'Go' at the bottom-right of the screen.
4. Click the 'Databases' tab to display a list of databases. Scroll to the database you just created and click on it.
5. Click the 'Operations' tab and change the collation by selecting a different collation from the drop-down list box, for example: 'utf8_unicode_ci.' Click 'Go' after you've selected the new collation.
WordPress Setup
6. Open a command-prompt window and change to the directory of the WordPress installation. For example, type:cd /var/www/myblog
7. Create the WordPress configuration file by copying the sample configuration file in the directory. For example, type:cp wp-config-sample.php wp-config.php
8. Edit the WordPress configuration file in an HTML editor or in the Notepad. For example, type:nano wp-config.php
9. Scroll to the section of the file that begins with '** MySQL settings' and locate the three configuration statements for the name of the database, the database username and the database password.
10. Replace 'database_name_here' with the username/database name you entered when you created the database. Replace 'username_here' with the same name. Replace 'password_here' with the database password. Keep the single quotes surrounding each name in all three statements. Exit the editor and save the file.
11. Open a browser and navigate to the installation utility for the blog installation, for example: www.example.com/myblog/wp-admin/install.php. Verify that the installation program does not issue a database connection error and proceed with the WordPress installation.