mysqlfailover command gives Error 1045: Access denied for user 'root'@'localhost' (using password: NO)

Aamir Published at Dev

35

Aamir

I am trying to run mysqlfailover using workbench console:

 mysqlfailover --master=root@localhost:3306 --discover-slaves-login='root' --log=log.txt

and I am getting the error :

ERROR: Cannot connect to the master server.
Error 1045: Access denied for user 'root'@'localhost' (using password: NO)

I tried to google but found nothing. Mysql version is 5.6.17.

Shantanu

This error is simply saying that user root@localhost is not allowed to execute this command with no password. If you have the password set for root@user modify you command as " mysqlfailover --master=root:YOURMYSQLPASSWORDFORROOT@localhost:3306 --discover-slaves-login='root' --log=log.txt"

This should solve the problem.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-03-15

Comments

0 comments

Login to comment

Related

I got ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) with the command sudo mysql on ubuntu

OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: YES)")

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO), can't reset password either

Brew mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

mysql -v ERROR 1045 (28000): Access denied for user root'@'localhost' (using password: NO)

mysql-docker-container - ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

lavaral 5 ERROR{ (SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)}

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

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) on MAC OSX

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) after set plugin = ''

openproject configure throws "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)"?

Rails database issue - ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

My ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

django:mysql:error(1045, "Access denied for user 'root'@'localhost' (using password: NO)")

error: 'Access denied for user 'root'@'localhost' (using password: YES)'

SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) (SQL: select * from `permissions`)

django.db.utils.OperationalError: (1045:Access denied for user 'root'@'localhost' (using password: NO)

Laravel auth: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)

django.db.utils.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: YES)")

("SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)")

[PDOException]: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: NO) Symfony2

SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES) symfony2

FIX MYSQL ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: NO) in Linux

#1045 - Access denied for user 'azure'@'localhost' (using password: YES)

MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES)

Laravel 5 error SQLSTATE[HY000] [1045] Access denied for user 'homestead'@'localhost' (using password: YES)

Laravel 5 error SQLSTATE[HY000] [1045] Access denied for user 'forge'@'localhost' (using password: NO)

TOP Ranking

Article

HotTag

Archive