mysql access in dos mode

[joonstar]

(1) I am using XP.
(2) I installed mysql, apache, and PHP a few days ago.
(3) there is phpMyAdmin folder in "htdocs" folder of my Apache.


I can't connect to mysql in dos mode.

I entered "mysql" in (C:/mysql/bin/).

Then, It says "ERROR1045: access denied for user 'ODBC@127.0.0.1'<using password: NO>"

(Q1)what does that mean "ODBC" in your guess?


(Q2)what is "127.0.01"?
It seems like "IP". but my IP was different number as I checked.


So, I enter "mysql -uroot -p".
then, It ask "password".

Because I created a new user and the password with the phpAdmin tool,
I entered the password.

It says "ERROR1045: Access denied for user 'root@127.0.0.1'<using password: YES>"

(Q)Do you see any problems in my approach to learning mysql and phpAdmin?

(Q) why does it deny my access to it?

(Q) what should I do for the access?

[mpjbrennan]

127.0.0.1 is the default IP address of your PC - otherwise known as localhost.

Have you tried mysql -uusername -ppassword where username and password are your XP account name and password?

patrick

[joonstar]

No, I havn't.

Now I am trying it as you recommend.


I am entering "mysql -uusername -ppassword " in C:/mysql/bin>.

oops,

It is saying "ERROR1045: Access denied for user 'username@127.0.0.1'<using password: YES>"

[raf]

HaHahahah :) Sorry. Good one. Hahahahahhaaahh You made my day. Sorry again.

with "mysql -uusername -ppassword" he meant something like
"mysql -u root -p yourpassword"

If you have not set a password, do
mysqladmin - u root password "yourpasword"
(include the quotes !)
if you have set a password, do
mysqladmin - u root -p status
You will then be prompted for your password

[joonstar]

thanks, mpjbrennan, and raf.