![]() However, I ran out of ideas as to what is missing. I find the number 3306 so it must be open right? I even tried the "sudo ufw allow XXXX/tcp" command to make sure 3306 is open. Find your mysql service name setup during installation (For Example: MySql56) Right click on the service name and click start. Tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 994/sshd To enable MySql Service follow this steps: Go to Start -> Control Panel -> System and Security -> Administrative Tools -> Component Services. Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name Step2: Go to SSH tab-> Tunnels: Enter Your MySQL server HostName: Port as destination and Source port as your local port where you want to tunnel that service and click on Add. Step1: Enter your Jump server Host/IP in the session tab. So I go back to that server machine an check the status again with netstat and the result is like below: ❯ sudo netstat -tlpnĪctive Internet connections (only servers) For Windows Users, Using Putty to connect to remote MySQL Server via Tunneling. So I check it with telnet and the result is: telnet: connect to address 49.: Connection refused This creates a tunnel, between port 3306 locally, and on the remote end. ![]() But, if you do have ssh access, you can work around this, by tunneling mysql trough ssh. In addition, its not common to run mysql visible on the internet. ![]() However, when I try to connect the server from my other machine, it shows: ERROR 2003 (HY000): Can't connect to MySQL server on '49.' (61) First of all, port 22 is used for ssh, not mysql. When I check open port status with Nmap, it shows like below: Nmap scan report for localhost (127.0.0.1) To make this connection, youll need a running instance of MySQL and either a Linux machine to test the connection or any number of MySQL clients that allow for. Now, it is possible to log in to the database system remotely, using the credentials created. After installing mysql server, I obviously changed bind-address from 127.0.0.1 to 0.0.0.0. With the previous step we concluded the MySQL configuration. I have been spending over 6 hours trying to solve this problem.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |