How to change the mysql password on the Xampp server (with pictures)

How to change the mysql password on the Xampp server (with pictures)

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:
  • MySQL cross-database transaction XA operation example
  • Solution to the error message "java.sql.SQLException: Incorrect string value:'\xF0\x9F\x92\xA9\x0D\x0A...'" when storing emoticons in MySQL
  • How to use the terminal to open the MySQL that comes with XAMPP on Mac
  • How to modify the default password of MySQL in xampp
  • ThinkPHP framework construction and common problems (XAMPP installation failure, Apache/MySQL startup failure)
  • How to modify the default empty password (root password) of MySQL in xampp
  • Detailed explanation of MySQL's XA transaction recovery process
  • Solve the xampp self-start and mysql.sock problems
  • How does the MySQL database implement the XA specification?

<<:  js object-oriented method to achieve drag effect

>>:  How to periodically clean up images that are None through Jenkins

Recommend

Web Design Tutorial (3): Design Steps and Thinking

<br />Previous tutorial: Web Design Tutorial...

Vue-Router installation process and principle detailed

Table of contents 1. Front-end routing implementa...

Two ways to enable firewall in Linux service

There are two ways: 1. Service method Check the f...

Analysis of implicit bug in concurrent replication of MySQL 5.7

Preface Most of our MySQL online environments use...

Vue implements QR code scanning function (with style)

need: Use vue to realize QR code scanning; Plugin...

How to view and optimize MySql indexes

MySQL supports hash and btree indexes. InnoDB and...

Detailed explanation of mysql.user user table in Mysql

MySQL is a multi-user managed database that can a...

MySQL data types full analysis

Data Type: The basic rules that define what data ...

Complete steps for deploying confluence with docker

Confluence is paid, but it can be cracked for use...

MySQL statement execution order and writing order example analysis

The complete syntax of the select statement is: S...

v-for directive in vue completes list rendering

Table of contents 1. List traversal 2. The role o...

MySql knowledge points: transaction, index, lock principle and usage analysis

This article uses examples to explain the princip...

jQuery uses the canvas tag to draw the verification code

The <canvas> element is designed for client...

Details of various font formats in HTML web pages

This section starts with the details of text modi...