Shared Memory Connection Protocol

[Ymhr]

There isn't the possibility of selecting the connection protocol.

If I write “localhost”, and my server has shared memory on, then shared memory will be used, with the name “MYSQL”, that I can't change.

I have 2 local server with shared memory on, and SqlYog connect always with the “first” server.

At the moment, I connect with “127.0.0.1” with different port number.

When SqlYog connect with shared memory, then various operation will fail, for example “Backup Database as SQL dump” will throw exception “Unknown MySQL server host 'MYSQL' (0).

[sathish]

We use the MySQL C connection API – mysql_real_connect() to connect to MySQL.

According to the MySQL documentation

Quote:

If host is NULL or the string “localhost”, a connection to the local host is assumed. For Windows, the client connects using a shared-memory connection, if the server has shared-memory connections enabled. Otherwise, TCP/IP is used.

So, this API automatically detects the connection protocol (using the rules above) and connects using it. Therefore you should not specify “localhost” if you are using shared memory.

We will also look into this and see if there is anyway we can force a specific type of connection, but for now you should specify the IP address rather than “localhost”.

[Author]

Posts