dongluo8303 2017-06-30 17:38
浏览 292
已采纳

如何在phpMyAdmin中限制对特定数据库用户帐户的访问?

I'd like to be able to either restrict access to specific database user accounts, or block specific database user accounts from logging in via phpMyAdmin. How can I configure phpMyAdmin to do this?

Specifically, I'm running phpMyAdmin Ubuntu server. I want to know how to configure this at the level of phpMyAdmin itself, and not through the webserver or OS.

  • 写回答

1条回答 默认 最新

  • dsaeyrq451928 2017-06-30 17:38
    关注

    To configure phpMyAdmin, you need to find your config.inc.php configuration file. On Ubuntu, this is located in /etc/phpmyadmin. Edit this file.

    Add lines to this file after the block that ends with $i++.

    To deny access to all users by default, and then allow specific users:

    $cfg['Servers'][$i]['AllowDeny']['order'] = 'explicit';
    $cfg['Servers'][$i]['AllowDeny']['rules'] = [
        'allow alex from all'
    ];
    

    To allow access to all users by default, and then deny specific users:

    $cfg['Servers'][$i]['AllowDeny']['order'] = 'deny,allow';
    $cfg['Servers'][$i]['AllowDeny']['rules'] = [
        'deny alex from all'
    ];
    

    You can replace all with patterns to match specific IP addresses or ranges of addresses. See the full documentation at the phpMyAdmin docs.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 MATLAB动图问题
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名