can't log onto a server

[mr slim]

There's a site I am putting a MySQL db onto and I can't log on with SQLyog Enterprise. I'd like to in order to synchronize the db there with a staged version I have on my own machine.

I am able to log on to the remote server with a SSH client. To do that, as would be expected,

– I log on to the server with the appropriate username/pw

– navigate to the mysql/bin dir

– use mysql -u root -p, then enter the pw.

That works to get a command line.

If I use a standard login from the SQLyog server tab, I get the following error message:

ERROR 2003: Can't connect to MySQL server on 'myhostaddress' (10061)

If I use SSH tunneling, I get this:

Could not establish SSH connection.

Make sure that the SSH server is running and you are entering correct values for SSH port forwarding.

I've tried various combinations for SSH tunneling. One example is:

Username: the same as I'd use to successfully logon to the server via SSH

Password: just as in Username

SSH Host: I've tried a few things, but typically, I try the server's domain name.

I'm going with the default ports.

For now, I'm doing this without any other connections open, but am assuming that I'll need to change the port numbers for either this or my local connection in order to do the data synchronization.

Any ideas as to what I'm doing wrong?

[Ritesh]

In the connection window there are two tabs: Server and Tunnel.

In the server tab, enter the following details.

MySQL host address: A host name where the database is situated or the IP address of the server.

User name: User name for connecting to the database server. Note: This is MySQL username. Not your FTP or webserver username.

Password: MySQL user Password

Databases: Database name. You may enter several database names separated by semicolon (like db1,db2). If you do not enter the database name, all the database names would be listed, to select from.

Port : A TCP/IP port for connecting to the database server.

In the tunnel tab, enter the following details:

Username: Username to access the SSH server.

Password: Password to access the SSH server.

SSH Host: Address of the machine on which SSH server is running.

SSH Port: Port on which SSH server is listening. By default, it is 22.

Localhost: The value will always be localhost and is readonly. This is because SQLyog creates the SSH port forwarding option on the local machine only.

Local Port: The local port on which SQLyog will listen locally for correctly port forwarding MySQL requests. Note: If you are connecting to two or more different MySQL servers, then you need to provide two different local port values in the respective connections.

To understand the setup better, let us connect to a MySQL server using a real life example.

E.g. Your website is hosted on 234.56.65.78. This server also has SSH server running and listening on port 22. Your MySQL server is located on server 234.56.65.79. This machine only allows connection from localhost or machine within the same network (e.g. 234.56.65.78). You publish your website on 234.56.65.78 using the username and password provided by your ISP. ex. the username and password provided is ssh_user and ssh_pwd respectively.

In this particular case you have to put in the following value for various options:

Server Tab

MySQL Host Address: 234.56.65.79

Username: Your mysql user name.

Password: Your mysql password.

Database: The database that you want to connect to. You can leave this field blank.

Port: The port MySQL is listening. By default it is 3306.

Tunnel Tab

Username: ssh_user

Password: ssh_pwd

SSH Host: 234.56.65.78

SSH Port: 22

Local Host: This is always localhost.

Local Port: Any port that is unused on your local machine. If you dont have a MySQL running on your machine then you can provide 3306.

[mr slim]

Thanks for the detailed reply, Ritesh. As it turns out, I had done what you suggest. So it must be that some of my information is wrong. Maybe the SQL server is, as you suggest, at a different IP address than the SSH host server. This is a virtual server account. Though, for what it's worth, the mysql command line is available from a subdirectory of the home directory I log into.

I don't have access to the hosting account, but I'll try to get it and see what I can find out.

Thanks again for the thoughtful response.

[Shadow]

Quote:

ERROR 2003: Can't connect to MySQL server on 'myhostaddress' (10061)

This error message indicates that you knock on the wrong server because MySql client cannot find any working instance of MySql server operating on the given machine.

[Ritesh]

I was just wondering how is it going?

[Author]

Posts