I have two nodes: node1
and node2
. I want to access MySQL installed on node1
from node2
.
I have so far tried using grant all privileges on *.* to 'mysql'@'node2.openstacklocal' with grant option;
on MySQL but I still get the below error:
===ERROR=== [mysql@node2 ~]$ mysql -p -h mgmt.openstacklocal -u mysql -P 3306 Enter password: ERROR 1045 (28000): Access denied for user 'mysql'@'node2.openstacklocal' (using password: YES)