Grant External HOST/IP Access to MYSQL Database

If you want access your MySQL database from another server or host you can use following steps.

1. Login to your MySQL database server
% mysql -u root -pPASSWORD

2. In MySQL prompt type following link. Replace user_name,HOST and pass_word
mysql> GRANT ALL PRIVILEGES ON *.* TO user_name@HOST IDENTIFIED BY 'pass_word';