Error 1045 When Running on Win7x64

[psionicsin]

Running Windows 7 Ultimate x64 with Full Admin Control and UAC is Totally off.

I'm following a tutorial I bought from Lynda.com called "MySQL Essential Training".

In the tutorial after the installation of XAMPP, the tutor opened up a command prompt and typed "mysql", and it showed him that it was running or whatever. However when I type that in (on a fresh install of XAMPP btw), I'm getting this:

Code: Select all

C:\Users\Administrator\desktop>mysql
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)
C:\Users\Administrator\desktop>


This is confusing me greatly though because MySQL seems to be activated here:


I even set my path in my environment variables. Can anyone help me along with this so I can continue my training???

[psionicsin]

Ok seems like I have to go though the process of first typing in:

Code: Select all

mysql -u root -p

And then I have to enter in the password, but...

The guy on the tutorial was able to just type:

Code: Select all

mysql

And everything worked. How do I get it to do this?

[psionicsin]

I'm also receiving constant 1064 ERRORS even though my syntax IS correct. Can someone help me here. I'm lost as to what to do or correct now.

[JonB]

Where did you install XAMMP?