New Password Added Problomatic for WAMP
Posted by: cybersurfur (---.manc.cable.ntl.com)
Date: March 24, 2006 11:07AM

Hi Ive recently added a password to one of my databases.

I created the database first... didnt think to add a password at the time. But added one now thru 'PHPMyAdmin' but now it wont let me even access the localhost page keeps throwing an error saying Apache Crashed or something.

It wont also let me go back in the 'PHPMyAdmin' bit either.... now if i uninstall it and then re-install it i will loose all my data in the database.

Is there any other way round i can change it back????

Re: New Password Added Problomatic for WAMP
Posted by: cybersurfur (---.manc.cable.ntl.com)
Date: March 24, 2006 11:15AM

An access denied page has come up with the following error:

"phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server."

now ive found two config.inc.php files

One in the wamp\www\config.inc.php

and on in wamp\www\sqlitemanager\include\config.inc.php

Only the first one mentions password a couple of times but which line do i edit???????


imm soooooooooooooo confuuuussssseeeeeeeeeeeeddddddddddddddddd
not to mention frustrated!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Re: New Password Added Problomatic for WAMP
Posted by: Shift (---.266-1-64736c22.cust.bredbandsbolaget.se)
Date: March 24, 2006 08:11PM

Yes i have the same problem, I changed my password for root now i cant access. I get same message. And when i look in the files its just a big mess.
Please help

Re: New Password Added Problomatic for WAMP
Posted by: McGuffin (---.pppoe-dynamic.nl.aliant.net)
Date: March 26, 2006 09:12PM

Having the exact same problem. I've tried adding the password to the root user through phpMyAdmin and the MySQL command prompt. Any ideas would be welcome, I've tried poking around some of the phpMyAdmin files but nothing seems to work.

Re: New Password Added Problomatic for WAMP
Posted by: McGuffin (---.pppoe-dynamic.nl.aliant.net)
Date: March 26, 2006 09:19PM

Solved using this post:

[forum.wampserver.com]

Go into wamp\phpmyadmin\config.inc.php

And change the value on Line 73 to whatever you want your password to be.

Launch your MySQL command prompt and enter the following:

SET PASSWORD FOR 'root'@'localhost'=PASSWORD('new_password');

And you should be golden from there.

I apologize for making the post, I should have searched more extensively before asking for help.

Re: New Password Added Problomatic for WAMP
Posted by: Reyyan (---.CITMATEL.NET)
Date: March 29, 2006 10:33PM

I have a very similar problem.
I istalled WAMP5 1.4.4 with PHP5 and PHP 4.3.11 add-on.exe, the home page of phpmyadmin with PHP5 it shows well, but when i switch to PHP4 the fallowing error is shown.

"phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server."

It happened when i placed the password to the root user of MySQL in phpmyadmin,it did not happened before until that. I visited the archive conf.inc.php of phpmyadmin and gave it a new passward for a root user. It works with PHP5 but with PHP4 it is not possible to get in connection with MySQL server.

in the localhost page of wamp5 it seems to be a problem with the extentions mysql and mysqli.

I will be very much grateful if receiving any help from you to that respect.
Thank you.

Re: New Password Added Problomatic for WAMP
Posted by: DebW (---.hsd1.wa.comcast.net)
Date: July 11, 2006 12:51AM

Regarding the problem accessing PHPMyAdmin: I saw your fix, but I don't have a PHP editor to identify line 73. Could you give me the actual text to look for, instead?

McGuffin wrote:

> Go into wamp\phpmyadmin\config.inc.php
>
> And change the value on Line 73 to whatever you want your
> password to be.
>
> Launch your MySQL command prompt and enter the following:
>
> SET PASSWORD FOR 'root'@'localhost'=PASSWORD('new_password');

> And you should be golden from there.


Re: New Password Added Problomatic for WAMP
Posted by: DebW (---.hsd1.wa.comcast.net)
Date: July 11, 2006 01:13AM

Sorry, I also spoke too soon, I did find line 73, made the change, but when I opened the MySQL console, it doesn't provide a cmd line, it only wants a password -- which I do not have...

Deb


McGuffin wrote:

> Launch your MySQL command prompt and enter the following:
>
> SET PASSWORD FOR 'root'@'localhost'=PASSWORD('new_password');

Re: New Password Added Problomatic for WAMP
Posted by: CyberSpatium (67.170.181.---)
Date: July 11, 2006 02:55AM

Hello fellow NorthWesterner. I am from Oregon. When the MySQL console asks for a password, just press enter, because the root user has no password set.

Re: New Password Added Problomatic for WAMP
Posted by: GANYANCI (---.dynamic859616055.ttnet.net.tr)
Date: July 11, 2006 03:38PM

Too much people answered this question but no one's typed this line.

in C:\wamp\phpmyadmin\config.inc.php
line 73:

$cfg['Servers'][$i]['password'] = 'yournewpass'; // MySQL password (only needed
// with 'config' auth_type)

save and exit. (be carefull case sensitive)



Şans Gölgeniz Olsun !!!
Hiç Peşinizi Bırakmasın !!!

Sorry, only registered users may post in this forum.