marrowyung
asked on
can't login to MySQL server via MySQL router
hi,
I have my MySQL 8.0.12 router, shell and community server installed and by some reason once MySQL shelled to the router it will prompt for login and never can login as it prompt for the following message:
I have bootstrap mysql router and start mysqlrouter accordingly.
I connection using MySQL shell and it has error:
Any reason why is that?
IP address of DB instance can be ping from that MySQL router node so connectivity is not a problem.
any reason why ?
this is the mysqlrouter.conf:
I have my MySQL 8.0.12 router, shell and community server installed and by some reason once MySQL shelled to the router it will prompt for login and never can login as it prompt for the following message:
I have bootstrap mysql router and start mysqlrouter accordingly.
I connection using MySQL shell and it has error:
Any reason why is that?
IP address of DB instance can be ping from that MySQL router node so connectivity is not a problem.
any reason why ?
this is the mysqlrouter.conf:
ASKER
"+ the docs suggest the problem"
which doc sorry ?
"ou're somehow disconnected from the KeyRing, where all the related user passwords are kept."
but it is only via the router ? not via shell directly to the MysQL node !
which doc sorry ?
"ou're somehow disconnected from the KeyRing, where all the related user passwords are kept."
but it is only via the router ? not via shell directly to the MysQL node !
ASKER
i am sure it is the MysQL router problem but I have bootstrap that and start the MySQL router by running mysqlrouter &
it should works well but it is not !
why I said it should works ? now my mySQLrouter and MySQL shell are installed in a SAME separate MySQL nodes, if I use only MySQL shell to connect to a remote MySQL nodes it is working fine ! so it is not network problem.
if I MySQL shell on the local MySQL router and expect MySQL router to connect to those remote MySQL nodes then it is not working well.
then it is the MysQL router having problem.
it should works well but it is not !
why I said it should works ? now my mySQLrouter and MySQL shell are installed in a SAME separate MySQL nodes, if I use only MySQL shell to connect to a remote MySQL nodes it is working fine ! so it is not network problem.
if I MySQL shell on the local MySQL router and expect MySQL router to connect to those remote MySQL nodes then it is not working well.
then it is the MysQL router having problem.
ASKER
Are you sure you shoukd be using root@ip-of-router
Are you able to connect to the MySQL ?
mysql -u root -h rhel7.5 -p
If the host is local, try
mysql -u root -h localhost -p
Alternative the root@routerhost does not have rights to access what it need.
Is this a new setup, or a previously working ....
Are you able to connect to the MySQL ?
mysql -u root -h rhel7.5 -p
If the host is local, try
mysql -u root -h localhost -p
Alternative the root@routerhost does not have rights to access what it need.
Is this a new setup, or a previously working ....
ASKER
"Are you sure you shoukd be using root@ip-of-router"
yes ! the MySQL router manual can tell.
"Are you able to connect to the MySQL ?"
yes
"Is this a new setup, or a previously working ...."
yeah !
yes ! the MySQL router manual can tell.
"Are you able to connect to the MySQL ?"
yes
"Is this a new setup, or a previously working ...."
yeah !
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You'll debug access between MySQL Router + KeyRing.