I have install mysql server on Ubuntu and it is working fine locally. But I want to have a remote access by using "Navicat for MySQL". Can you please help me to provide step by step toward how to make it work?
Really appreciate you help Thanks,
Asked
Active
Viewed 38 times
1
-
Mysql port forwarding should be enabled . – auth private Feb 27 '16 at 04:59
-
Can you please clarify with this? I'm not really understand. Thanks so much – heng hok Feb 27 '16 at 08:35
-
I dont know about Navicat but did you try `mysql -h yourip -u username -p`? Also you need to grant privileges to others if you're providing access to other users. Check http://stackoverflow.com/questions/8348506/grant-remote-access-of-mysql-database-from-any-ip-address – Samuel Bushi Feb 27 '16 at 20:00
-
first you need to enable portforwarding on your home router to be able to access your ubuntu server remotely from outside network please read more about Port Forwarding and how to from here http://portforward.com/help/portforwarding.htm . – auth private Feb 28 '16 at 15:10