Going to attempt MySQLAuthenticationMethodOldPassword.ħ 02:17:47:137 mysql:connect using MySQLAuthenticationMethodOldPasswordħ 02:17:47:137 MySQL going to connect with Authentication: mysql_old_password.ħ 02:17:47:147 doConnect databaseClient->connect finishedħ 02:17:47:147 setDBC: connectionId: 4752F4AA-F175-473C-8E49-CA2683456854-2939-00006DABC37BEFF8ħ 02:17:47:147 checkSSHFingerprintError returning NOħ 02:17:47:147 HSMinimumDelay need to wait 0.98 seconds (elapsed was 0.02).ħ 02:17:48:133 HSMinimumDelay after delay, elapsed is: 1.01 seconds.ħ 02:17:48:134 SQLProConnectingWindowController endSheetWithReturnCode: OKħ 02:17:48:134 HSDispatchGroup leave ħ 02:17:48:135 MySQLClient::disconnect settings reconnect = 0ħ 02:17:48:135 MySQLClient::disconnect begin mysql_closeħ 02:17:48:135 MySQLClient::disconnect finished mysql_closeħ 02:17:48:135 Failed to connect with error: Access denied for user (using password: YES). No other issues connecting to other remote MySQL'sħ 02:17:47:108 NSApp sendAction: collectionItemViewDoubleClickħ 02:17:47:108 collectionItemViewDoubleClickħ 02:17:47:108 connectToConnectionId: 4752F4AA-F175-473C-8E49-CA2683456854-2939-00006DABC37BEFF8ħ 02:17:47:108 connectToRecentConnectionById (not requesting password)ħ 02:17:47:108 doConnect: localhost (detected port: 0 specified port: 0)ħ 02:17:47:128 HSDispatchGroup enter ħ 02:17:47:128 doConnect calling getHost:andPort:forServer:userSpecifiedPort:ħ 02:17:47:128 doConnect self->internalDatabaseConnectionDetails createNewClientħ 02:17:47:128 doConnect calling databaseClient->connectħ 02:17:47:128 mysql:connect using default authenticationħ 02:17:47:128 MySQL going to connect with Authentication: Default.ħ 02:17:47:137 MySQL:connect with MySQLAuthenticationMethodDefault failed (Access denied for user (using password: YES). This is odd since when I change the Authentication Method to mysql_old_password in the UI it does actually successfully log in.Īnd, as a total aside, if you get a 1045 from MySQL you might alert the user to maybe changing the Authentication Method in the connection to the user.

Please add support for sqlite and Mongo Fast, performant and clean Themes could use some. I can connect OK if I change the Authentication Method to any of the other methods.Īlso I see in the log below from a default connect after it fails it says 'MySQL going to connect with Authentication: mysql_old_password.' but the failure still occurs and it cannot get in. So far so good, extremely lightweight and responsive, no hangups.

Rather than requiring full-row selection as many other tools use, SQLPro allows you to select one or more cells at a time. SQLPro supports many database types including MySQL (and MariaDB), Postgres/PostgreSQL, Redshift, Microsoft SQL Server (2005 and above), Oracle (8i and above), SQLite and SnowflakeDB. (Error #1045)' when using the Default authentication Method, it may be related to a MySQL 8.0.27 change but I am not certain. Work with results using single (or multi) cell selection, similar as a spreadsheet. When using SQLPro Studio Version 2021.98 (Build 110860.5) to Local MySQL 8.0.27 running on a M1 on Monterey and I get 'Access denied for user (using password: YES).

Sqlpro studio add user