Arch Linux

kde35

Member

Registered: 2015-04-13

Posts: 71

Mariadb client ignores port number [Solved]

I managed to run two instances of mariadb server following this page. The second instance of mariadb
run fine, but the mariadb client could only connect to the first instance!

I did some more experiments,  with only one mariadb server running on the default port 3306, I tried

mysql --port-number=3307

and I got connected to the server !  I tried other numbers like 22, and I still get connected.  Is this a bug in mariadb client, or am I missing something in the options?

Last edited by kde35 (2016-03-03 17:43:02)

kde35

Member

Registered: 2015-04-13

Posts: 71

Re: Mariadb client ignores port number [Solved]

Actually this is widely known, for example here.
So the solution was

mysql --socket=/run/mysqld/mysqld1.sock