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 MoreTag: Syntax
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 MoreAWK Linux command
why awk? awk is small, fast, and simple, unlike, say, perl. awk also has a clean comprehensible C-like input language, unlike, say, perl. And while it can’t do everything you can do in perl, it can do most things that are actually text processing, and it’s much easier to work with. what do you do? […]
See More
You must be logged in to post a comment.