Jump to content

[Solved] Increase Max Sql Remote Connections


kxk06010

Recommended Posts

Hi,

 

I have a MySQL server on jhonny and would like increase my mysql max remote connections. I am currently only able to make three connections at maximum.

 

cPanel Username: kxk06010

Main Domain: autopartstore.heliohost.org

Server: johnny

Link to comment
Share on other sites

You should be able to have four persistent connections open at once the way it is already. I see two connections to your account from the same IP. Are you saying that each of your three team members needs to have two connections open at once?

Link to comment
Share on other sites

Try this:

  • Go to https://johnny.heliohost.org:2083/frontend/paper_lantern/sql/index.html
  • Scroll down to add new user.
  • Enter a username (eg: kxk06010_user1), password, confirm password, and click create user.
  • Repeat step 3 twice more to create kxk06010_user2, and kxk06010_user3, etc.
  • Scroll down to add user to database.
  • Select the kxk06010_user1, select the database kxk06010_autopartstore, and click add.
  • Check the appropriate permissions required, and click make changes.
  • Click go back.
  • Repeat steps 5-8 to grant access to kxk06010_user2, and kxk06010_user3 as well.
Check to see if all three of you can connect to the database at once after following the above procedure. Let us know if have any questions or issues.
Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...