Re: How to login into mysql as a different user rather than root without entering password and username?

[Lee Wood]

If you have an account on the computer from which you wish to log-in to MySQL, then MySQL will assume by default that that's your MySQL account name as well. For example, let's say I have an account on my lap-top: lee.wood
Let's also assume that my laptop is called leez-laptop, and it has MySQL installed. Therefore, when I log-in to my laptop, and then to MySQL, if I don't tell it otherwise, MySQL will assume I am trying to log-in to the MySQL account: lee.wood@localhost

If, on the other hand, I want to log-in to a MySQL account from my laptop, on a database server somewhere on my local network, then MySQL on that server will generally assume that the account I'm trying to log-in to is: lee.wood@leez-laptop or lee.wood@theIPAddressOfMyLaptop (e.g. lee.wood@142.18.20.76 )

This just mentions the basics. There are a few more permutations you can find if you read about MySQL Account Management: http://dev.mysql.com/doc/refman/5.0/en/user-account-management.htmlhttp://dev.mysql.com/doc/refman/5.0/en/user-account-management.html