How to setup a new MySQL Database

Many scripts require a MySQL database to work, and you will need to create a new database to use with your script. This article describes how to create a database and get the necessary settings for your script.

Create a new database

Before you can use a database, you need to create it first.

  1. Login to your client area and go to the Accounts list.
  2. Find your hosting account in the list and click Manage.
  3. Click the Control Panel button in the account overview page.
  4. Go to MySQL Databases.
  5. In the field under New Database, enter a short name to help you identify the database (letters and numbers only).
  6. Click Create Database.

Using a new database

After creating a database, you need to tell your script how to use it. In a configuration file or installation wizard, it will ask for a database hostname, database name, database username and database password. Here’s how you can find those settings.

For the database name, username and hostname:

  1. Login to your control panel and go to MySQL Databases.
  2. Find your new database under Current Databases.
  3. Copy the MySQL DB Name, MySQL User Name and MySQL Host Name to the relevant configuration fields.

For the database password:

  1. Login to the client area.
  2. Click the account you created the database for.
  3. Scroll down to Account Password and click Show next to the password field.
  4. Copy the password from the field to the Database Password configuration field.

And that’s all there is to it! That’s all your script need to know to use the database.