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

Reset WordPress admin/users password from Linux command line

How to reset WordPress admin/users password from Linux command line? Ans:  * Log into server as root. * Enter to MySQL command prompt. root@grand [~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 932677 Server version: 5.5.42-cll MySQL Community Server (GPL) Copyright (c) 2000, 2015, Oracle and/or its […]

See More