Problem In Channel

[Metin2 AR]

Where I'm start 2 Channel
and go to start Channel 3
Putty Send Me This Message
mysql_real_connect: Too many connections
cannot open direct sql connection to host: localhost user: mt2 db: common
cannot start server while no common sql connected
And NaviCat Give Me 1040 - Too many connections


how fix and start 4 Channel and open Navicat ??

[Al.Pacino]

You have to set up the "max_connections" of mysql. Set them to something like 3000, 3500, 4000 etc.

[Metin2 AR]

I'm Start Channel 2
But Channel 3 Or 4 Give Me
mysql_real_connect: Too many connections
cannot open direct sql connection to host: localhost user: mt2 db: common
cannot start server while no common sql connected

[iSouli~]

Go into putty and insert "mysql -p" and input your Password.
Next insert in putty "SET GLOBAL max_connections=40000;" and restart MySql per "service mysql-server restart" .

[Al.Pacino]

Originally Posted by -Soulution-

Go into putty and insert "mysql -p" and input your Password.
Next insert in putty "SET GLOBAL max_connections=40000;" and restart MySql per "service mysql-server restart" .

9999 ist maximum.

[iSouli~]

Originally Posted by Al.Pacino

9999 ist maximum.

Ja er kanns so machen wie er es möchte das war nur ein Beispiel , am besten wäre sowieso sich eine my.cnf einzurichten.

[Metin2 AR]

Not Fixet

I'm Start 2 Channel And I Can't start Channel 3 Or 4

Help Me !!

[Al.Pacino]

Originally Posted by Metin2 AR

Not Fixet

I'm Start 2 Channel And I Can't start Channel 3 Or 4

Help Me !!

Once you restarted the dedicated server, you have to set up the "max_connections" again. Alternative you can create a my.cnf and don't have to change the "max_connections" on every reboot.

[Metin2 AR]

How create a my.cnf

[IgorGlock]

Turn your homepage offline, reboot the server, try to start your server again.

[Metin2 AR]

Originally Posted by IgorGlock

Turn your homepage offline, reboot the server, try to start your server again.

Why ??

[IgorGlock]

Don't ask badass - just do!

[Metin2 AR]

Ok
But Peoblem Not fix !

[Al.Pacino]

Originally Posted by Metin2 AR

Ok
But Peoblem Not fix !

mysql -u root -p

PHP Code:

SET GLOBAL max_connections=9999; 


start server -> win

[Metin2 AR]

OK ??