php - 无法在 AMPPS 上启动 phpmyadmin

Question

这个问题已经有答案了:

MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES) (44 个回答)

已关闭 3 年前。

我正在使用 AMPPS，但我根本无法访问 phpmyadmin 为什么我尝试通过以下方式访问它:http://localhost/phpmyadmin/

我收到这些错误:

错误MySQL 说:

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

phpMyAdmin 尝试连接 MySQL 服务器，但服务器拒绝连接。您应该检查配置中的主机、用户名和密码，并确保它们与 MySQL 服务器管理员提供的信息相对应。

我尝试用谷歌搜索它，但不幸的是我根本无法访问 phpmyadmin 页面。

有什么建议吗？

我还注意到 phpinfo 底部的这些错误消息:

Warning: PHP Startup: Unable to load dynamic library '/Applications/AMPPS/php-5.6/lib/extensions/ext/mysqli.so' - dlopen(/Applications/AMPPS/php-5.6/lib/extensions/ext/mysqli.so, 9): Library not loaded: libmysqlclient.18.dylib Referenced from: /Applications/AMPPS/php-5.6/lib/extensions/ext/mysqli.so Reason: image not found in Unknown on line 0

..

Warning: PHP Startup: Unable to load dynamic library '/Applications/AMPPS/php-5.6/lib/extensions/ext/pdo_mysql.so' - dlopen(/Applications/AMPPS/php-5.6/lib/extensions/ext/pdo_mysql.so, 9): Library not loaded: libmysqlclient.18.dylib Referenced from: /Applications/AMPPS/php-5.6/lib/extensions/ext/pdo_mysql.so Reason: image not found in Unknown on line 0

..

Warning: PHP Startup: Unable to load dynamic library '/Applications/AMPPS/php-5.6/lib/extensions/ext/pdo_pgsql.so' - dlopen(/Applications/AMPPS/php-5.6/lib/extensions/ext/pdo_pgsql.so, 9): Library not loaded: /Applications/AMPPS/extra/lib/libpq.5.dylib Referenced from: /Applications/AMPPS/php-5.6/lib/extensions/ext/pdo_pgsql.so Reason: no suitable image found. Did find: /Applications/AMPPS/extra/lib/libpq.5.dylib: file too short /usr/lib/libpq.5.dylib: mach-o, but wrong architecture in Unknown on line 0

Answer 1

您应该在 phpMyAdmin 文件夹中找到 config.inc.php 文件。找到如下所示的行:cfg['Servers'][$i]['auth_type']，并将其值设置为http。这样，每次您访问 phpMyAdmin 时，它都会要求您指定 mysql 用户名和密码。