Skip to content

Instantly share code, notes, and snippets.

Last active November 16, 2023 16:04
  • Star 14 You must be signed in to star a gist
  • Fork 5 You must be signed in to fork a gist
Star You must be signed in to star a gist
What would you like to do?
How to reset `root` password in XAMPP MySQL

Open C:\xampp\mysql\bin\my.ini (MySQL config file)

Find the line [mysqld] and right below it add skip-grant-tables. Example:

# The MySQL server
port= 3306
socket = "C:/xampp/mysql/mysql.sock"
basedir = "C:/xampp/mysql" 
tmpdir = "C:/xampp/tmp" 

This should allow you to access MySQL if you don't know your password.

Stop and start MySQL from XAMPP to make this change take effect.

Next, in command line, connect to MySQL:

C:\xampp\mysql\bin\mysql.exe --user=root

Once in MySQL command line "select" the mysql database:

USE mysql;

Then, the following command will list all your MySQL users:

SELECT * FROM user \G;

You can scan through the rows to see what the root user's password is set to. There will be a few root users listed, with different hosts.

To set all root user's to have a blank password, run this command:

UPDATE user SET password = '' WHERE user = 'root';

When you're done, run exit; to exit the MySQL command line.

Next, re-enable password checking by removing skip-grant-tables from C:\xampp\mysql\bin\my.ini.

Save changes, restart MySQL from XAMPP.

Test it

Finally, test you can connect to the database using username root and password '' (blank) via one of the following methods:

  1. Attempting to access phpMyAdmin (http://localhost/phpmyadmin)
  2. Run the debug route I provided from within one of your Laravel apps
Copy link

Thank you so much! I use Linux but one of my clients is using Windows.
We got stuck with MariaDB on root password error and tried 10 other tutorials. Failed.
After 1 hour, this finally worked!

Great job!

Copy link

wcroth55 commented Mar 6, 2019

TYPO ALERT! Your diagram shows "skip-grant-tables" under [mysql], but your text says put it under [mysqld]. The latter is correct, the diagram/screen-shot is wrong.

Copy link

Removed the screenshot that had the typo.

Copy link

sl5net commented Mar 29, 2019

of some reasons. mysql server is just 3 seconds on, after i have addet skip-grant-tables behind [mysqld]

Copy link

wagaana commented May 10, 2019

Thanks, a lot I had messed almost everything.

Copy link

Thank you! If anyone got the error
ERROR 1194 (HY000): Table 'user' is marked as crashed and should be repaired ERROR: No query specified
after running this SELECT * FROM user \G;
Then to repair the table you can use the following command

Copy link

alem2019 commented Oct 6, 2019

Worked. Great!

Copy link

Thank you susanBuck. Worked great!

Copy link

I am using a fresh install of XAMPP on a Windows 10 machine. The install goes great but as soon as I change the password for localhost:root I am locked out of the admin section for MySQL. I was able to bypass password checking with the skip-grant-tables line, but unable to reset the password for root users - I get a message that changes are not allowed to the column. I did not have this problem on a previous machine / install and am completely unable to determine a cause for this problem. Any suggestions as to how to change the root password and still be able to use the admin functions in XAMPP?

Copy link

FatmaUc commented Sep 4, 2020

Hi, i am receiving " Column 'Password' is not updatable" error.

How can i resolve it.
your help will be much appreciated

Copy link

Thank you very much .

Copy link

Hi, i am receiving " Column 'Password' is not updatable" error.

How can i resolve it.
your help will be much appreciated

yah, how did you solved it?

Copy link

Thanks susanBuck, it worked for me

Copy link

Thank u a lot !
U saved me from hassle 🙃😘

Copy link

Hi, i am receiving " Column 'Password' is not updatable" error.

How can i resolve it. your help will be much appreciated

i have the same problem...

Copy link

me too can you give us solution

Copy link

go2amp commented May 16, 2023

ERROR 1348 (HY000): Column 'Password' is not updatable

Not a solution.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment