且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

使用 PHPMyAdmin 拒绝用户“root"@“localhost"的访问

更新时间:2023-12-01 21:36:28

编辑您的 phpmyadmin config.inc.php 文件,如果您有密码,请在以下代码中将其插入密码前:

Edit your phpmyadmin config.inc.php file and if you have Password, insert that in front of Password in following code:

$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = '**your-root-username**';
$cfg['Servers'][$i]['password'] = '**root-password**';
$cfg['Servers'][$i]['AllowNoPassword'] = true;