[Solved] Multiple connection to MySQL
lazarus / 16-Databases

----------------------------------------------------------------------
@berghem@ · 2018-09-17 10:06

Hi all
I have a client/server application that uses MySQL database.
The application works well if I open only one client, but when I open
second client it doesn't work.
I think that the problem is MySQL server configuration because I use
3306 port and for the first instance the port is open but when I open
the second instance the 3306 port is in use from the first instance.
Is it correct? Of course, if I close the first instance the second
instance works well!
Have I modify some MySQL conf or I have to modify somthing of my code?

Thanks

----------------------------------------------------------------------
tr_escape · 2018-09-17 10:14

did you try on your local pc & local mysql server same software?

----------------------------------------------------------------------
Leledumbo · 2018-09-17 10:38

Quote from: @berghem@ on September 17, 2018, 12:06:43 pmHave I modify
some MySQL conf or I have to modify somthing of my code?
Before doing this, what "doesn't work" message do you get from the
server? By default, MySQL should be configured to accept connections
from multiple clients (config: max_connections, default value: 100).

----------------------------------------------------------------------
@berghem@ · 2018-09-17 10:55

In attachment there is the error.

Yes, I tried My software in local whit local database and in this case
works well. I have problems only when I use two differente client with
the same database, and I resolve to close one client....

----------------------------------------------------------------------
@berghem@ · 2018-09-17 15:27

Quote MySQL should be configured to accept connections from multiple
clients (config: max_connections, default value: 100).

By default MySql has commented this parameter, I have eliminate the
comment and now I have resolved.

Tks to all