Unable to connect

Friday, November 18th, 2022

If you are experiencing issues connecting, please check the following:

  1. Check the control panel and make sure your database is still live
  2. Make sure you have the correct database credentials. Please copy and paste the password, these are sometimes complicated
  3. Are you connecting from your local machine or from a hosted website?
    1. If from your local machine please check your firewall, router and network has port 3306 open.  Your local script or application will need port 3306 open to connect.
    2. If you are connecting from a hosted website please check you are allowed to use 3rd party database providers, some hosts will stop you from using a different provider.

No database password or please wait

Friday, November 18th, 2022

We normally send the database password, via email, within a few minutes.

If you have not received it after 5 minutes, check your spam or junk folder.  Our emails sometimes, mistakenly end up in those folders.

Make sure to add us to your contacts to make sure you receive emails in the future.

If you still do not receive your password, please open a ticket.

Too many connections

Friday, November 18th, 2022

Ours servers maintain performance by limiting user connections to 20, otherwise, users could open unlimted number of connections and overwhelm the server.

We find 20 connections is more than enough to run websites and applications.

The connection limit doesn’t directly relate to the number of people able to use a website or application.  A website can serve many pages whilst using a limited number of connections.  Although, if you have a VERY popular website or app, you may want to think about upgrading.

But sometimes you may see a ‘Too Many Connections’ error.  This is caused when you’ve reached the limit of the available connections.

When this occurs, we suggest looking closely at your MySQL connections to work out why the limit has been reached.

Common issues include slow queries that require a long time to run, which stop the connection from closing, stopping it from being used again.

You can see what connections you are using by running this query:

show processlist

or

show full processlist

https://dev.mysql.com/doc/refman/8.0/en/show-processlist.html

Pay attention to the ‘time’ and ‘state’.  If the query has been running for a long time, and the other connections are waiting, then you have a query holding up the processing of the other queries, so they are unable to close.

More information can be found here https://dev.mysql.com/doc/refman/8.0/en/too-many-connections.html