How to Create a MySQL Database and User

From Free Hosting Wiki
Revision as of 21:35, 9 August 2010 by DeadBattery (Talk | contribs)


Jump to: navigation, search

It is not possible to create a database using phpMyAdmin or anything outside cPanel. To create a MySQL database or user, you must use the tools provided in cPanel.


Contents

Using the MySQL® Database Wizard

To access the MySQL® Database Wizard, you will first need to login to cPanel. If you do not know how to login to cPanel, click here.


Once you are logged in to cPanel, click on MySQL® Database Wizard under Databases. From here, you can create a database and a user to access the database.


First, you will need to choose a database name. This will be in the format of username_example where username is your cPanel username and example is your database name. The overall database name can not be more than 16 characters.

Next, you will need to create a user to access the database. The username can not be more than 7 characters. You will need to enter a password twice for verification.

Last, you will be asked what privileges you would like to give to the user you created in the previous step. It is recommended to select ALL PRIVILEGES to avoid errors later on. If you know what all the privileges do, you can modify them to your needs.

Creating only a database

Creating only a user

Adding a user to a database

Personal tools
Namespaces

Variants
Actions