Public bug reported: Binary package hint: mysql-admin
I can duplicate this with all of mysql, mysqldump, and the mysql-admin GUI on 8.04LTS. This is not the behavior I am used to from the same applications on 6.06LTS or the Windows ports of the same applications. I normally create an SSH tunnel to a remote (6.06LTS) server where I run a MySQL server (via `ssh -L localhost:33060:localhost:3306'). I also run a local (8.04LTS) MySQL server. When I specify a host of "localhost" and a port of "33060" to any of mysql, mysqldump, or mysql-admin, the client will attach to the local instance of MySQL server instead of the tunnel to the remote instance, yet when I connect directly to 127.0.0.1, the connection works (I can also work around this by defining some other alias for 127.0.0.1 in /etc/hosts and using it). In the following transcript, note the local MySQL instance is hardy's version 5.051a-3ubuntu5.1 and the remote instance is dapper's version 5.0.22-Debian_0ubuntu6.06.9-log. [EMAIL PROTECTED]:~$ mysql -h localhost --port=33060 -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 32 Server version: 5.0.51a-3ubuntu5.1 (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> quit Bye [EMAIL PROTECTED]:~$ mysql -h 127.0.0.1 --port=33060 -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 493390 Server version: 5.0.22-Debian_0ubuntu6.06.9-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> quit Bye [EMAIL PROTECTED]:~$ telnet localhost 33060 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. M 5.0.22-Debian_0ubuntu6.06.9-logO�e\ypDAXy,�!xpHUQy,mc(9)Connection closed by foreign host. [EMAIL PROTECTED]:~$ ** Affects: mysql-admin (Ubuntu) Importance: Undecided Status: New ** Affects: mysql-dfsg-5.0 (Ubuntu) Importance: Undecided Status: New ** Also affects: mysql-dfsg-5.0 (Ubuntu) Importance: Undecided Status: New -- mysql clients ignore port specification when connecting to "localhost" https://bugs.launchpad.net/bugs/241802 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs