This is part two of a 3-part guide to installing WordPress manually. If you want to install a web server on your local machine, view part one. If your web server is ready (on your machine or your hosting provider), it's time to create a new database.
Go to the /phpmyadmin directory in your home directory. If you are using XAMPP this means http://localhost/phpmyadmin. Otherwise type your home-directory address followed by /phpmyadmin.
Create a new database
On the left-side menu (under the phpMyAdmin logo), click 'new' to create a new database.
When the below window appears, choose a name for your database (we'll use 'wpdb') and click 'create'.
You will immediately get a notification saying that the database 'wpdb' (or whatever name you chose) has been created, and it will appear in the list of databases under the 'create' button.
Create a new user
Click on the new database you just created.
Now you need to create a user who will have access to this database and be able to create, read, update and delete (CRUD) its records. In the options panel on the top of your database, choose 'Privileges' and click 'Add user' under 'new':
Now fill the fields as indicated below. Choose a username (we chose 'wpdbuser'), and use 'localhost' as the host. (This step is especially important, as using '%' on localhost can give error during WordPress installation process.)To create a strong password you can simply click on generate, but remember to save the password you generated to a text file or in your personal records. You will need to supply this username and password to WordPress during installation. However, that doesn't mean you should use an easy password! Simply remember to save it somewhere only you have access to it.
Scroll down and you will see that the 'database for users' option is checked to 'Grant all privileges on database “wpdb”'. This is what you want, so just scroll to the bottom of the page and click 'Go' on the right corner.
On clicking go you should see the following notification:
CREATE USER 'wpdbuser'@'%' IDENTIFIED BY '***';GRANT USAGE ON *.* TO 'wpdbuser'@'%' IDENTIFIED BY '***' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;GRANT ALL PRIVILEGES ON `wpdb`.* TO 'wpdbuser'@'%';
This means that you have successfully created a MySQL database and a user who has all privileges on the database. You are now ready to install WordPress 4.0+ on the server.