WampServer

I have my password set for the mysql console any then when i enter my password into it, the console just closes down

any ideas on why??

thanks in advance

i took away my password and then when i hit enter it works fine
does this mean i cant use a password?

By default there is no password to mysql root account. You can setup a password if you so wish

i did set a password in config.inc.php , it still didnt work, then i noticed that underneath this is a line:
$cfg['Servers'][$i]['AllowNoPassword'] = true;

i changed it to false but it still didnt work, the only way i can get in is to have no password but that can be insecure as i am told


any ideas on it now??

you need to add the password first in mysql using phpmyadmin.. which will then lock you out of phpmyadmin

and then add that password to the config file so that phpmyadmin can log into mysql


in phpmyadmin click privledges > click the hand beside user " root localhost"

then scroll down just a tiny bit and add in ur password.

press go

now if you try login again it will fail

so add your password to the config file..

Once it works ok, you can totally delete that allownorootpassword=true line

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

i did everything you said but still the same story
how bad is it to have no password?

yes got it working, i did everything you said but the problem the last time was a clicked the go button at the bottom of the page not at the password part

thanks very much Steven Martin

no problem. your welcome

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