Restarted Pentaho PDI service on http://172.16.1.175:8080/...
Note: You can also use the mysqladmin –u root –p flush-host command once the error in log file is:  server is blocked from accessing the mysql server.
Database Password: d@t@b@$3

or 

Note: 	Do not flush the hosts when there is running processes
	If can afford, wait for the processes to sleep
	Check if there are running processes via "show processlist"

1. Go to mysql -u root -p then login
2. mysql> flush hosts;

===============================================================
How to up the Pentaho services:
•	Login in Pentaho server via ssh (putty)
•	Check the pentaho logs in:  /opt/pentaho/biserver-ce/tomcat/logs  and determine the real reason of application error
Filename: catalina.out
•	Go to cd /opt/pentaho/biserver-ce
•	Stop the services: sh stop-pentaho.sh
•	List the running java programs: ps aux | grep java
•	Kill the running java programs: kill -9  java ID#  eg. kill -9 1234
	Start the services: sh start-pentaho.sh

•	Go to Magneto (In case :8080 don't work after service restart)
	Stop Pentaho Service on BI servers then execute the following in Magneto
		1. Go to mysql -u root -p then login
		2. mysql> flush hosts;
	Start Pentaho Services on BI servers

Note: 	Do not flush the hosts when there is running processes
	If can afford, wait for the processes to sleep
	Check if there are running processes via "show processlist"
===============================================================
Restarting Pentaho Admin Consoleflush
	1. Go to cd /opt/pentaho/administration-console
	2. Run ./start-pac.sh	
================================================================
Check who is connected and coordinate IP result with Dev team
netstat -tn 2>/dev/null | grep :8080 | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -nr | head

===============================================================
To Check if Pentaho Services are running, run hte following command
ps 