How to change MySQL password back to default

Problems with the Windows version of XAMPP, questions, comments, and anything related.

How to change MySQL password back to default

Postby promoteglobal » 13. April 2016 09:11

Hi everyone, I'm a newbie trying to learn everything on my own. I looked up how to change the MySQL password through the shell and now I don't know how to change it back to a default. I don't have access to the phpMyAdmin now. (I'm looking from the host computer.) I read later that once you change the MySQL password that other parts of the site won't work because it assumes access to this part of the site as blank. How do I change the password back to blank. Of course I will put a password back, but until I can figure out how everything works, it's probably best that I change it back to blank.
promoteglobal
 
Posts: 2
Joined: 13. April 2016 08:49
XAMPP version: 5.5.33
Operating System: Windows 7 Premium

Re: How to change MySQL password back to default

Postby Altrea » 13. April 2016 09:16

Hi,

Follow this guide: [Q&A] Setting MySQL root password
In section 1a II. you need to change the command a little bit

instead
Code: Select all
mysql --user=root --password=


you have to add the current password at the end like so
Code: Select all
mysql --user=root --password=mypassword


In section !a III. you need to leave the password in between the single quotes blank like so:
Code: Select all
SET PASSWORD = PASSWORD('');
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: How to change MySQL password back to default

Postby promoteglobal » 13. April 2016 09:41

Thank you! That worked!
promoteglobal
 
Posts: 2
Joined: 13. April 2016 08:49
XAMPP version: 5.5.33
Operating System: Windows 7 Premium


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 51 guests