Fix Warning: Mysql_connect() [function.mysql-connect]: Too Many Connections


Fix Warning: Mysql_connect() [function.mysql-connect]: Too Many Connections
  Forums Index
      » MYSQL Forums
        » » Fix Warning: mysql_connect() [function.mysql-connect]: Too many connections



Fix Warning: Mysql_connect() [function.mysql-connect]: Too Many Connections
Post Description:
Post Tags: fix, warning, mysql, connect, functionmysql, connect, too, many, connections, mysql database, support, help, answers, questions, help
This Post Has Been Viewed 6932 Times Since Fri Jul 21, 2006 7:09 am Posted By john607 with 8 replies
Fix Warning: Mysql_connect() [function.mysql-connect]: Too Many Connections
support, please help

I got this error on my server

Warning: mysql_connect() [function.mysql-connect]: Too many connections in

Leave Your Comments
* Your Name

  * Your Email Address (Will Not Be Published)

* Your Comments


Add Picture To Comments
Yes No             upload
Receive Replies on my Comments
(An email will be sent to you when someone replies to your comments)

     




Comments and replies About Fix Warning: Mysql_connect() [function.mysql-connect]: Too Many Connections






:: 1 :: #32 - Reply By john607 On Fri Jul 21, 2006 8:53 am
The reason why are getting this error is because your server is running out of resources. Meaning you have server overload. Simply put, you have too many users in your site for the service you currently have.

Its our recommendation that you move from our shared hosting plan to a dedicated server. Shared hosting is not designed for site such big web sites as yours. If you continue growing with your website demand, you will continue to see these errors and it will only get worst.

Contact our sales team and we can provide you with an affordable dedicated hosting server for as low as $99.

Another option you may have is to streamline your code. However, this will require alot of time and resources from you. If you getting the error below, try making your script code more efficient. Webune can assist you with this task, but to be honest with you, it will be more affordable if you upgrade from your shared hosting plan to one of Webune's dedicated server Packages.

Warning: mysql_connect() [function.mysql-connect]: Too many connections in /imedia/users/user/htdocs/connect.php on line 7

you may want to consider making some modifications to your code, per the PHP.NET Manual, to resolve these errors.

Using mysql_connect(): The advantage of using mysql_connect() for connections to MySQL databases in your code is that the link to the server will be closed as soon as the execution of the script ends, unless it's closed earlier by explicitly calling mysql_close().

More information can be found at the following URL:
http://us3.php.net/manual/en/function.mysql-connect.php

Using mysql_close(): This explicitly closes the connections. The use of mysql_close() in conjunction with mysql_connect() would ensure that the connection is closed.

Using mysql_pconnect(): This has a disadvantage in that the connection to the MySQL server will not be closed when the execution of the script ends. Instead, the link will remain open for future use. While this will work if you need to leave the connection open for additional connections, mysql_close() will not close links established by mysql_pconnect().

More information can be found at the following URL:
http://us3.php.net/manual/en/function.mysql-pconnect.php
:: 2 :: #19892 - Reply By karima On Wed Sep 12, 2007 12:06 pm
how to contact yoru sales department?
:: 3 :: #35854 - Reply By Tanweer On Fri Jan 11, 2008 5:59 am
i have getting and an error "warning: mysql_connect() [function.mysql-connect]: access denied for user 'root' at 'localhost' (using password: no) in /home/qures2/public_html/phpapp/dbc.php on line 12
access denied for user 'root' at 'localhost' (using password: no)"

what does it mean? please help me
thnx in advance,

tanweer
:: 4 :: #48131 - Reply By blabla On Tue Apr 01, 2008 7:38 am
ik wil opmaken
:: 5 :: #53898 - Reply By Vincent On Thu May 15, 2008 7:50 am
i receved this error and i dont undersatand y

warning: mysql_connect() [function.mysql-connect]: access denied for user 'gsdvca_gsdadmin' at 'localhost' (using password: yes)
i cannot connect to the database because: access denied for user 'gsdvca_gsdadmin' at 'localhost' (using password: yes)
:: 6 :: #56555 - Reply By akira On Thu Jun 05, 2008 2:54 am
root' at 'localhost'
:: 7 :: #59689 - Reply By jeannie On Sun Jun 29, 2008 2:56 am
freemoviesonline.tv function.mysql-connect
:: 8 :: #69992 - Reply By moneyca On Tue Sep 09, 2008 4:33 pm
mo_koneh at myemail
hello.
my name is miss.moneyca koneh, i got your contact details in gay.bg and i'm interested in knowing you & being friendly with you . i would appreciate if we get acquainted as soon as possible, you can reach my email
stated below so that we can get to know each other better.
( mo_koneh at myemail )
i quite believe that we can start from here since it takes one to know someone. i want you to understand that race or distance does not matter but loving and caring matters a lot in life. i look forward to hearing more from you soonest
miss moneyca.
mo_koneh/at/myemail/dot