mysql client works on Redhat, but mysql shell does not on Windows
Posted by:
James Lum
Date: October 09, 2024 11:38AM
Hi,
We have a Mysql database and, originally, I was using Mysql client on a Redhat machine to access the database, and I was connecting to the database successfully.
Then, I installed Mysql shell (mysqlsh) on a Windows machine and tried the same log in (but using mysqlsh, and I was surprised that the log in did not work.
The command line I used was:L
mysqlsh -h xxx-mysql-test.chvinrmx7mvr.1.rds.amazonaws.com -P 3306 -u admin -p
and the error I got was:
Creating a session to 'admin@mysql-test.chvinrmx7mvr.1.rds.amazonaws.com:3306'
MySQL Error 1045 (28000): Access denied for user 'admin'@'xx.yy.1.13' (using password: YES)
[NOTE, the xx.yy.1.13 was the IP of the Windows machine the mysqlsh was running on]
I checked the database, it has the username "admin" and host is "%".
I've tried several variations of the command line, e.g., with 'admin'@'%' but they all fail.
I don't understand why the mysql client on the redhat works file with just "admin", whereas the similar mysqlsh command on Windows is failing.
Also, if anyone knows, I'd like some guidance about how I could make the login work on the mysqlsh on Windows?
Thanks,
Jim
Subject
Written By
Posted
mysql client works on Redhat, but mysql shell does not on Windows
October 09, 2024 11:38AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.