I am attempting to connect to a server with MaxScale on it (which in turn is connected to a master/multiple slaves setup). I can telnet to the MaxScale IP and port but can't connect using the MySQL console. Any ideas?
Asked
Active
Viewed 220 times
0
-
Posting more information would be helpful e.g. what port is MaxScale listening on and what is the exact MySQL console command you use. – markusjm Feb 08 '18 at 06:19
-
Thanks for your reply. I am successfully using telnet as "telnet 124.139.36.127 4006." The MySQL console command I am using is "mysql -h 124.139.36.127 --port=4006 -u evan -p" – eabates Feb 08 '18 at 14:38
-
Finally got it, I just had to add some permissions to my master/slaves (I had initially thought the MySQL console command specified a MaxScale user but it should actually specify a user from the MySQL machines). – eabates Feb 08 '18 at 17:13
-
I'd suggest resolving this question with your own answer, it might help other users. – markusjm Nov 15 '18 at 13:30