WampServer

i installed the latest version of WAMP. everything setup perfect and when i opened 'phpmyadmin' it said the root didn't have a password, so i created one.

ever since i did that, when i open phpmyadmin i get a 1405 error saying 'access denied' from mysql, password=NO.

when i open MySQL in WAMP, it asks me for a password and i enter the correct password i used and i get 'access denied' again, password=YES

i have tried to uninstall WAMP and manually delete the folders, but everytime i reinstall WAMP, it appears my old settings are active since it asks me for a password. how can i fully remove WAMP, or remove the root password?

btw, i am on Windows Vista.



Post Edited (11-14-07 17:02)

You should check my web site for proper setup password before uninstall wamp; anyway, after uninstall wamp, delete wamp folder, clean wampapache and wampmysql in registry, restart computer, then reinstall wamp

Have fun,

[test.jlbn.net] (Sample Test Codes for PHP, MySQL, SQLite, ASP.net, SQL, JSP)
[www.jlbn.net] (Basic Guide for WAMP & Add-ons)

i will def use your setup guide for the password, but i already untinstalled wamp, removed the 'wamp' folder as well as the 'mysql' folder i had. i searched for the

'wampapache' & 'wampmysql' keys in the registry, but i couldnt find anything..

where are those keys/values located?

i think the registry files might be my problem because when i tried to reinstall WAMP, it installed fine, but MySQL prompted me for a password (even thought i hadnt set one up).. i tried to use the password i created from phpmyadmin on the prior install, but it gives me 'access denied', and i cant get into phpmyadmin on a fresh install it says error 1045 access denied from mysql, password=NO.

any ideas where the registry keys are located? tks.

If you'e trying w/ mysql console, try to hit Enter (ie. blank password)

Have fun,

[test.jlbn.net] (Sample Test Codes for PHP, MySQL, SQLite, ASP.net, SQL, JSP)
[www.jlbn.net] (Basic Guide for WAMP & Add-ons)

i did a search for 'wampapache' and 'wampmysql' in the redistry editor using the FIND feature, but it found NOTHING.

when i goto Administration Tools->Services

i see 'MySQL5', with nothing under the STATUS area and the startup type set to AUTOMATIC

if i deleted MySQL5, why would it still show in the services? even though its not running.


i appreciate any help, tks.

Did you ever have any apache or mysql before? If yes, try to clean up apache and/or mysql in registry

Have fun,

[test.jlbn.net] (Sample Test Codes for PHP, MySQL, SQLite, ASP.net, SQL, JSP)
[www.jlbn.net] (Basic Guide for WAMP & Add-ons)

yes, i did have apache and mysql before.

i removed both prior to installing WAMP (the first time), and i didn't have any problems loading phpmyadmin until i change the 'root' password (using phpmyadmin). thats the ONLY thing i ever did in WAMP too.

as soon as i did that, i had the 2 problems:

1) phpmyadmin gave me the '1504 access denied on mysql password=NO' error.

2) mysql asks for a password now, but when i enter the password i set the root to
in phpmyadmin (in privledges tab), mysql says 'access denied 28000 password=YES'

if i enter NO PASSWORD, and hit enter.. mySQL starts.

how do i change my setup so i can use phpmyadmin again?

Then, you have to check my web site for proper password setup

Have fun,

[test.jlbn.net] (Sample Test Codes for PHP, MySQL, SQLite, ASP.net, SQL, JSP)
[www.jlbn.net] (Basic Guide for WAMP & Add-ons)

i went through the registry and deleted every tag/value with 'mysql' and 'apache'. i then rebooted the OS and MySQL5 was NOT on the services list.

i then reinstalled WAMP, and phpmyadmin worked like it did the first time i ran it (stating that the config file contains a root with no password).

i went to MySQL and opened the console. it asked me for a password, i left that blank and hit ENTER. MySQL> appeared and it seemed like i was in.

my question now is this normal for MySQL to ask for a password, even if its blank?

*i will setup my password next as per your website. i am only using this to test local php and mysql stuff, do you think it's even worth changing the root password for local
testing?

Quote

my question now is this normal for MySQL to ask for a password, even if its blank?

Yep, it's normal that mysql always come w/ default user "root" and blank password, and that's why you should immediately setup password for your own security

Quote

i will setup my password next as per your website. i am only using this to test local php and mysql stuff, do you think it's even worth changing the root password for local testing?

Yep, you never know if someday someone might use your computer/laptop and accidentally make just a "little" mistake which cause you a very "big" headache to fix it

Have fun,

[test.jlbn.net] (Sample Test Codes for PHP, MySQL, SQLite, ASP.net, SQL, JSP)
[www.jlbn.net] (Basic Guide for WAMP & Add-ons)

i tried to edit config.inc.php

by changing the line to:

$cfg['Servers'][$i]['<mypasswordwashere>'] = ''; // MySQL password

where i put my real password between the ' ' quotes.

when i restart apache, and all services and try phpmyadmin i get the following error:

that it cant read the config.inc.php file..?

i also noticed when i opened config.inc.php in WordPad it says the following at the top:

/* !!! DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!! */

this is supposed to be the 'config.inc.php' file though.. any ideas?

You did it wrong, and that's why php can't run

Origginal line is:

$cfg<'Servers'><$i><'password'> = ''; // MySQL password (only

Then you change it as follows:

$cfg<'Servers'><$i><'password'> = 'put_your_password_here'; // MySQL password (only

Edit it, save it, then restart wamp to take effect

Have fun,

[test.jlbn.net] (Sample Test Codes for PHP, MySQL, SQLite, ASP.net, SQL, JSP)
[www.jlbn.net] (Basic Guide for WAMP & Add-ons)

how do u delete staff from the registry?



wacksbid

thanks yfastud, you really helped me out. i got it working locally to test php and mysql.

wacksbid-

to delete stuff from registry i did the following: (on Vista)

Start->Run-> type 'CMD' .. type 'regedit' , registry editor opens.

I did a search for anything containing 'mysql' by doing CTRL-F .. then type 'mysql' NEXT

i deleted every 'mysql' KEY. hope this helps.