How to create a cPanel MYSQL database and MYSQL user

If you are manually uploading a program like WordPress instead of using our automatic installers, then you’re likely going to need to create cPanel MYSQL database. We always advise you to use the automatic installers to deploy applications. These also give you the ability to backup and restore sites with a few clicks, they also auto-update to ensure you are patched for the latest security fixes.

First login to your cPanel NVMe Web Hosting control panel and, at the top in the search bar type MYSQL and click the MYSQL database icon. From this page, you can create a database and add a user to that MYSQL database.

Next, create the database, fill out the fields, the database can be called anything but choose something that’s hard to guess. Finally, click the create button.

Next on the same page, create a MYSQL user, again you can call the user anything but choose something hard to guess, don’t use names like user or database. Always use the password generator to create your database password. Using this feature will create a strong password

Finally add the user you just created to the new database you created, make sure you assign the user all of the privileges displayed unless your install instructions say otherwise. You now have a MYSQL database and a user which you can use to add to your WordPress install or other application

How was this article?

Click to rate this post!

[Total: 2 Average: 4.5]

Spread the love