May 2014

Set Mysql root password to Null   For empty Mysql password set mysql password to null.   #use mysql; #update user set password=null where User=’root’; #flush privileges;   With above mysql commands you set mysql root password to Null.

Enable Slow Query logs in Mysql   We can enable mysql slow query log by two way: Step 1   # touch /var/log/mysql/mysql-slow.log # chown mysql:mysql /var/log/mysql/mysql-slow.log # mysql -u username -ppassword -e ‘SET GLOBAL slow_query_log=1;’ # mysql -u username -ppassword -e ‘SET GLOBALslow_query_log_file=”/var/log/mysql/mysql-slow.log”;’ # …