Setup MySQL database

There's a few ways to setup mysql on our servers.

"MySQL Databases" in cPanel is only recommended for advanced users, it allows you to manage databases and users seperately, as well as set permissions. This is beyond what most of our users would need which is to simply setup a database and assign a username and password to it.

To simplify the process we also have the "MySQL Database Wizard" in cPanel. This is as simple as providing a database name and then a username and password and then assigning privelages (usually "All"). That's it!

Note: Your username is automatically added to your database name and username. For example if your username is "mywebsite" and you added a database called "mydatabase", it would actually be called "mywebsite_mydatabase".

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

General PHP information

PHP Version: This is available on the left hand side of cPanel. We usually try and run the latest...

Manage MySQL database

There are a few ways to manage MySQL databases on our server.The first is to use command line in...

Enable mod_deflate

Mod_deflate is an apache (web server) module which basically compresses files before sending them...

Custom error pages

Custom error pages are a great way to complete your website. You can use our Custom Error editor...


Home path, perl path and sendmail paths are available on the left hand side of cPanel under stats.