Misc Server Apps

[How To] Reset MySQL root password

mysql logo

MySQL root password is important if you want to access phpMyAdmin, secure MySQL command prompt access, etc. In case one forgets the MySQL root password or wants to set root password, following steps should help to achieve the same. 1) Stop the MySQL Server: /etc/init.d/mysql stop/etc/init.d/mysql stop or /etc/init.d/mysqld stop/etc/init.d/mysqld stop 2) Start the MySQL configuration: mysqld --skip-grant-tables &mysqld --skip-grant-tables …

Read More »

MySQL replication problem: ‘show master status’ shows ‘Empty set (0.00 sec)’

mysql logo

In MySQL replication, you setup master and slave MySQL server. On master server, while checking the master status, you might end up with following error message: 1 2 3 4 mysql> SHOW MASTER STATUS; Empty set (0.00 sec) mysql> show binary logs; ERROR 1381 (HY000): You are not using binary loggingmysql> SHOW MASTER STATUS; Empty set (0.00 sec) mysql> show …

Read More »

Tomcat manager login details

To reset Tomcat manager password, follow simple steps. 1) Got to the apache-tomcat directory and open file following in your favorite editor cd /usr/local/apache-tomcat-6.0.20/conf/ vi tomcat-users.xml Part of file contents before update. <tomcat-users> <!-- <role rolename="tomcat"/> <role rolename="role1"/> <user username="tomcat" password="tomcat" roles="tomcat"/> <user username="both" password="tomcat" roles="tomcat,role1"/> <user username="role1" password="tomcat" roles="role1"/> --> </tomcat-users> Now , update the file as follows <tomcat-users> …

Read More »

BlackBerry Mail Server IP range whitelist

While configuring email account on BlackBerry, the connection could not be successful sometimes even though all the settings are correct. Sometimes, the mails even drops in spam or blocked as spam by the spam filter. To avoid such problem, the BlackBerry mail server IP range should be whitelisted in the Iptables, CSF and Spam filter on the server. IP Address …

Read More »

Difference between mod_deflate and zlib.output_compression

apache logo

Most of the SEO, Developers are concern about the website load time, and question about the compression from the server end. The compression is achieved from both PHP zlib output_compression and Apache's mod_gzip (old Apache version) , mod_deflate. But the one question remains unanswered is that which compression method gives good compression. this post is going to cover the same …

Read More »