MySQL Databases
Flash tutorials in this category:
Creating a MySQL database
Managing a MySQL database in PHPMyAdmin
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.
click image for better view
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/
|
