0

I need to increase wait_timeout variable in mysql only when access mysql from phpmyadmin. I don't want to edit my.cnf file or set it globaly in mysql server.

I've read documentation, but haven't found if I can run any queries after connection to specific database.

Any help is appreciated.

Application details below:

phpMyAdmin version 4.4.1

mysql is percona 5.6.

| improve this question | |
  • 1
    Why would you need that? – Jehad Keriaki Apr 29 '15 at 14:59
  • Check interactive_wait_timeout. – Rick James Apr 29 '15 at 16:35
1

File:

libraries/dbi/DBIMysqli.class.php

138     public function connect(

before return link you can run query:

223         $link->query("SET SESSION wait_timeout = 600");
224         return $link;

This would set any session to mysql db from phpmyadmin with wait_timeout = 600.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.