Home

CPanel tutorial - mysql database management

Submitted by iniunet on Thu, 08/20/2009 - 01:05

CPanel usually has integrated feature of mysql database management like database creation, database backup etc. Mysql database support is essential in the Content Management System like wordpress, drupal or movable type. CPanel ususally comes with a 'Database' section where we could find all the tools for mysql database management.

Mysql Database Wizard

To install Content Management System, The first step is always to create a mysql database for it. and the easiest tools for mysql database creation is 'Mysql Database Wizard'. It is an easy to use, step-by-step and wizard guided tools which will guide you through the createtion process of mysql database, Even if you 're not familiar with any of the technlology or term with mysql.

  1. Just enter database name in the first step

  2. We will provide database user and password information in the second step, I suggest use of 'Generate Password' to generate complex password for security reason because we 'r in a shared web hosting.

  3. Then we will define database privilege for this user, you could select all the needed database privilege, You could also select 'ALL PRIVILEGES' to grant the user all of the privilege. If you 're not sure what privilege is needed for your content management system, you better grant all the privilege.

     

  4. Now we finish database creation. Just document the database username and password for later use.

Usually the database name and username is not exactly the name you provide. Because in a shared web hosting , There 's big possibility that each webmaster will select an similiar name (e.g. drupal etc). That is why CPanel will append your cpanel username in front of the database name automatically . for example, if our CPanel login username is 'cp1' and the database name we provide is test, then the actual database name will be cp1_test. This rules could be applied with the name of the mysql database username.