CPanel - How to create a MySQL database

From EZP Knowledge Base

Jump to: navigation, search

It seems that most websites rely on database driven applications nowadays. Software such as blogs, forums, content management software and shopping carts for the most part require a database. Setting up a database sounds intimidating but with cPanel it's very easy to do. Just follow these steps to setup your MySQL database:

  • Login to cPanel!
  • Scroll down the page to the "Database" section and click on the "MySQL Database" icon

file:sql.png

  • Under the"Create New Database" heading, you will see the "New Database" field - enter the name of the database you wish to create

file:sql2.png

  • Click "Create Database" and you are done.
  • !!Please note!! The database will be created with the name "cpaneluser_yourdatabasename". Where 'cpaneluser' is your username that you login to cPanel with. You must use the full "cpaneluser_yourdatabasename" database name in your software configuration, or your software will not work.