MySQL is a relational database management system or RDBMS. Within cPanel MySQL supports backend operation through allowing authorised access and manipulation of a database through SQL queries.
Without a database content management system type applications could not function.These applications include: Wordpress, Drupal, Joomla and Magento. Also enables the standalone LAMP server (Linux, Apache, MySQl and PHP).
We recommend using the cPanel MySQL wizard as it gives a user-friendly database creation guide that ensures new databases are correctly configured with a user specific database prefix and an assigned user with configurable permissions.
You can also opt to setup your MySQL database manually. This interface also lets you check and repair a database within cPanel.
cPanel also supports the viewing and manipulation of individual databases and their tables through phpMyAdmin.
- Login to your cPanel control panel.
- Click to “MySQL® Database Wizard” in the “Databases” section.
- Enter a database name. Click next step.
- Enter a username.
- Either use the password generator or enter a password. Click next step.
- Configure the users privileges for the account.
- You have completed the setup. From here you can choose to add additional databases, users or return to your main control panel area.
- Continue from step 1 above.
- Click "MySQL® Databases" in the "Databases" section.
- Enter a name for the database.
- Click "Create Database" > "Go Back".
- Navigate to "MySQL Users" > "Add New Users"
- Create new users credentials including: Username, Password.
- Click "Create User" > "Go Back".
- Navigate to "Add User To Database"
- Select the User & the Database you want them to have permissions for.
- Configure the users permissions.
If you’re using WordPress, it's important to note that the database prefix, table prefix and database user credentials must be correctly configured within wp-config.php. Incorrect configuration will stop WordPress from working correctly causing the “Error establishing a database connection” message to appear.