Thread: SQL Version
View Single Post
  #3  
Old 03-26-2004, 08:32 AM
samandhi's Avatar
samandhi
Demi-God
 
Join Date: Aug 2003
Posts: 1,056
Default

You'll be using the UN/PW that you assinged MySQL when you ran winmysqladmin.exe Just open up a dos command and type the following...
Code:
cd /mysql/bin
mysql -u root mysql
GRANT ALL PRIVILEGES ON *.* TO <username>@localhost IDENTIFIED BY '<password>' WITH GRANT OPTION;
quit
Note the all caps, and also the ' (apostrophe) keys before and after your password (this IS needed)... One more thing to note, dont use the < and > keys in your UN/PW This SHOULD solve your problem..

If it doesnt open up windows explorer or mycomputer and browse to C:/windows find the file my.ini and delete it... Now browse to C:/mysql/bin (assuming you intalled mysql in default location), and run winmysqladmin.exe, and it should ask you for a new username and password, then repeat the GRANT command from above....
Hope this helps you out....
__________________

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