Modify the config. Inc. php file
// To manage more MySQL servers, modify the $ connect_hosts array.
$ Connect_hosts = array (
'1' => array (
"Host" => "localhost", // server 1
"User" => "root ",
"Password" => ""
),
'2' => array (
"Host" => "192.168.0.11", // server 2
"User" => "WordPress ",
"Password" => "*******"
)
);
For ($ I = 1; $ I <= count ($ connect_hosts); $ I ++ ){
/* Authentication type */
$ Cfg ['servers'] [$ I] ['auth _ type'] = 'cooker ';
/* Server parameters */
$ Cfg ['servers'] [$ I] ['host'] = $ connect_hosts [$ I] ['host']; // modify the host
$ Cfg ['servers'] [$ I] ['connect _ type'] = 'tcp ';
$ Cfg ['servers'] [$ I] ['compus'] = false;
/* Select mysqli if your server has it */
$ Cfg ['servers'] [$ I] ['extension'] = 'mysql ';
$ Cfg ['servers'] [$ I] ['allownopassword'] = true;
$ Cfg ['servers'] [$ I] ['user'] = $ connect_hosts [$ I] ['user']; // modify the user name
$ Cfg ['servers'] [$ I] ['Password'] = $ connect_hosts [$ I] ['Password']; // Password
/* Rajk-for blobstreaming */
$ Cfg ['servers'] [$ I] ['bs _ garbage_threshold '] = 50;
$ Cfg ['servers'] [$ I] ['bs _ repository_threshold '] = '32m ';
$ Cfg ['servers'] [$ I] ['bs _ temp_blob_timeout'] = 600;
$ Cfg ['servers'] [$ I] ['bs _ temp_log_threshold '] = '32m ';
}