[Solved] Increase Max Sql Remote Connections

[kxk06010]

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

[Luigi123]

This support request is being escalated to our root admin.

[wolstech]

Krydos will probably ask, so I'll ask while we wait...what are you doing that needs 3 connections?

[kxk06010]

My team is composed of three people and all three of us want to be able to connect so that we can work simultaneously.

[Krydos]

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?

[kxk06010]

Yes. One connection is to the database through a client. Another is for website that gets data.

[Krydos]

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.