xampp localhost phpmyadmin 用户 'root'@'localhost' 访问被拒绝(使用密码:YES) [英] xampp localhost phpmyadmin Access denied for user 'root'@'localhost' (using password: YES)

问题描述

当我尝试访问我的 phpmyadmin localhost 时遇到两个错误

I am getting two errors when I try to go to my phpmyadmin localhost

Access denied for user 'root'@'localhost' (using password: YES)

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

我不知道我做错了什么...这是我的配置代码...

I don't know what I am doing wrong...here is my config code...

$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

/* 
 * Servers configuration
 */
$i = 0;

/* 
 * First server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'config';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'password';
$cfg['Servers'][$i]['connect_type'] = 'socket'; 
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';
/* User for advanced features */
//$cfg['Servers'][$i]['controluser'] = 'pmauser';
//$cfg['Servers'][$i]['controlpass'] = 'pmapass';
/* Advanced phpMyAdmin features */
//$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
//$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
//$cfg['Servers'][$i]['relation'] = 'pma_relation';
//$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
//$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
//$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
//$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
//$cfg['Servers'][$i]['history'] = 'pma_history';

/* 
 * End of servers configuration
 */

/*
 * Directories for saving/loading files from server
 */
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>

我注意到很多代码被注释掉了，我应该取消注释吗?

I notice a lot of code is commented out, should I un-commented it?

推荐答案

不要改变任何东西，保持原样，只需打开你的 xampp 并尝试从 shell 访问 mysql cd c://xampp/mysql/bin 写完之后mysql然后点击进入它会打开你的数据库

Don't change anything , put as it was there , just open your xampp and try to access mysql from shell cd c://xampp/mysql/bin after this write mysql and click enter it will open your databases

这篇关于xampp localhost phpmyadmin 用户 'root'@'localhost' 访问被拒绝(使用密码:YES)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！