Connect phpmyadmin to remote mysql

Connect phpmyadmin to remote mysql
Phpmaadmin: connect to remote mysql to connect to remote mysql. Make sure phpmyadmin is available. Go to the phpmyadmin installation directory, where C: \ wamp \ apps \ phpmyadmin4.1.14,
. Create the config folder; copy. config. inc. php to \ config. inc. php.
Execute http: // localhost/phpmyadmin/setup in the browser, and enter host, user, and password based on your topic.
After saving the. settings, copy. \ config. inc. php to the. \ config. inc. php file (it is best to back up the original file) config. inc. php.

<? Php/** Generated configuration file * Generated by: phpMyAdmin 4.1.14 setup script * Date: Wed, 24 Sep 2014 08:15:24 + 0200 * // * Servers configuration */$ I = 0; /* Server: 85 [1] */$ I ++; $ cfg ['servers'] [$ I] ['verbose '] = '85 '; $ cfg ['servers'] [$ I] ['host'] = '2017. 163.25.85 ';/* remote Database Host */$ cfg ['servers'] [$ I] ['Port'] = ''; $ cfg ['servers'] [$ I] ['sockets '] = ''; $ cfg ['servers'] [$ I] ['connect _ type'] = 'tcp '; $ cfg ['ser Vers'] [$ I] ['extension'] = 'mysqli'; $ cfg ['servers'] [$ I] ['nopassword'] = true; $ cfg ['servers'] [$ I] ['auth _ type'] = 'config';/* authentication method, authentication using configuration files */$ cfg ['servers'] [$ I] ['user'] = 'user2 '; /* database account */$ cfg ['servers'] [$ I] ['Password'] = ''; /* the password is blank */, $ cfg ['servers'] [$ I] ['allownopassword'] = true;/* when the account password is blank, add this sentence * // * End of servers configuration */$ cfg ['defaultlang '] = 'en'; $ cfg ['serverdefault'] = 1; $ cfg ['uploaddir'] = ''; $ Cfg ['savedir'] ='';?>

$ Cfg ['servers'] [$ I] ['allownopassword ']

$ Cfg ['servers'] [$ I] ['allownopassword']

Type: boolean

Default value: false

Whether to allow logins without a password. the default value of false for this parameter prevents unintended access to aMySQL server with was left with an empty password for root or on which anonymous (blank) user is defined.