How to create a MySQL database and user in cPanel

Click the MySQL Database Wizard icon. Enter a name for the new database, then click Next Step. Enter a username and create and confirm a strong password, then click Create User. Click the All Privileges check box, then click Next Step. IMPORTANT: The database name, username and password will all be needed for scripts that need to connect to the database.

Continue Reading

Downgrading MariaDB/MySQL on cPanel

IMPORTANT: This is something that is NOT recommended, especially for production servers! If for some reason you need to do this Or simply want the information, the write-up is below: MAKE A BACKUP of all data! If possible, make a snapshot/full backup of your server. This CAN go horribly wrong and cause severe data loss. $EDITOR /var/cpanel/cpanel.config search for the line, mysql-version=XXX edit that line to mysql-version=5.5   <<Or whichever version that is 1 version older than you are looking to downgrade to yum remove mariadb*    << |   <<Removes the wrong new version yum remove MariaDB-*  << /scripts/check_cpanel_rpms –fix  <<Installs the older version Then go into WHM, and “”upgrade”” to XX … Read More

Continue Reading

Creating a Database in cPanel

Creating a Database in cPanel has a couple of steps to it. After creating the database, you will also need to create a user and then add that user to the database. The last 2 steps are commonly missed. Remember if you want cPanel to recognize the database, you will need to create it from cPanel. If you create the database from the command line, it will still work, however, cPanel will know nothing about it. First, you will need to: Login to the sites cPanel Go to MYSQL databases. Now that you are here you can do all three steps on 1 page. Create the database Create the User… Read More

Continue Reading