phpmyadmin 添加server

最新推荐文章于 2024-01-20 17:23:05 发布

最新推荐文章于 2024-01-20 17:23:05 发布 · 120 阅读

文章标签：

#MySQL #PHP

本文介绍如何在MySQL中为用户设置只读权限，并详细说明了配置phpMyAdmin以便使用这些权限的具体步骤。

现在至少需要mysql添加一个只读权限

INSERT INTO user (Host,User,Password) VALUES('%','zhouwei',PASSWORD('zhouwei'));
update user set Show_db_priv='Y',Select_priv='Y' where Host='%' and User='zhouwei';
FLUSH PRIVILEGES;

然后添加phpmyadmin/config.inc.php

/*
* End of servers configuration
*/

在这行注释只上添加

/**
#example
$i++;
# Authentication type and info
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'zhouwei';
$cfg['Servers'][$i]['password'] = 'zhouwei';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['extension'] = 'mysqli';
*/