There was a problem loading the comments.

How to Create a Database and Database User

Support Portal  »  Knowledgebase  »  Viewing Article

  Print

Click here for cPanel instructions.

Click here for DirectAdmin instructions.

 

Follow these steps to create a database in cPanel:

 

1. Log in to your cPanel account.
For instructions on how to log in to your cPanel account, please click here.

e67bc52bc40656261a64477d109e88c36200cd6ec44572d26e421abce763aa4abd741ae6f2174bef?t=16a6aeb0a7b17c76830f158aac1b2d47

 

2. Under the Databases section, click MySQL Databases.

 5697e2675e933c875a1190abeb7e7077904728aae9cd2343561a9c2ae17f40ed04754e1ce1232a48?t=7a45182dca89351a107aa261bbd7d90c

 

3. Under Create New Database, enter the name of the database into the New Database field, then click the Create Database button.

90db3dafb3dabb7812d30183e5c7bd563f3782a53eb44811ee823f891b417f449740d67c40704b31?t=57f732cfe0168e2754cd7a8d14d12b51

 

Follow these steps to create a database user in cPanel:

 

1. Log in to your cPanel account.
For instructions on how to log in to your cPanel account, please click here.

e67bc52bc40656261a64477d109e88c36200cd6ec44572d26e421abce763aa4abd741ae6f2174bef?t=16a6aeb0a7b17c76830f158aac1b2d47

 

2. Under the Databases section, click MySQL Databases.

 5697e2675e933c875a1190abeb7e7077904728aae9cd2343561a9c2ae17f40ed04754e1ce1232a48?t=7a45182dca89351a107aa261bbd7d90c

 

3. Under MySQL Users, enter the new user's name into the Username field.

3cebf7dfbf31fd44f4add322a302823490642edc8830ecf472141bed8c3f4c2b6109aee21a30c8b7?t=a3b4c2c4ea576209df16a08934027d2c


4. Enter your new user's password in the Password and Password (Again) fields, or use the password generator, then click the Create User button.

b546165b38ea924a5eb91423643daecb5038c8f70aa0c06eb1f7b664e112e6465f9fb02967a0bc61?t=924c23d5adc85a8de1deae16545b9f78

 

Note: You will be required to link the database user to the database for functionality. See this guide on how to connect the database user to the database. Click here

 

 

Follow these steps to create a database and database user in DirectAdmin:

 

1. Log in to your DirectAdmin account.
For instructions on how to log in to your DirectAdmin account, please click here.

93fa78453a69c8622e20602c56d427ffbc75b0d076fae439ca797766e8b0a04e417dcdf46c774d2d?t=edf763a81977cd2c9a4f74c2f4d2f115

 

2. Under the Account Manager section, click MySQL Management.

0fc254d716325f4626aa9f3ff7f6a6939de9e43a21965338c3d222bdbed578fd5c8cf16985f07e9b?t=a866f448e8f66c83ee6d43afeabb4710

 

3. Click the Create New Database button.

1fe59e9e36014034c394e46c796a1628bf43989d40d5ec70339922e6a80f70a780653e3b4f0c841f?t=8f42b67df34a0fe3535761a16e360bdb

 

4. Fill out the Database Name, Database User, and Database Password, then click the Create Database button.

Note: The database will have the DirectAdmin control panel account's username at the front of the Database Name and Database User. You cannot change this.

c55dd372ca907e2697c4a1de408831a4d3e78b48716a18cbc65e5236af3844deb4d3bbb416353bd9?t=e4293eee9fef0429d274397c8fe942a1

 

5. A pop-up will advise you of the newly created database.

03b21662dbe1887dd709fa5af1ff84d55553335bf5f5fbe19675e095d05aae98db6ecd8d80a2bdb8?t=ef25c5e5e12108f59283198d792449b6

 

6. You can also see the new database on the MySQL Management page.

fb9764bf1f8322be75ab75ed0e307c766db3a21f9af6eec91f9c311893d95ccb6e7993c052043a9e?t=d7f2dc0dab0c98fe1c78c3d77070aa73


Share via
Did you find this article useful?  

Related Articles

Tags

© DreamIT Host