Phpmaadmin connecting to remote MySQL
Connect remote MySQL Steps
. phpMyAdmin, if not, go to http://www.phpmyadmin.net/home_page/downloads.php to download, install the article here with the integrated development environment Wamp phpMyAdmin demonstration. Go to the phpMyAdmin installation directory, here is: C:\wamp\apps\phpmyadmin4.1.14,
. create a folder config; copy. config.inc.php to, \config\config.inc.php
Perform http://localhost/phpmyadmin/setup in the browser and fill in the Host,user,password according to your topic
. After the settings are saved, copy. \config\config.inc.php to. \config.inc.php (the original file is best to be backed up)
File config.inc.php
<?php
/*
* Generated configuration file
* Generated by:phpmyadmin 4.1.14 setup Script
* Date:wed, SEP 2014 08:15:24 +0200
*/
/* Servers Configuration */
$i = 0;
/* server:85 [1] */
$i + +;
$cfg [' Servers '] [$i] [' verbose '] = ' 85 ';
$cfg [' Servers '] [$i] [' host '] = ' 172.163.25.85 ';/* Remote Database Host */
$cfg [' Servers '] [$i] [' port '] = ';
$cfg [' Servers '] [$i] [' socket '] = ';
$cfg [' Servers '] [$i] [' connect_type '] = ' TCP ';
$cfg [' Servers '] [$i] [' extension '] = ' mysqli ';
$cfg [' Servers '] [$i] [' nopassword '] = true;
$cfg [' Servers '] [$i] [' auth_type '] = ' config ';/* authentication mode, authentication by profile mode */
$cfg [' Servers '] [$i] [' user '] = ' user2 ';/* Database account */
$cfg [' Servers '] [$i] [' password '] = ';/* password is empty */,
$cfg [' Servers '] [$i] [' allownopassword '] = true;/* account password is empty, add this sentence */
/* End of servers configuration */
$cfg [' defaultlang '] = ' en ';
$cfg [' serverdefault '] = 1;
$cfg [' uploaddir '] = ';
$cfg [' savedir '] = ';
?>
$cfg [' Servers '] [$i] [' Allownopassword '] explanation
$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 is left with an empty pass Word for root or on which ananonymous (blank) user is defined.
phpMyAdmin connecting to remote MySQL