Today, I found out while working on PHP that if we use the mysql database that comes with the Xampp server, we must first change the mysql password. As we all know, the initial password of mysql is empty, but if the password is empty when connecting to the database, an error will be reported. I have found many solutions to similar problems on the Internet, all of which are to open the mysql command console. The solution is as follows However, according to what is said online, there is still a problem after following the steps, and the mysql password is still not changed. Next, I will introduce the steps to successfully modify it: 1. Click MySQL's admin to enter the phpMyAdmin page; 2. Click Account to enter the account management page; 3. Select the root localhost account and click Modify Permissions; 4. Enter the page shown in the figure below and click Change Password; 5. After designing your own password, click Execute. At this time, the password has been changed successfully, but the problem is that this page is no longer the phpMyAdmin page, but access is denied because we have changed the mysql access password; 6. Open the Xampp\phpMyAdmin\config_inc.php file and change the config in the picture below to cookie. At this time, the entire step of changing the MySQL password is completed. Then restart Xampp and click Refresh phpMyAdmin page to start the operation. You may also be interested in:
|
<<: js object-oriented method to achieve drag effect
>>: How to periodically clean up images that are None through Jenkins
<br />Previous tutorial: Web Design Tutorial...
Table of contents 1. Front-end routing implementa...
There are two ways: 1. Service method Check the f...
Preface Most of our MySQL online environments use...
need: Use vue to realize QR code scanning; Plugin...
MySQL supports hash and btree indexes. InnoDB and...
MySQL is a multi-user managed database that can a...
Data Type: The basic rules that define what data ...
Confluence is paid, but it can be cracked for use...
The complete syntax of the select statement is: S...
Table of contents 1. List traversal 2. The role o...
Table of contents Preface first step: Step 2: Mod...
This article uses examples to explain the princip...
The <canvas> element is designed for client...
This section starts with the details of text modi...