This is bugging the crap out of me. A few days ago I installed of MySQL 4.0.12 on Windows XP. All's fine (so far), but I can't figure out how to set the root password. I thought I had done it yesterday, but just discovered it didn't take.
I've followed the instructions in the MySQL reference manual http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Windows_running , but it never seems to work. I've already done this part:
C:\> C:\mysql\bin\mysql mysql mysql> DELETE FROM user WHERE Host='localhost' AND User=''; mysql> QUIT C:\> C:\mysql\bin\mysqladmin reload
And I'm assuming that I don't have to do that again for everytime I try setting the root password, especially since no password has been set yet. Here's what I type, which as I understand, is how I set the root password...
C:\mysql\bin\> mysqladmin -u root password onyoung
'onyoung' being my intended password. This isn't working though. So, what am I missing here?
Dev
_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]