WampServer

Hi Steven,
I am trying to set up a password as when i click on myswl console it requires a password. I tried following the guide and tells me to click on phpMyAdmin. When i click on this it redirects me to a page where it does not provide me with information to change passwords. This is the information that appears

Welcome to phpMyAdmin 2.11.6

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

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
Open new phpMyAdmin windowOpen new phpMyAdmin window

Any ideas as to what i should do?
Thanks
Monica

i presume you set a password in mysql?


open C:\wamp\apps\phpmyadmin2.11.6\config.inc.php

find this line


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

and put the password you set in between the ''

then save and try again

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

follow my guide here

[guides.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Hi Steven,
I have followed your guide but i cannot go ahead after clicking on phpMyAdmin as im getting an error when this page opens. This is the error that im getting

Welcome to phpMyAdmin 2.11.6

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

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: No)

Any ideas as to what i can do? i even tried setting a password and trying it but didnt work

Monica

I am getting the identical error.

I tried to set the password of the MySQL server and
change the phpmyadmin password.
I still get this error.

Hi,

It worked!! Yea! You will need to delete all wamp folders and remove the program. Restart your computer and reinstall WAMP. Make sure You delete any existing WAMP folders.

Thanks for you help though
Monica

hi are you sure u filled in the password?! cos it says "Using Password:NO"

which means there is no password in the config.inc file


if u have filled it it then.. below the error you are getting to the right click (open in new window)

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

hi monica . u didnt neeed to do this! oh well

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Monica, then now you should follow my guide here to setup password

[guides.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Hi. This worked thanks. Regards. Ewan

If I just install WAMP, and make no changes, when attempting to use phpMyAdmin, in the browser I get


Error

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

I have read the comments above, and looked at the suggested help, but that does not seem to cover it.
Thanks.

search and delete any my.ini file outside wamp folder then follow the guide here to setup password

[blog.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

I renamed the my.ini to myw.ini and all its reference to myw.ini, this is because i have a diff installation of mysql too, i still cant get it to work.

if i add a pwd then it sees the first installation of mysql and not what WAMP installed!

-U

You might need to manually kill the other MySql - it's quite likely also on port 3306.

i have changed the port that the WAMP service for MySQL runs on to 3307...

so now i can access the PHPAdmin page, but still when i goto htto://localhost/ i get "it works" and not the page that the guide says i should see...

-U

Must be coming from an html or php in your ...wamp/www folder

its from the apache html... what you get when you install apache as a stand alone http server...

what i see is that its not registering the PHP for some reason..now even the phpAdmin page is not working...
:-(((

-U

Hi Monica.
Had the same problem. Found this link:

[www.phpfreaks.com]

Copy the link into your browser and follow the instructions.
It worked for me.
PP

Quote

its from the apache html... what you get when you install apache as a stand alone http server...

actually, it's from either iis or stand-alone apache, so you should try to disable iis first

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

What Steven has said, works perfectly.
However, if it does not work for you try clearing your browser cache.
It worked for me after the cache was cleared.



Date: October 12, 2008 10:56PM

i presume you set a password in mysql?


open C:\wamp\apps\phpmyadmin2.11.6\config.inc.php

find this line


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

and put the password you set in between the ''

then save and try again

Steven Martin