Posted by:
fionapain
(---.pres.cable.virginmedia.com)
Hi Paul, I am struggling with simular thing though have progressed a little further, the reason your MySQL is beeping and requiring pass is that you have not yet set the pass if you enter as if no pass it will run, however, to set the pass, I am using WAMPSERVER, though you can get to the same place via start-accessories-command prompt.... you then need to type out the following
use mysql
it will respond with "database changed"
UPDATE user [press return]
SET Password=PASSWORD('PUT IN YOUR PASSWORD HERE') [PRESS RETURN HERE}
WHERE user='root' ; [PRESS RETURN HERE]
it will respond with Query ok, 1 row affected <0.00 sec>
Rows matched: 1 warnings:0
Hope that makes sense,
to set the phMyAdin needs to be changed differantly I assume that as you mention the little green "w" you too are using WAMPSERVER
open c:\wamp\apps\phpmyadmin\config.inc.php
look for: $cfg['Servers'][$i]['password'] = ''; and put your password inbetween the quotes
save and close then reopen and it should work fine
Here is a link for WAMP [
forum.wampserver.com]