today i wanted to know how i can login using the linux shell command well, if you want to know also, here it is, i will show you how you can. so this is what i did. i first logged in as root the send this commmands. NOTE: i was using a fedora linux server:

mysql -h localhost -u root -p

you will be prompted to enter password, after you enter password, you will go inside mysql. you will know you are in the mysql prompt because it will show like this: mysql>

this is what i got:
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 23
Server version: 5.0.45 Source distribution

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql>


no now you can enter whatever command you want.