Open GoogleCodeExporter opened 8 years ago
more info on this
1. mha.conf file
[mhadmin@test4 ~] cat /etc/mha.conf
[server default]
user=root
password=xxxx
ssh_user=mhadmin
manager_workdir = /tmp/mha
remote_workdir = /tmp/mha
manager_log = /tmp/mha/mha.log
master_binlog_dir = /var/log/mysql/logs/binlogs
[server1]
hostname=test1
candidate_master=1
[server2]
hostname=test2
candidate_master=1
[server3]
hostname=test3
candidate_master=1
2. 'root' user exists on host test2
root@test2 [(none)]> select user,host from mysql.user where user = 'root';
+---------+-----------+
| user | host |
+---------+-----------+
| root | % |
| root | localhost |
+---------+-----------+
3. able to connect to mysql locally on test2
[mhadmin@test2 ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 99
Server version: 5.6.19-67.0-log Percona Server (GPL), Release 67.0, Revision 618
Copyright (c) 2009-2014 Percona LLC and/or its affiliates
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
root@test2 [(none)]>
Original comment by ashok.ji...@gmail.com
on 21 Jul 2015 at 11:13
This issue got resolved.
Resolution:
'root'@'local_hostname' user was missing somehow. I created that and it worked
like a charm.
Original comment by ashok.ji...@gmail.com
on 31 Jul 2015 at 5:54
Original issue reported on code.google.com by
ashok.ji...@gmail.com
on 20 Jul 2015 at 11:00