Posted on by Vishwajit Kale

Change default timezone in MySQL

How to change default timezone in MySQL? The timezone on SiteGround’s servers is CST. This is a global setting which cannot be changed. 1) Modify the MySQL NOW() function. 2) Selecting the current date/time: SELECT NOW(); If you want to add 2 hours to the result, 3) Use the following syntax: SELECT DATE_ADD(NOW(), INTERVAL 2 […]

See More
Posted on by Vishwajit Kale

Check cPanel Licence Verification

How to check cPanel Licence Verification?  To verify the licence of the cPanel  open this link http://verify.cpanel.net/. If the licence is valid then login as root to the server and run the following to refresh the license. # /usr/local/cpanel/cpkeyclt If this command errors or you do not see the server contacting cPanel license servers to verify your […]

See More
Posted on by Vishwajit Kale

Upgrade MySQL and MySQL Governor in cPanel

Upgrade MySQL and MySQL Governor in cPanel CloudLinux based server First make full mysql backup(including system tables)  to safe location. 1) Take the backup of all the databases on the server. $ mkdir -p ~/mysqlbkp $ service mysql restart –skip-networking –skip-grant-tables $ mysql_upgrade $ mysqldump –all-databases –routines –triggers > ~/mysqlbkp/dbcopy.sql $ service mysql stop $ cp -r /var/lib/mysql/mysql ~/mysqlbkp/ $ service mysql start 2)  update mysql/governor in the following way: # yum update governor-mysql –enablerepo=cloudlinux-updates-testing # /usr/share/lve/dbgovernor/db-select-mysql –mysql-version=mysql55 # /usr/share/lve/dbgovernor/db-select-mysql –install-now installation […]

See More