ERROR 1045 (28000): Access denied for user 'vindhya'@'localhost' (using password: NO)

this is the error massage I got... i don.t know how to log mysql


You can't access mysql with user root without using a username, this is normal behavior of mysql.

All you have is to provide the password using -p option

mysql -u vindhya -p userPassword

You should have been able to set up a password while installing MySQL. Assuming you did, you should use the following syntax to log on to your server:

mysql -u vindhya -pyourpasswordnexttotheP -h127.0.0.1

If you get the same or similar error, try:

mysql -u vindhya -pyourpasswordnexttotheP -h127.0.0.1 --protocol=tcp

The password you entered is wrong , try typing your correct password


Follow the link so that your problem gets solved



At installalation mysql-server asks for a password, this is for the mysal root user,who is not identical to your systems root user. Mysql has its own users. Look in /etc/mysql/conf.d/debian.cnf for user debian-sys-maint user and pawword and connect with

mysql -u debian-sys-maint -p

It will ask for the password that is also in that file.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.