Mysql logging in even without providing password

Question

mysql logging in the prompt even not providing password , If provided like mysql -u root -p its prompting for password if provided like mysql -u root its logging in without asking for password i have run the query

select user,hosts from mysql.user; 

and came to know there are 3 root users with different hosts as shown

+------+-------------+
| user | host        |
+------+-------------+
| root | 127.0.0.1   |
| root | db-busindia |
| root | localhost   |
+------+-------------+

And interesting thing is that mysql server name is also db-busindia , is root@'db-busindia' the culprit ?

Answer 1

Check the [client] section of my.cnf file for the lines:

user=root 
password=some text.

These enable you to log in without a username or password. Delete password line, if you want to be prompted for password.