WampServer

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????

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!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

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

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.

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.

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.

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.

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');

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.

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 !!!