GoDaddy Support

Creating MySQL or SQL Server Databases for Your Hosting Account

Date Submitted: 2-25-2014

All of our hosting accounts support MySQL databases. Windows (Hosting Control Panel and Plesk) accounts also support MS SQL. Windows Hosting Control Panel accounts also support Access databases. This article covers MySQL and MS SQL; Access databases are covered in this article.

To Set Up a Database for Your Website

  1. Log in to your Account Manager.
  2. Click Web Hosting.

Click one of the following, based on the type of hosting you have. You can tell this by the second word in your hosting's description beneath your hosting account's domain name, e.g. Deluxe Web correlates to Web/Classic (Hosting Control Panel).

Web/Classic (Hosting Control Panel)

  1. Next to the hosting account you want to use, click Launch.
  2. In the Databases section of the Hosting Control Panel, click the icon corresponding to the database you want to create.
  3. Click Add.
  4. Complete the fields. To allow direct access, click Additional Options.

    NOTE: If you need to Allow Direct Database Access, but do not see the field, contact customer support. Direct Database Access is only available on paid hosting plans. If you are not sure what Direct Database Access is, see Why connect remotely to hosting databases?

  5. Verify the settings and click OK.

It takes up to 1 hour to create a database.

Once the database is created, you can click Actions, and then Details to find more information, such as its host name.

Linux (cPanel)

  1. Next to the hosting account you want to use, click Launch.
  2. In the Databases section, click MySQL Database Wizard.
  3. In the New Database field, enter a name for your database, and then click Next Step.
  4. Complete the Username, Password, and Password (Again) fields, and then click Create User.
  5. Select the privileges to grant the user, and then click Next Step.

Windows (Plesk)

In Parallels Plesk Panel, you create databases and then either create new users for it, or grant existing users access.

  1. Next to the hosting account you want to use, click Launch.
  2. Go to the Websites & Domains tab.
  3. Click Databases.
  4. Click Add New Database.
  5. Complete the on-screen fields, and then click OK:
    • Database name — Enter a name for your database.
    • Type — Select the type of database you want to create.
  6. Select Create a new database user if you want to create a new user for this database, and enter a user name and password for it. Otherwise deselect the option.
  7. Click OK.

To Manage Database Users' Access

  1. Go to the Users tab.
  2. From the Name column, click the database user you want to manage.
  3. From the Database menu, select either the individual database the user can access or select All to give the user access to all databases of that type.
  4. Your Plesk Shared Hosting account has two sets of database users: one for MySQL and one for Microsoft SQL Server. If the database you want the user to access isn't available, it's probably because the user is for a different database type. However, you can create a new database user for that database type and grant them access.

  5. Click OK.

If you need to create additional users, you can go to the Users tab and click Create New Database User. Each database user can access only one database type. However, you can create users with the same name for each database type.

Rate This Article:
Related Topics:

NEED HELP? Call our award-winning support team 24/7 at (480) 505-8877
Submit

United States - English
Traffic Log Image