Adding a mySQL Database and Database User

1. Log into cPanel and select "mySQL Databases"

2. Find the box with "Db:" and enter the name that you'd like your database to have. Click "Add Db". Your database will be set up with the format username_dbname where username is the username of your cPanel account and dbname is the name you entered for the database.

3. Click the "Go Back" link to set up a database user

4. Find the "Username" and Password" boxes. Enter the name and password you'd like the user to have, and click "Add User". Your user will be set up with the format username_dbuser , where username is the username of your cPanel account and dbuser is the name you entered for the user.

5. Click the "Go Back" link to give the user permission to access the database

6. Under the databases will be 2 dropdown boxes. Select the database and user and click "Add User to Db".
  • 61 användare blev hjälpta av detta svar
Hjälpte svaret dig?

Relaterade artiklar

Using the File Manager

Log into cPanel and click on the "File Manager" link. A page will open in a new window. All of...

Setting Up Hotlink Protection

If someone is linking directly to your images or files from another website you may decide to set...

Set Up an Email Forwarder

You may wish to set up an email address in cPanel that redirects to another email address.1. Log...

Redirect to another URL

How to Set Up a Redirect via cPanel:  1. Log into cPanel. 2. Under Domains, click the Redirects...

How to edit DNS in cPanel

You can edit DNS settings like MX records, A records, TXT records, etc., in your cPanel. Please...