phpmyadmin连接远程mysql_MySQL

phpmaadmin连接远程mysql

连接远程mysql步骤

.保证已经有了phpmyadmin，如果没有，去http://www.phpmyadmin.net/home_page/downloads.php下载，安装；文章这里用集成开发环境wamp自带的phpmyadmin示范。 进入到phpmyadmin安装目录下，这里是：C:\wamp\apps\phpmyadmin4.1.14，
.创建文件夹config；拷贝.config.inc.php到,\config\config.inc.php
浏览器中执行http://localhost/phpmyadmin/setup，根据自己主题填写host，user，password
.设置保存后，拷贝.\config\config.inc.php到.\config.inc.php(原来文件最好能备份一下)

文件config.inc.php

$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 ananonymous (blank) user is defined.