Databases

Creating and managing users and databases in MySQL using cPanel and phpMyAdmin

• How do I create a MySQL database?
  
  Log in to your cPanel account. In the "Site Management Tools" section, click on the MySQL Databases icon. To create a MySQL database, look for the field labeled "MySQL Database." Enter the database name in the field next to that lable, and click the "Create MySQL Database" button.
  
  Be sure to create and add a user to the database you just created.
• How do I create a MySQL user for my database?
  
  In cPanel, in the "Site Management Tools" section, click on the MySQL Databases icon. Then look for the Heading "Existing MySQL users." Enter a username and password in the appropriate fields. The username and password do not need to match your hosting account, e-mail account, or ftp account, and for security purposes, it's generally a good idea if they don't match. Then click the "Create MySQL User" button.
  
  After you have created the user, be sure to give the user the appropriate privileges in your database.
• How do I assign database privileges to a MySQL user?
  
  In cPanel, in the "Site Management Tools" section, click on the MySQL Databases icon. Then look for the heading "Grant permissions on a MySQL database to a MySQL user."
  
  Select the user and the database from the dropdown menus, check the appropriate boxes for the permission you want to assign, then click the "Grant Permissions" button.
• Is phpMyAdmin available? How do I access it?
  
  Yes, phpMyAdmin is available. Log in to your cPanel account, and in the "Site Management Tools" section, click the "phpMyAdmin" icon. This will load phpMyAdmin. You can add the phpMyAdmin page to your favorites in your browser, so that you don't have to go through cPanel every time.