Sunday 30 June 2013

MySQL Remote Connection



1. Open Your MySQL Application and select MySQL database.  Then Select USER table.


2. Right Click user Table And Click View Data






3. Then Add another row in table (Given Below).




A)    localhost row always will be there.
B)     The second row %,  is not there then create manually like the same value in localhost row
 
4. Then Click Startà MySQLà MySQL server 5.0 àMySQL Comment Line Client




5. Now “MySQL Comment Line Client “Appeared

6. in this comment box, First Type Your MySQL Password and Click ENTER Button
Then Type

 GRANT ALL PRIVILEGES ON *. * TO 'root' @ 'local host' IDENTIFIED BY '123 'WITH GRANT OPTION;”

 and Click ENTER Button.
 


6. Now this MySQL will be connected from other machines.