Server Admin

ID #1238

Creating a MySQL Database in Cpanel

You must create a database and associate a user with a database before it can be used by programs that require a MySQL database. Here's how:

  1. Login to Cpanel.
  2. In the Databases section, click on MYSQL DATABASES.
  3. In the Create New Database section, enter a name for your database. This should generally be the name of the program that will be using the DB, or some other easily recognizable name.
  4. After the confirmation message, click GO BACK.
  5. In the MySQL Users section, enter a username and password.
  6. Click GENERATE USER.
  7. After the confirmation message, click GO BACK.
  8. In the Add User to Database section, select the user and the database you just created and click the ADD button.
  9. Check the ALL PRIVILEGES box and click MAKE CHANGES.
  10. After the confirmation message, click GO BACK.
  11. In the Current Databases section, verify that the database exists and is associated with a user.

Your MySQL database is now ready, and you should proceed to the setup and configuration section of your program.

 

Tags: MySQL Database

Related entries:

Last update: 10-22-2009 12:25 pm
Author: John Duncan
Revision: 1.146

Digg it! Print this record Send to a friend Show this as PDF file
Propose a translation for Propose a translation for
Please rate this entry:

Average rating: 0 out of 5 (0 Votes )

completely useless 1 2 3 4 5 most valuable

You cannot comment on this entry