I changed the password in the console and broke Xampp

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

I changed the password in the console and broke Xampp

Postby dumb » 18. January 2019 12:35

Hi all, new here, first post...

I changed the password by following this:

Code: Select all
How can I set a root password in MySQL?

    Configure it with the "XAMPP Shell" (command prompt). Open the shell from the XAMPP control pane and execute this command:
    mysqladmin.exe -u root password secret
    This sets the root password to 'secret'.


Now my phpmyadmin won't login. Where do I update the password to phpmyadmin?

Image
dumb
 
Posts: 2
Joined: 18. January 2019 12:31
XAMPP version: 3.2.2
Operating System: Windows 10

Re: I changed the password in the console and broke Xampp

Postby Altrea » 18. January 2019 17:51

In phpmyadmins configuration file config.inc.php
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: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: I changed the password in the console and broke Xampp

Postby dumb » 21. January 2019 10:32

Thanks! I finally worked it out.

Anyone looking for this solution in future:

Go in to your XAMPP directory, and look for a folder called phpMyAdmin, for me it was c:\xampp\phpMyAdmin
and look for a file called config.inc.php

Open it in an editor (like notepad) and change the password to secret.

So it should look like this:

Code: Select all
/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'secret';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';


Then go to your XAMPP control panel and stop/start Apache and MySQL. Then things will be back to normal again. Yay! :D
dumb
 
Posts: 2
Joined: 18. January 2019 12:31
XAMPP version: 3.2.2
Operating System: Windows 10


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 110 guests