How to Update mysql.connect_timeout in php.ini?

Category: Databases

CanopyValley
Asked:
2013-07-28 12:34 am EST

Hits: 3,916
Hello team,

I am using VSP100 hosting I want to update mysql.connect_timeout value in php.ini.

I have the .htaccess setup to read my local php.ini file for value. I can change any other setting but the mysql.connect_timeout value. The default value is 120 second in the file, but no mater what I do, it show 10 second.

How can i update that?

You must login before you can ask a follow up question.

You must login before you can submit an answer.

OTHER ANSWERS

0

Arn
Staff
16,613 Points
2013-07-29 1:26 pm EST
Hello CanopyValley,

Thanks for the question and sorry for the problems with the MySQL timeout. The value that you need to change is actually in the my.cnf file which can only be changed with root access. I had the help of Jacob N. who is our systems teammate. He said that the recommended time for the timeout is between 15-20 seconds. He set it to 20 seconds (the socket timeout was also changed since you may be accessing the database with localhost as opposed to a remote IP address).

If you have any further questions or need further assistance, please let us know.

Regards,
Arnel C.

You must login before you can post a comment about this answer.

Like this Question?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!