Creating the WordPress Database
Creating a database for your fresh WordPress install is most commonly the gateway for people to use phpMyAdmin for first time.
To install WordPress, on the database side you will need the following:
- A database name
- Username of database
- User password of database
Let’s see how we can set up all of these in phpMyadmin:
- A click on “Databases” will bring you to the following menu:
- Pick a name for your database and enter it in the “Create Database” field. Choose something that describes what the database is used for, it will be very helpful when you have more than one database running in the same place.
Next, choose a collation from the drop-down menu. Pick the one that fits best for your language and encoding. In most cases you should go with “utf8mb4_general_ci” for coding.
When you are done with this, click the “Create” button. The new database should then appear in the list.
- Next up you will have to create a user who has all access privileges to your newly created database. There are several ways to do so. The one that i find most convenient is to click on your newly created database. From there pick “Privileges.”
Clicking on “Add user account” will lead you to the screen where you can create a dedicated user for that database. Enter a user name in the respective field (make sure that “Use text field:” is selected from the drop-down menu) and then enter a hard-to-guess password. Again, make sure it says “Use text field” in front of it and don’t forget to write everything down so you don’t forget!
The “Host” field will most often be filled with “localhost”, however, you have to check with your provider for this.
Under “Database for User” make sure that the checkbox that says “Grant all privileges on database [your database name]” is enabled.
Now click “Go”
Congratulations, you now have the database name, username, and password you will need to install WordPress.