View Single Post
  #2  
Old 03-27-2004, 05:20 AM
samandhi's Avatar
samandhi
Demi-God
 
Join Date: Aug 2003
Posts: 1,056
Default

Do you remember the UN and PW you used when you ran winmysqladmin.exe for the first time? You will need this.. then open up a dos command window and type the following, where username is the username from winmysqladmin.exe, and password is from the same:
Code:
cd c:/mysql/bin
mysql -u root mysql
GRANT ALL PRIVELEGES ON *.* TO username@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;
quit
Note the single quotes around the password ARE needed here...

If you cant remember the UN and PW you assigned when you first ran winmysqladmin.exe then open up windows explorer or mycomputer and browse to c:/windows and find the file my.ini and delete it.. Now browse to c:/mysql/bin and run winmysqladmin.exe and it will ask you for a UN and PW... type one in there and remember it.. NOW do the GRANT command again from above and you should be all set... Hope this helps>>>>
__________________

Quote:
Analysis paralysis will keep you from failing, but it will also keep you from succeeding.
  • L.L. CoolJ