21 May 2013
Support Center
»
Knowledgebase
»
How do I add a mysql database in Cpanel?
How do I add a mysql database in Cpanel?
Solution
To create a MySQL database:
- Go to 'Manage Mysql' under the database header in Cpanel
- In the DB text field, type the name you wish to give your database
- Click the Add DB button
- At the bottom of MySQL Manager under 'Users' type a
database user name and password
- Click the Add User button
Now for the important part that everyone misses:
You should now see your new user listed in the dropdown menu after "User:" and your new database listed in the "DB:" dropdown menu. (if you don't try refreshing the page in your browser) Then, select BOTH the username AND the DATABASE NAME and click the Add User to DB button to add your user to your database and you're done.
Now that you have created a database, created a database user and have granted that user access to the database your mysql database is fully ready to use.
Article Details
Article ID:
90
Created On:
26 Feb 2008 05:10 PM
This answer was helpful
This answer was not helpful
User Comments
Add a Comment
Sharing is good. If you have a comment about this entry, please feel free to share. The comments might be reviewed by our staff, and may require approval before being posted. Questions posted will not be answered. Please submit a Ticket for support requests.
Fullname:
Email: (Optional)
Comments:
Login
Username:
Password:
Remember Me:
Search
-- Entire Support Site --
Knowledgebase
Downloads
Troubleshooter
Article Options
Add Comment
Print Article
PDF Version
Email Article
Add to Favorites
Home
|
Submit a Ticket
|
Knowledgebase
|
Troubleshooter
|
News
|
Downloads
Language:
English (U.S.)
Help Desk Software By Kayako eSupport v3.11.01