Upgrade & Secure Your Future with DevOps, SRE, DevSecOps, MLOps!

We spend hours scrolling social media and waste money on things we forget, but won’t spend 30 minutes a day earning certifications that can change our lives.
Master in DevOps, SRE, DevSecOps & MLOps by DevOps School!

Learn from Guru Rajesh Kumar and double your salary in just one year.


Get Started Now!

How to change database password in XAMPP

To change the database password in XAMPP, you’ll need to follow these steps:

  1. Open XAMPP Control Panel: Launch the XAMPP control panel by running the “xampp-control.exe” file. You can usually find it in the XAMPP installation directory.
  2. Stop the MySQL Service: Locate the MySQL module in the control panel and click the “Stop” button to halt the MySQL service. This step ensures that there are no active connections to the database during the password change.
  3. Open the XAMPP Shell: In the XAMPP control panel, find the “Shell” button associated with the Apache module. Click on it to open the XAMPP Shell, which provides a command-line interface.
  4. Access the MySQL Command Line: In the XAMPP Shell, enter the following command and press Enter to access the MySQL command line
mysql -u root

5. By default, XAMPP uses “root” as the username for MySQL.

6. Change the Password: Once you’re in the MySQL command line, execute the following command to change the password for the root user:

ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘new_password’;

Replace 'new_password' with the desired password you want to set. Make sure to choose a strong and secure password.

6. Flush Privileges: After changing the password, execute the following command to flush the privileges, ensuring that the changes take effect immediately:

FLUSH PRIVILEGES;

7. Exit the MySQL Command Line: To exit the MySQL command line, type “exit” and press Enter.

8. Start the MySQL Service: Go back to the XAMPP control panel and click the “Start” button for the MySQL module. This action will restart the MySQL service with the new password in effect.

After following these steps, your XAMPP MySQL database password will be successfully changed to the new password you specified. Make sure to update your application or scripts that connect to the database with the new password to ensure proper functionality.

Related Posts

Exploring and Creating a Proof of Concept (POC) to Upload APK Directly from GitHub Package

Automating the process of uploading an APK (or AAB) to the Google Play Store from GitHub can significantly speed up your CI/CD pipeline. By integrating Google Play’s…

A Detailed Guide to CI/CD with GitHub Actions

Continuous Integration (CI) and Continuous Deployment (CD) are modern software development practices that automate the process of integrating code changes, running tests, and deploying applications. With the…

Step-by-Step Guide for Setting Up Internal Testing in Google Play Console

1. Understanding the Types of Testing Before uploading your Android app for internal testing, it’s essential to know the differences between the testing options available in Google…

The Complete 2025 Guide to GitLab Training, Certification, and Expert Trainers

Level Up Your DevOps Career: The Complete 2025 Guide to GitLab Training, Certification, and Expert Trainers Introduction to GitLab: The Backbone of Modern DevOps As businesses accelerate…

Site Reliability Engineering (SRE) Foundation Certification

Introduction to Site Reliability Engineering (SRE) Foundation Certification The Site Reliability Engineering (SRE) Foundation certification is an industry-recognized credential designed to provide students with a comprehensive understanding…

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x