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