[Solved] How To Increase Mysql Max User Connections

[kirasama]

How to increase mysql max user connections

 

Hello i have an test program which used mysql connection string using remote mysql

the program working successfully but when i give it to my friend while me opened the program or connect to the server using MySQLConnector

it says Error to connect because user {name} already has more than 'max_user_connections' active connections.

so i want to learn how to increase the size of it or how to fix it

and i cannot use database users i have created so i using the default user

it's the problem because that?

if that true so how can i use the database users i have created because everytime i entered the password it says the password is wrong to connect to this database user!!

[Krydos]

Please post the following information:

• Your cPanel username
  
• Your main domain
  
• The server that you are on
  

[Luigi123]

Moved to Customer Service.

[kirasama]

I'am sorry if me post it in the wrong place

My cPanel username: dw

My Main Doamin: dw.heliohost.org

The Server: johnny.heliohost.org:2083

 

 

Hello i have found an solution but its not completly helpful

the problem Simply because using my domain as the server

//Server

server = "dw.heliohost.org";

database = "dw_users";

uid = "dw";

password = "<removed>";

 

string connstring;

connstring = $"Server={server}; Database={database};User Id ={uid}; Password={password};";

 

conn = new MySqlConnection(connstring);

but i change the server to johnny.heliohost.org like that

 

//Server

server = "johnny.heliohost.org";

database = "db_name";

uid = "dw";

password = "pass";

 

string connstring;

connstring = $"Server={server}; Database={database};User Id ={uid}; Password={password};";

 

conn = new MySqlConnection(connstring);

 

and it's working successfully but with a two of connections

[wolstech]

We actually recommend using localhost if the script is running on our server, but yes, the server domain will work too.

 

Glad to see you got it working. Since the issue is fixed, I'll mark this solved. Please let us know if there's anything else we can help you with or if it stops working and we can reopen it.