k2k 5 Posting Whiz

i am at the <mysql dir> so i would do

scenario 1:
mysql -u root -p

i got prompt to enter password as expected. i typed a wrong password and got ejected.. type a right password and i am in. ok this is working fine.

scenario 2:
mysql -u root

this doesn't prompt me password but it just simply let me in. i am so confused. what is the point of setting up a root password then?
did i misconfigure anything?

scenario 3:
C:\wamp\bin\mysql\mysql5.1.36\bin>mysql
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: YES)

it looks like by default it would login with user ODBC... how do i set password for the user ODBC. i don't even see user ODBC in the user table.


please help me understand this. thanks in advance.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.