Remember that you might need to grant the user account you used to connect to the server remote access privileges to connect to the MySQL server. Once you connect to the server you want to create the WordPress database on, click the New Schema icon and enter the name of the database in the Name field, as shown in the screenshot below.

While WordPress does create its own tables and fields, you’ll need to give WordPress access to a database that it can populate with its own schema. This article will show you how. Before we get into the meat and potatoes of creating a MySQL database for WordPress, we need to point some things out for clarity’s sake.

DB_PASSWORD: Enter the password for the database user. DB_HOST: Enter the database host, which is usually “localhost.” If your hosting provider uses a different database host, enter that instead. Your WordPress database is the backbone of your site, containing all your posts, user data, and settings.

WordPress accesses the database through a MySQL user account. The database user account is defined in the wp-config.php file. As such, this user must exist in MySQL. The user must also have rights to the database so that it can read and write data as required.