Recent

Author Topic: [Solved] Multiple connection to MySQL  (Read 1247 times)

@berghem@

  • New member
  • *
  • Posts: 8
[Solved] Multiple connection to MySQL
« on: September 17, 2018, 12:06:43 pm »
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
« Last Edit: September 17, 2018, 05:28:16 pm by @berghem@ »

tr_escape

  • Sr. Member
  • ****
  • Posts: 384
  • sector name toys | respect to spectre
    • Github:
Re: Multiple connection to MySQL
« Reply #1 on: September 17, 2018, 12:14:14 pm »
did you try on your local pc & local mysql server same software?

Leledumbo

  • Hero Member
  • *****
  • Posts: 8088
  • Programming + Glam Metal + Tae Kwon Do = Me
Re: Multiple connection to MySQL
« Reply #2 on: September 17, 2018, 12:38:13 pm »
Have 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@

  • New member
  • *
  • Posts: 8
Re: Multiple connection to MySQL
« Reply #3 on: September 17, 2018, 12:55:09 pm »
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@

  • New member
  • *
  • Posts: 8
[Solved] Re: Multiple connection to MySQL
« Reply #4 on: September 17, 2018, 05:27:50 pm »
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