View Single Post
  #9  
Old 06-09-2003, 06:08 AM
IAtommy_pitts
Fire Beetle
 
Join Date: May 2003
Location: Florida
Posts: 17
Default THIS MIGHT HELP

Quote:
Originally Posted by tommy_pitts
Dude i had the same prob and the way i fixed it was to of course make sure the boot5zones said 127.0.0.1 for YourIP

Anyway go to your command prompt (start | run)
and type
(win 98/ME) command
(win 2000/xp) cmd

A command prompt should come up.

Then type;

cd c:\mysql\bin (press enter)
mysql.exe --user=root(press enter)
use eq(press enter)
GRANT ALL ON *.* to 'mysqlusername'@'127.0.0.1'(press enter)
IDENTIFIED BY '*.*';(press enter)


It then should say 0 rows effected

if doesn't work the try to get a screen shot when your run the boot5zones.bat (press the print screen next to F12 key)
then go to your wordpad or word and press Ctrl+V...
When you paste the screen shot and you can't read one of the zones then, keep trying. it can be frustrating but trust me that i tried about dozen and a 1/2 times before i could see it.

In the screen shot you should see

"Access denied for blah blah blah"

what ever the blah blah blah is change the 'mysqlusername'@'127.0.0.1' to with the appropriate quotes in it.

GRANT ALL ON *.* to 'mysqlusername'@'127.0.0.1'(press enter)
IDENTIFIED BY '*.*';(press enter)


still dosen't work then try to put your password also where it says

IDENTIFIED BY '*.*';

change the '*.*'; to 'yourcurrentmysqlpassword';

HOPE THIS HELPS!!!