当前位置:   article > 正文

phpMyadmin-连接多个mysql_phpmyadmin能连接多个数据库吗

phpmyadmin能连接多个数据库吗

phpMyAdmin说明文档:https://docs.phpmyadmin.net/zh_CN/latest/config.html 

1.首先修改,phpMyAdmin/libraries/config.default.php 

  1. /**
  2. * allow login to any user entered server in cookie based authentication
  3. *
  4. * @global boolean $cfg['AllowArbitraryServer']
  5. */
  6. $cfg['AllowArbitraryServer'] = true; //默认是false,改成true

 

2.phpMyAdmin根目录下新建文件 config.inc.php ,复制以下内容

  1. <?php
  2. /*把远程服务器的用户名,密码等,拼接为一个多维数组
  3. 数组下标要从1开始,从0开始会报错
  4. */
  5. $connect_hosts = array(
  6. '1'=>array(
  7. "host" => "127.0.0.1", //mysql1
  8. "user" => "root",
  9. "password" => "root"
  10. ),
  11. '2' => array(
  12. "host" => "", //mysql2
  13. "user" => "root&
声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/我家自动化/article/detail/428860
推荐阅读
相关标签
  

闽ICP备14008679号