Category Archives: MySQL
MySQL database exists on the server, but does not show up in the cPanel
This has been rare, but I have seen it a few times lately. A customer asked why their database was missing in their cpanel. Their site was still able to access the database however, and when I looked in /var/lib/mysql the database still showed up there. The reason for this is that the database mapping …
Reset a FunnelFlux admin password from MySQL
If you have lost your admin password to FunnelFlux, you can manually reset it via command line MySQL. SSH to the server type: mysql example_db (replace example_db with the database FunnelFlux fruns from) Type: UPDATE `users` SET `password` = ‘YTBtSjliQ01NMXRzaGttbnFkVWRhZz09’ WHERE `users`.`idUser` =1; This sets the password to 123 to the admin user (id #1) Once …
cPanel: Deprecated MySQL databases
If you have upgraded to cPanel 62 and you have started receiving this email: Deprecated MySQL databases The following MySQL databases have been deprecated and are no longer used by cPanel & WHM. Database Name : Database Username leechprotect : leechprotect modsec : modsec You can delete these databases and related database users at your …
Increasing tmp partition size on cPanel Server
As your server grows or you have some rather large tasks, you might find the default size of your /tmp partition to be too small, which can result in various errors from your services, the most common 4 being cPanel, Apache, LiteSpeed and MySQL. For example: [ERROR] mysqld: Can’t create/write to file ‘/tmp/zbLxFquF’ (Errcode: 28 …
How to reset a password for CPVLabs
If you have forgotten your password to CPVLabs admin, you can reset it if you have access to your database. Login to your phpMyAdmin select the database used for CPVLabs Click on browse beside the user table Edit the “admin” user account replace the the password field with “21232f297a57a5a743894a0e4a801fc3” (without the quotes) The password is …
Reset a password for Prosper 202
If you have lost your password for the admin page of Prosper 202, you can reset it via the database. If you have phpMyAdmin installed, open it up, go into the 202_users table, edit the user account you want to change the password to, and set the “user_pass” to 1ddd38fae1a40c096484f209bea02e70 This will set the password …
Ticket ID Not Found. WHMCS Error – Disable mySQL Strict Mode
We recently moved our WHMCS to a much more powerful server. In the process we elected to use CloudLinux for the added security. The migration was smooth and there was no downtime because our System Administrators are awesome, however we did run into an issue with WHMCS after the move. Anytime we created a new …
How to create a MySQL database from command line
If you need to create a database, and you don’t want to bother logging into a graphical interface, you can do this via the command line with a few simple commands. First, if the database already exists, you’ll need to delete it with the following command. mysql -u root -p$password -e ‘DROP DATABASE $targetdb;’ This …
- English Support
- 24/7 x 365
- Branded Support
- Reduced Overhead
- Linux Experts
- Friendly Staff
facebook
twitter
LinkedIn