phpmyadmin连接远程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

<?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'] = '172.163.25.85';/*远程数据库主机*/
$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';/*认证方式,以配置文件方式认证*/
$cfg['Servers'][$i]['user'] = 'user2';/*数据库账户*/
$cfg['Servers'][$i]['password'] = '';/*密码为空*/、
$cfg['Servers'][$i]['AllowNoPassword'] = true;/*账户密码为空时,添加此句*/

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



郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。