This is a step-by-step visual guide to create a MySql database using a “Control Panel” provided by a hosting provider. The database will be empty and can be used, for example, by an installation of WordPress.
We will use GoDaddy as the hosting provider in this example, but the steps will roughly be the same for other hosting providers.
Login to your hosting provider
- Using your webbrowser navigate to your hosting providers website. In this example, we typed “http://www.godaddy.com” in the browsers address bar.
- Enter your username and password to login
Tip for GoDaddy Hosting users: If, like me, you are frustrated with the proliferation of ways to manage domains and hosting plans in GoDaddy and are looking for a quick way to directly go to your hosting plans, then login directly to the “Hosting Control Center” by going to https://hostingmanager.secureserver.net/ instead of navigating through http://www.godaddy.com
Go to the Hosting Management screen
- Hover your mouse over the “Hosting” sub-menu. This will show a menu of different options you can choose from.
- Click on the “Hosting Management” option. This will take you to the screen which lists all your hosting plans.
This can vary widely between different hosting providers. This also changes on the GoDaddy site itself over time.
If you are using GoDaddy you will have noticed that there are many different screens and navigation schemes for doing the same thing. (If someone at GoDaddy is listening: Please please make your user interface consistent and have a only one way of doing one thing – the proliferation of all kinds of management screens is exteremely annoying to put it mildly)
Go to the “Hosting Control Center”
- Click on the Launch button. This will open screen which will allow you to manage your hosted content and databases.
Note to GoDaddy users: As noted earlier, you can access the HOSTING CONTROL CENTER directly by going to: https://hostingmanager.secureserver.net/
Go to the MySQL Database Administration screen
- Click on the Databases tab
- Click on the MySQL icon to launch the Database Administration screen
Go to “Create Database” screen
If this is the first you are creating a database then the list of databases will be empty as shown above.
- Click the “Create Database” button. This will take you to a screen where you can specify the parameters for the new database that you wish to create.
Enter database details for creating new database
- Enter a description that will help you identify this database in the future. If you create multiple databases then this will help you distinguish one database from the other.
- Specify a unique identifier for you database name. This identifier is also used as the primary database administrator user.
- Enter a password for the database. This becomes the password for the primary database administrator user.
- Click the “OK” button to create your database.
The username and password you specify is the primary administrator username and password for this database. You cannot use underscores in the database/user name.
Make a note of the username and password – you will use this to configure WordPress so that WordPress knows how to connect to your database.
Wait for the database to be “setup”
Depending on your hosting provider, the database may get created instantly or it may take a few minutes for the database to get setup and to be ready for use.
On GoDaddy, it takes roughly 10 minutes for the database to be ready. During this time the status of the database says “Pending Setup”.
Database is ready
- Once the status of the database changes to “Setup” the database is ready for your use.
- Click on the Pencil icon to manage the database.
If you are going to use this database for WordPress then you will have to use the WordPress Admin screens to set it up further.