How to Update mysql.connect_timeout in php.ini?

Avatar
CanopyValley
  • Answered
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?
Replies 1
Avatar
0
Arn
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.