MySQL Connector/ODBC: Connection failed: Can't open named pipe
Today a Microsoft Windows machine was unable to use the official MySQL client called "MySQL Connector/ODBC" to connect to a different MySQL server on a GNU/Linux machine, in the same LAN, via TCP/IP, standard port 3306, listening on all interfaces and without firewalls.
The connection from the Microsoft Windows client failed with this error message:
Connection Failed [MySQL][ODBC 8.0(a) Driver] Can't open named pipe to host: xxx pipe: Mysql (s):
Notes
- there is no firewall in the LAN
- the port is worldwide opened
- the credentials are OK
Question
Since this error message is nonsense... what's wrong here?
If you get the error "Can't open named pipe" note that there is a bug in the MySQL connector, at least version 8.0.
The client is ignoring your check on the TCP/IP Server option and it's using a connection method called Named Pipe that it's not supported by your server (and should not - to be honest).
To make sure that the client does not use the Named Pipe method, select it, empty the text field (the one that in the example contains the text "Mysql"), and select again TCP/IP.
In short: this red textarea MUST be empty (by first selecting it, temporarily):
If you empty the "Named Pipe" text area, it will work!
It would be nice to discover if it exists an upstream bug in MySQL for that.
- Laravel query builder using 'whereNotIn' throws error
- MYSQL - count number of rows in each table
- Cannot delete or update a parent row: a foreign key constraint fails
- Condensing a query into a single better formatted query
- Redact the column in a SELECT clause depending on a condition using CodeIgniter's active record
- get images list according to there message and thread id from database
- Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates
- how to convert mysqli_set_charset($conn,"utf8") into PDO format in MYSQL?
- MySQL, join to find only max transaction count based of group
- is `date` a valid mysql column name?
- CodeIgniter SELECT query with JOIN conditions using FIND_IN_SET() is not returning the expected results
- How to only append a wildcard at the end of a WHERE LIKE condition with CodeIgniter's active record
- How to separate logic in a Codeigniter active record WHERE clause
- Does the JDBC specification define what happens if you call ResultSet.getObject(String) for a query which has conflicting column names?
- Chronologically order a SELECT query's results by month name
- Calculate tiered discount amount using a CodeIgniter query
- Join query with comma separated values in codeigniter
- duplicate entry error in mysql - codeigniter
- What is an elegant way to deal with several optional filters?
- #1130 - Host 'localhost' is not allowed to connect to this MySQL server - After running an Acunetix scan
- Detect mysql update/insertion failure due to violated unique constraint
- Duplicate table entry error
- Catch duplicate key insert exception
- How to catch error 1062 "duplicate entry" independent from used database/engine?
- #1062 - Duplicate entry for key PRIMARY
- How to Redirect user to some other page if Duplicate Entry Error Occurs?
- check for duplicate entry vs use PDO errorInfo result
- How to handle error for duplicate entries?
- Dealing with duplicate keys in codeigniter mysql insert
- Codeigniter - Model - Duplicate Entry Alert