How do I create and manage databases with MySQL and phpMyAdmin?
You can access your MySQL databases by selecting MySQL Databases from the cPanel main page. To add a new database, enter a name for the database and click Add Db. To add a user to the database, enter a username and password and click Create MySQL User. To grant the user access to the database, select the user and database from the drop down lists under “Grant Permissions …”, check the privileges you want to give this user, and click Grant permissions. On the MySQL Account Maintenance screen, there are connection strings for Perl and php. Insert this code into any file that needs to connect to the database. To create a database with phpMyAdmin, click on phpMyAdmin at the bottom of the MySQL Account Maintenance screen. On the following screen, select the database you want to manage: image:Cpanel14.jpg Click on the SQL tab to run SQL queries on this database. To save the contents of the database, select Export.
