yum install MySQL - Remote Access

This post explains all the steps needed to install Mysql on Linux(RedHat, CentOS, Fedora) and configure it to access db from remote machines.

Install Mysql Client

$ yum install mysql

Install Mysql Server

$ yum install mysql-server

Upgrade Mysql Installation

$ mysql_upgrade

Login as root user

$ mysql -u root
mysql>

List the grants this user has

mysql> SHOW GRANTS;

Grant all privileges to login as root from any remote machine

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION

APSRTC Online Booking - comments

Finally APSRTC started Online Ticket Booking.

http://www.apsrtc.in/APSRTCOnline

Application's response is pretty fast (may be because there is no traffic?)
My observations:
* There is no SSL during login, hope their payment gateway is secure.
* Its a struts based Java app running on IBM Websphere
* Left the default apps running: http://www.apsrtc.in/hitcount
* Developers dont know the difference between HTML comments and JSP comments. View source of the home page shows lot of commented HTML code.
* Uses struts validator framework for validations on serverside and client side. Smart way to avoid load on the server and do all validations on client first.
* While searching for From and To location, just enter % and you get all locations.

Enhance Google Reader

Enhance/Customize the appearance of Google Reader with the below Firefox plugins.

http://userscripts.org/scripts/show/12917 (Need Grease Monkey plugin)
http://userscripts.org/scripts/show/26859 (Need Grease Monkey plugin)
https://addons.mozilla.org/en-US/firefox/addon/748 (Grease Monkey)
https://addons.mozilla.org/en-US/firefox/addon/6424/ (Better GReader)

Access Mercurial Hg via Proxy server

Accessing BitBucket Mercurial repository via Proxy server.

• Create a ".hgrc" file in HOME directory.
• Edit the file and add the proxy server details

[http_proxy]
host=myproxyserver.mycompany.com:1234