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:
- Login to Cpanel.
- In the Databases section, click on MYSQL DATABASES.
- 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.
- After the confirmation message, click GO BACK.
- In the MySQL Users section, enter a username and password.
- Click GENERATE USER.
- After the confirmation message, click GO BACK.
- In the Add User to Database section, select the user and the database you just created and click the ADD button.
- Check the ALL PRIVILEGES box and click MAKE CHANGES.
- After the confirmation message, click GO BACK.
- 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
You cannot comment on this entry
