Link to home
Start Free TrialLog in
Avatar of marrowyung
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.

User generated image
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:

User generated image
Avatar of David Favor
David Favor
Flag of United States of America image

I don't use MySQL Router + the docs suggest the problem is likely you're somehow disconnected from the KeyRing, where all the related user passwords are kept.

You'll debug access between MySQL Router + KeyRing.
Avatar of marrowyung
marrowyung

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 !
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.
I am suspecting my MySQLrouter didn't start at all, that's why I got that message:

User generated image
any idea why ?
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 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 !
ASKER CERTIFIED SOLUTION
Avatar of marrowyung
marrowyung

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial