php - 如何使用 Ubuntu 在本地浏览器中运行 PHP

Question

当我尝试从 XAMPP 运行 phpMyAdmin 时收到此错误。在我安装和运行 XAMPP 之前，这台机器上已经安装了 mysql。当我启动 XAMPP 时，mysql 和 apache2 都成功启动。我可以使用 PHP 脚本访问 mysql 数据库，但不能通过 phpmyadmin 访问。

Error

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
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.

Answer 1

如果您想在没有密码的情况下以 root 身份访问 mysql，请在您的 /xampp/phpMyAdmin/config.inc.php 文件中确保设置以下变量:

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;