phpmyadmin can't access mysql after changing localhost PW

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

Re: phpmyadmin can't access mysql after changing localhost P

Postby tedfull » 28. May 2013 22:31

In the phpmyadmin folder on your computer you will see a file called config.inc.php

Make sure to change this info with you new password:

/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = ' new password '; <---- This has to be changed to your new password
$cfg['Servers'][$i]['connect_type'] = 'socket';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;

There is another config file and I think that is what is messing with people.
tedfull
 
Posts: 1
Joined: 28. May 2013 22:24
XAMPP Version: 5.6.3
Operating System: MAC OS X

Re: phpmyadmin can't access mysql after changing localhost P

Postby Altrea » 29. May 2013 03:53

Hi tedfull,

Thank you for your feedback.

tedfull wrote:There is another config file and I think that is what is messing with people.

There is only one config file and one sample file. The name is very clear i think :D

best wishes,
Altrea
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: 6536
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: W7Ux64

Re: phpmyadmin can't access mysql after changing localhost P

Postby Tektek » 30. May 2013 22:12

Hi,

I have also the same problem. I have tried all of the above suggestions, but it still does not work.

I have tried the following:
1. run resetroot.bat in mysql;
2. http://localhost/security/index.php to reset one password;
3. in config.inc.php, I have changed to the following setting:
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'testtesttest'; <- new password
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';

$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'socket';
$cfg['Servers'][$i]['compress'] = false;

4. in my.ini file I have also changed to new password:
password = testtesttest
port = 3306
socket = "/xampp/mysql/mysql.sock"
default-character-set = utf8

It still can not be connected. What is still missing at me? Thanks!

The original error is:
--------------------------------------------
Fehler
MySQL meldet:

#2002 -
Der Server antwortet nicht (evtl. ist der Socket des lokalen MySQL-Servers nicht korrekt konfiguriert).

Verbindung für den controluser, wie er in Ihrer Konfiguration angegeben ist, ist fehlgeschlagen.
-------------------------------------------

my SW version:
xampp: 1.8.1
os: windows 7
xampp control panel version: 3.1.0
Last edited by Tektek on 30. May 2013 22:31, edited 1 time in total.
Tektek
 
Posts: 3
Joined: 30. May 2013 21:55
XAMPP Version: 5.6.3
Operating System: Win7

Re: phpmyadmin can't access mysql after changing localhost P

Postby hackattack142 » 30. May 2013 22:22

Hello,

You need to actually change the password in the database first before you can tell clients to use it.

If the root password is empty, you should be able to do this from the XAMPP security page
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 702
Joined: 20. May 2011 23:29
XAMPP Version: 5.6.3
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: phpmyadmin can't access mysql after changing localhost P

Postby Tektek » 30. May 2013 22:38

hello,

yes I can change the password from the XAMPP security page, and did it. I have changed the password to "testtesttest". And then tried to adapt the password in config.inc.php and my.ini. But it still does not work.
Tektek
 
Posts: 3
Joined: 30. May 2013 21:55
XAMPP Version: 5.6.3
Operating System: Win7

Re: phpmyadmin can't access mysql after changing localhost P

Postby hackattack142 » 31. May 2013 03:24

You should not be putting passwords in my.ini

As for config.inc.php, if you want to use the password in this config file, you need to change this:
Code: Select all
$cfg['Servers'][$i]['auth_type'] = 'cookie';
from 'cookie' to 'config'
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 702
Joined: 20. May 2011 23:29
XAMPP Version: 5.6.3
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: phpmyadmin can't access mysql after changing localhost P

Postby Tektek » 31. May 2013 11:19

It works! Thanks very much!
Tektek
 
Posts: 3
Joined: 30. May 2013 21:55
XAMPP Version: 5.6.3
Operating System: Win7

Re: phpmyadmin can't access mysql after changing localhost P

Postby savvy » 23. August 2013 16:58

shukri_alquwatli I literally have no words to thank you. It's taken me two days to figure this out and I would've not done it without your post
savvy
 
Posts: 1
Joined: 23. August 2013 16:49
XAMPP Version: 5.5.19
Operating System: windows vista

Previous

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 61 guests