Bug #14525 mysql ignores MYSQL_TCP_PORT
Submitted: 31 Oct 2005 21:15 Modified: 31 Oct 2005 21:17
Reporter: Michael McLagan Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.15 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[31 Oct 2005 21:15] Michael McLagan
mysql command line program does not use the MYSQL_TCP_PORT environment variable.  I have a server running on a non-standard port, 3307.  I have two environment variables:

[mmclagan@linux lib]$ set | grep MYSQL

[mmclagan@linux lib]$ mysql
ERROR 2003 (HY000): Can't connect to MySQL server on 'db.thecountrychristmasshoppe.com' (111)

[mmclagan@linux lib]$ mysql -P 3307
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 40 to server version: 4.1.14-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> quit

How to repeat:
See description above

Suggested fix:
Check the environment variable.
[31 Oct 2005 21:17] Jim Winstead
This is a duplicate of Bug #5792.
[31 Oct 2005 21:29] Michael McLagan
Sorry about that.  I tried a couple of searches and didn't end up finding it.