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?
You might also like
More from cPanel
How To Install A Cloudflare Origin SSL Certificate In cPanel
Free SSL Certificates from places like cPanel or Let's Encrypt are great. When Let's Encrypt first introduces free SSL Certificates …
Create a SWAP partition on CentOS, RHEL and AlmaLinux without a reboot
SWAP is a memory type that Linux NVMe VPS Servers use to process requests. Memory will be held in SWAP …
Help fixing Error: last request failed: [AUTH] Authentication failed.
The Error: last request failed: [AUTH] Authentication failed error can be caused by a range of things. It could be …