I have a MySQL database on a server that I’m trying to access from my local machine using Base. I keep getting the error message that is the title of this thread. When I go to “More”, I see “SQL Status: 28000
Error code: 1045”. I’ve been accessing the db through the CLI frequently, so I know I have the user set up correctly for remote access, and I’m certain I’m using the correct username and password.
Version: 188.8.131.52 (x64)
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
I can’t figure out why Base is behaving differently from the CLI.
I’m using the mysql-connector-java-5.1.44. Anyone have any suggestions?
Addendum: I’ve done a little experimenting, and any other user can log in through the same .odb/connector configuration. Also the ‘Root’ user can log in through the CLI.
Second Addendum: I’ve also tried creating a new.odb file connected to the same server, and it would not connect, even with a login that is working in my working .odb file.