This section of cPanel is a very useful section for anyone that uses MySQL databases for their site. Users have the ability to create and manage any aspect of a MySQL database right from this section of cPanel.
 

Users can start by adding a MySQL database. Simple go to the “Db:” section and type in the name of that database needed. Users also have the ability to added and remove users to databases in this section. Users can also add a host in this section; this is used for off site access.

In this above picture users can grant privileges to users and to databases. There are quit a few options to choose from, most just select all as it’s the easiest. Remember that access to a database isn’t need as long as the master username and password for the account is used. It’s a good idea to create a username and password to access each database instead of using the master username and password.

At the bottom of the MySQL section, there is a link to phpMyAdmin. This is a useful database management tool and should be used to manage all databases. More information on phpMyAdmin can be found here: http://www.phpmyadmin.net/home_page/
 

Related Articles

» The Unofficial cPanel Tutorial
» Mail
» Change Password
» Domain Names
» FTP Manager
» File Manager
» Error Pages
» Sub Domains
» SSH/Shell Access
» Redirects
» FrontPage Extensions
» Web/FTP Stats
» Raw Access Logs
» Raw Log Manager
» Error Log
» Disk Usage
» Backup
» Password Protected Directories
» MySQL Databases
» Sub Domain Stats
» Search Engine Submit
» Chatroom
» PhpMyChat
» Bulletin Board
» CGI Center
» Scripts Library
» Agora Shopping Cart
» Cron Jobs
» Network Tools
» MIME Types
» Manage OpenPGP Keys
» Hotlink Protection
» Index Manager
» IP Deny Manager
» Fantastico