Configure MySql in eclipse remotively (MySql 5.5 + Eclipse 4.2 + Xampp 1.8)


We can configure MySQL in Eclipse easily when we were using the MySql in local-host

But when we access the MySQL from remote machine the situation was difficult to me.But the configuration is less

What we do is

We need to give the user permission to access the database,
for that we need to configure the privileges in the respective database ,

Step 1:

  •   Select the database from PhpMyAdmin
  •   Click Privileges option


Step 2:
  •   Click Add user
  •   Add required credentials
  •   The data's what we are entering in the field's , will be entered while configuring in Eclipse , so take the data's in mind.


   
After entered the details Click Go to save the user

Step 3:
Open Eclipse and Database Explorer

Confugure new connection

 


Save all and click ping, you will be get result as "Ping Successed"

Thats it..!!


Reference : http://www.4geeksfromnet.com/

Comments

Post a Comment