在Windows设备上全新安装的XAMPP 控制面板不包含^{(XAMPP Control Panel)}MySQL PHPMyAdmin的 root 密码。在这种情况下，每个人都可以轻松访问它，从而导致容易受到重大风险的影响。为避免这种情况，我们建议您为 root 用户设置适当的安全密码。在本指南中，我们将解释如何在XAMPP上更改 phpMyAdmin 密码。

虽然已经看到，在XAMPP上更改 phpMyAdmin 密码后，用户可能会遇到拒绝访问错误消息，阻止他们登录MySQL phpMyAdmin。为了解决这个问题，您需要更改 config.inc.php 文件中的配置设置。所以，让我们开始吧。

如何在 XAMPP 上更改 phpMyAdmin 密码

要更改XAMPP上的 phpMyAdmin 密码，您首先需要启动XAMPP 控制面板^{(XAMPP Control Panel)}。

打开后，单击 MySQL 的Admin ^(Admin )按钮。

您可能需要使用您当前的用户名和密码登录，然后单击“开始”^(Go)按钮。

在PHPMyAdmin站点上，切换到用户帐户^{(User accounts)}选项卡。

在用户帐户概览^{(User accounts overview)}下，单击编辑权限^{(Edit privileges)}链接，该链接将root作为其用户名，将localhost作为主机名。

在下一页上，转到更改密码^{(Change password)}部分。

在这里，您需要创建一个包含字母、数字和符号组合的新强密码。在密码字段旁边，有一个密码强度指示器，显示您的密码状态。随着密码变强，状态表变为Red > Yellow > Green。

在相应的框中重新输入相同的密码，然后单击“开始”^(Go)按钮。

正确创建新密码后，当您登录 phpMyAdmin 时，可能会遇到拒绝访问的错误消息，说 -

Cannot connect: invalid settings

在这种情况下，您需要通过更改 config.inc.php 文件中的配置设置来解决登录问题。

如何修复 phpMyAdmin访问^(Access)被拒绝消息

phpMyAdmin 访问被拒绝消息主要发生在您在 XAMPP 上更改 phpMyAdmin 密码的登录密码时

要修复此错误，请打开XAMPP 控制面板^{(XAMPP Control Panel)}应用程序。

移动到右端列，然后单击资源管理器^(Explorer)按钮。

在文件资源管理器^{(File Explorer)}中，导航到以下路径 - C:\ xampp C:\xampp\phpMyAdmin

在相应的文件夹中，找到config.inc，然后使用任何文本编辑器（如记事本）打开它。

找出Authentication type 和 info^{(Authentication type and info)}，并更新以下参数：

在第一行 -

$cfg['Servers'][$i]['auth_type'] = 'config'; change config with cookie

也在一线——

$cfg['Servers'][$i]['AllowNoPassword'] = true; change true with false

执行以下更改后，保存并关闭文件。就是这样。

How to change phpMyAdmin password on XAMPP

A fresh installation of the XAMPP Control Panel on a Windows device doesn’t hold the root password for MySQL PHPMyAdmin. In such a case, it could be easily accessible to everyone and that results in vulnerable to critical risks. To avoid it, we suggest you set an appropriately secure password to the user root. In this guide, we will explain how to change the phpMyAdmin password on XAMPP.

Although, it has been seen that after changing the phpMyAdmin password on XAMPP, users may encounter an access denied error message that prevents them to log in to MySQL phpMyAdmin. In order to fix this issue, you need to change the configuration settings in the config.inc.php file. So, let’s get started.

How to change phpMyAdmin password on XAMPP

To change the phpMyAdmin password on XAMPP, you first need to launch the XAMPP Control Panel.

Once it opens, click on the Admin button for MySQL.

You may need to log in using your current username and password and then click on the Go button.

On the PHPMyAdmin site, switch to the User accounts tab.

Under User accounts overview, click on the Edit privileges link which holds root as its username, and localhost as the hostname.

On the next page, move to the Change password section.

Here you need to create a new strong password having a combination of letter, number, and symbol. Next to the password field, there is a password strength indicator that shows your password status. As the password goes stronger, the status meter turns Red > Yellow > Green.

Retype the same password on the corresponding box and then click on the Go button.

After creating the new password properly, when you log in to phpMyAdmin, you may encounter an access denied error message, saying –

Cannot connect: invalid settings

In this case, you need to fix the login issue by changing the configuration settings in the config.inc.php file.

How to fix phpMyAdmin Access denied message

The phpMyAdmin access denied message mainly occurs when you change the login password of the phpMyAdmin password on the XAMPP

In order to fix this error, open the XAMPP Control Panel application.

Move to the right end column and click on the Explorer button.

In the File Explorer, navigate to the following path “C:\xampp\phpMyAdmin”

On the corresponding folder, locate config.inc and then open it with any text editor like notepad.

Find out Authentication type and info, and update the following parameters:

In the first line-

$cfg['Servers'][$i]['auth_type'] = 'config'; change config with cookie

Also in the line-

$cfg['Servers'][$i]['AllowNoPassword'] = true; change true with false

After performing the following changes, save and close the file. That’s it.

Related posts

• 如何在Windows 10上使用PIP安装NumPy

• 如何在Windows system上卸载或丢弃故障WIM

• Setup Filezilla Server and Client：Screenshot and Video tutorial

• 如何在Windows 10计算机上更新BIOS

• 如何在Paint.NET创建Transparent Image上Windows 10

• 如何在Windows 10上安装和使用FFmpeg

• 如何使用双Monitor带VirtualBox虚拟机

• 如何从video file使用VLC and GIMP创建Animated GIF

• 如何使用Windows Memory Diagnostic tool测试您的RAM

• 如何在Windows 10中删除Files and Folders

• 6种方法退出Windows 11

• 如何在Windows and Mac上改变Firefox中的语言

• 如何从具有高质量的Video提取Frames

• 如何在Windows 10中转换install.esd才能安装.wim文件

• 如何使用Paint在Screenshot上添加透明图像

• 如何更改Project Home的默认PWA site

• 如何转换OpenDocument Presentation给Video在OpenOffice

• 如何在Windows 10创建或恢复System Image

• 如何从Windows删除账户（7种方式）

• Windows 10中恢复，Fix，Repair Master Boot Record（MBR）