Sequel Pro: - Name = Connection's name (it's up to you) only if you set a custom port to access with SSH if not, leave empty and default port 22 will be used. I keep all the steps, maybe it will help someone. (I don’t have any “skip-networking” entry. It’s weird because within my my.cnf I have the following line saying: Instead of skip-networking the default is now to listen only on localhost which is more compatible and is not less secure. MySQL said: Lost connection to MySQL server at 'reading initial communication packet', system error: 0 You may also want to check the port is correct and that you have the necessary privileges.Ĭhecking the error detail will show the SSH debug log which may provide more details. Please ensure that your MySQL host is set up to allow TCP/IP connections (no -skip-networking) and is configured to allow connections from the host you are tunnelling via. Unable to connect to host 127.0.0.1 because the port connection via SSH was refused. So, within Sequel, how can I set the port to my custom one for the SSH Host entry?įirst I missed some field within Sequel… Now it’s ok.īut when I attempt to “Test connection” I have the following: SSH port forwarding failed I have set remote SSH to run on a custom port, not on the default port 22. I guess I found something… debug1: Connecting to 127.0.0.1 port 22. Username = root (I'll create a dedicated user later :p) I did the following: ssh -NC -p my_custom_port -L 9999:localhost:3306 I’m still stuck with a The SSH Tunnel has unexpectedly closed. Thank you !!!Ĭould you please help because I can'f find such documentation about it… I really need to put this to work, I need that to continue my job, any help will be appreciated. If I change 'server = ":3306" ' to 'server = "" ' (withou port number) It takes longer, but got the same error. "Unable to connect to nay of the specified MySQL hosts. LOCALHOST (Wamp in my personal computer)īut If I try those values to an online connection (the configuration I need) If I use these values (to connect to localhost) my app works fine:
NOT ABLE TO ACCESS DATABASE FOR LOCALHOST ON MAC PASSWORD
So, I copy the IP to my string connection in the application, set the username, password and database name, and It can't connect. Grant permissions to all ips because anyone with any ip who are using the applications would be allowed to connect, I think need to be that way for a desktop application, isn't?)ĭid netstat -plutn to see and mysql are listening in port 3306
Well, I have a desktop application and I need to access my vps database to manipulate the data.Ĭommented bind-address in /etc/mysql/my.cnf
0 kommentar(er)
