MySQL Bugs: #83846: Connection fails on Mac OS X EL Capitan

Bug #83846	Connection fails on Mac OS X EL Capitan
Submitted:	16 Nov 2016 14:18	Modified:	26 Jun 2017 12:22
Reporter:	Simon Buehlmann	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Connection Handling	Severity:	S3 (Non-critical)
Version:	5.5.52	OS:	MacOS (EL Capitan 10.11.3)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
Impossible to establish any connection independent the application used (JDBC / MySQL Workbench) The error message is:

lost connection to mysql server at 'reading initial communication packet' system error:0

Trying to connect to the mysql server using telnet on port 3306 seems to be OK

Connecting to the same server using Microsoft Windows is OK.

How to repeat:
Connect to the server using MySQL Workbench (current release)

Using the following java program:

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;

import javax.sql.DataSource;

public class DataSourceTest {
    
    private DataSource ds;
    
    public DataSourceTest(){
        ds = getMySQLDataSource();
        try {
            Connection conn = ds.getConnection();
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * from table_t");
            while(rs.next()){
                System.out.println(rs.getString("id_nr"));
            }

            System.out.println("Done.");
            Scanner s = new Scanner(System.in);
            s.nextLine();
            s.close();
 
            conn.close();          
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

    }
    
    public static void main(String[]
            args){
        new DataSourceTest();
    }
    
    public static DataSource getMySQLDataSource() {
        MysqlDataSource mysqlDS = null;
        mysqlDS = new MysqlDataSource();
        mysqlDS.setURL("jdbc:mysql://somehost.com/database");
        mysqlDS.setUser("username");
        mysqlDS.setPassword("password");
        return mysqlDS;
    }
}

Please provide the my.cnf file. Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Unfortunately I have no access to the my.ini file but I copied the content  of server variables into a file. Hope that helps.

Hello Simon Buehlmann,

Thank you for the feedback.
Could you please provide more details like 
1. Full stack trace
2. where is MySQL installed?
3. Tests you did with windows were on the same machine the server is installed or a different machine?
4. What does you get from "telnet mysqlserver 3306" on your mac?
5. Can you connect using the MySQL client from your mac? (- - please make it as private if you prefer) to confirm this issue at our end?

Thanks,
Chiranjeevi.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".