Every time I try to connect to a MySQL database on remote Linux server, I get the Lost connection to MySQL server during query error. Whats wrong?
There are two most common reasons of this problem. – If you use SSH tunnel to connect to your database, then most likely you indicated wrong MySQL host. Upon establishing a connection with the SSH server the connection attempt to MySQL server initiated by SSH server fails. Please check the MySQL host name. Remember that it should be specified relative to SSH host and if these are installed on the same workstation then you should use “localhost” as MySQL host name. – This error can occur if your Linux glibc requires greater than 128K of stack size to resolve a hostname. It happens primarily on RedHat 8.0 system with MySQL version lower than 4.0.10, but also can happen with another configuration. To solve such issue, add/edit the following line to the [mysqld] section of MySQL configuration file: set-variable = thread_stack=192k # value must be 192K or higher.
Related Questions
- Every time I try to connect to a MySQL database on remote Linux server, I get the Lost connection to MySQL server during query error. Whats wrong?
- Every time I try to connect to MySQL on remote Linux server, I get the Lost connection to MySQL server during query error. Whats wrong?
- Can I make more than one Servoy database server connection at the same time?
