Category: Linux

How to get a previous date in bash (linux)

Published by Petronald Green on July 2, 2013

Simply put date -d ‘1 day ago’ +’%Y-%m-%d’ # For multiple days date -d ‘7 days ago’ +’%Y-%m-%d’ If you wish to place in a shell script: RMDATE=$(date -d ‘7 days ago’ +’%Y_%m_%d’) will place for example ‘2013-07-01’ in the RMDATE variable which of course you can use like echo…

How to setup open MySQL Port (3306) on Ubuntu

Published by Petronald Green on June 24, 2013

Step 1: ensure we have mysql-server installed. apt-get install mysql-server Then: vim /etc/mysql/my.cnf COMMENT OUT (with a ‘#’): “bind-address = 127.0.0.1” Restart Server with service mysql restart ——– To test with another linux client, use mysql -h ip.or.hostname -u root -p (ERROR 2003 (HY000): Can’t connect to MySQL server on…