kirasama Posted April 15, 2017 Share Posted April 15, 2017 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!! Quote Link to comment Share on other sites More sharing options...
Krydos Posted April 15, 2017 Share Posted April 15, 2017 Please post the following information:Your cPanel username Your main domain The server that you are on Quote Link to comment Share on other sites More sharing options...
Luigi123 Posted April 15, 2017 Share Posted April 15, 2017 Moved to Customer Service. Quote Link to comment Share on other sites More sharing options...
kirasama Posted April 15, 2017 Author Share Posted April 15, 2017 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 Quote Link to comment Share on other sites More sharing options...
wolstech Posted April 15, 2017 Share Posted April 15, 2017 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.