MySQL connection over SSH tunnel

by

There are three issues here.

1 – Forget about the SSH tunnel for now

You cannot bind MySQL to more than one specific IP.
The first bind-address clause is overridden (therefore, ignored) by the second one. Your server only listens to 99.99.99.99.

The reason why you can connect with -h localhost but not with -h 127.0.0.1 is that in the first form, you do not actually connect through TCP/IP, but through a local socket.

Look in your my.cnf for a socket clause.

Remove one redundant bind-address clause. You may want to use bind-address=0.0.0.0, which instructs MySQL daemon to listen to all network interfaces.

2 – Let’s setup your SSH tunnel

The reason for you error ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0 is not obvious to me. I suspect SSH tunnel is actually established only when it receives a connection request (in your case, when you run the mysql client). Since your server does not listen to 127.0.0.1 (see previous paragraph), the SSH tunnel cannot be established, connection fails, and your client interprets it as a network failure.

3 – Why mysql -v -h localhost -P 9989 -u user userdb -p fails

Please post the output of

[edit : just added ...OR host LIKE 'localhost' below, as this might be relevant for troubleshooting purposes]

mysql > SELECT user, host FROM mysql.user WHERE user LIKE 'user' OR host LIKE 'localhost';

(replace 'user', after the LIKE clause, with the actual user name if necessary)

MySQL access control checks both the username/password (user) and the origin of the connection (host) to identify a user. You probably did not create a user 'user'@'localhost'.

N.B.: mysql.com being unreachable from my location at this time, I cannot link to the relevant manual pages.

More Related Contents:

  1. How to execute a MySQL command from a shell script?
  2. MySQL connection over SSH tunnel – how to specify other MySQL server?
  3. Laravel MySql DB Connection with SSH
  4. INSERT INTO SELECT statement with more columns which is not in another table
  5. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  6. Why does MYSQL higher LIMIT offset slow the query down?
  7. Normalization in MYSQL
  8. MySQL load NULL values from CSV data
  9. Is there a REAL performance difference between INT and VARCHAR primary keys?
  10. JOIN queries vs multiple queries
  11. Calculate difference between two datetimes in MySQL
  12. Getting around MySQL “Can’t reopen table” error
  13. Can’t Create Entity Data Model – using MySql and EF6
  14. SQLException: No suitable driver found [duplicate]
  15. In MySQL, can I copy one row to insert into the same table?
  16. MySQL: Cloning a MySQL database on the same MySql instance
  17. MySQL sharding approaches?
  18. MySQL performance: multiple tables vs. index on single table and partitions
  19. Can MySQL convert a stored UTC time to local timezone?
  20. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  21. Returning a value even if no result
  22. MySQL Workbench: Error in query (1064): Syntax error near ‘VISIBLE’ at line 1
  23. I can not find my.cnf on my windows computer [duplicate]
  24. Does Order of Fields of Multi-Column Index in MySQL Matter
  25. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  26. NodeJS MySQL Dump
  27. How to store Query Result in variable using mysql
  28. MySQL: Querying for unicode entities
  29. undefined method `eq’ for nil:NilClass with rails 3 and ruby enterprise on ubuntu hardy
  30. INSERT INTO fails with node-mysql

Leave a Comment