October 10, 2019 at 12:44 pm #36249
My company just updated to the latest SQLYog Enterprise, 13.1.5 (64-bit). When using the “Copy Database to a Different Host/Database” tool, there is an immediate stop with an error pop up, producing an Error 1049 “Unknown Database ‘mysql_native_password'” after clicking the “Copy” button. The source information and the Target connection information (both the connection drop-down menu and the database drop-down menu) all work as expected, the issue occurs only at the point when SQLYog attempts to spawn connections to perform the copy.
This appears to happen immediately, the “status” indicator never gets further than “Connecting to source server” before the error message appears.
Performing this as two steps, dumping the database to a SQL file via the “Backup/Export->Backup Database as a SQL Dump” and then going to the target system and using “Import->Execute SQL Script” appears to work correctly.
Source database is MySQL 5.7.15, destination database is MySQL 5.7.27. Perhaps when trying to add support for MySQL 8’s caching_sha2_password plugin, something was broken for mysql_native_password?
October 25, 2019 at 12:48 pm #36254
We also got this bug 🙁 !
It seems to start after last update (currently using version 13.1.5). We are using “Copy Table(s)…” on daily basis, so I can confirm it looks like a new bug, as no updates/changes has been on the mysql server (mysql v. 5.7.26)
We are 2 people having exactly the same issue.
When creating a new tab / connection to remote host, Copy Tables works fine, but after some (random?) time, it stops and show the “Unknown database ‘mysql_native_password'” each time trying to use th “Copy table(s)…”
Fix / workaround that sometimes works:
Open new tab with “+New connection using current setting” and do the exactly same copy table(s). It works for some time, but after some time, the error also appear on this tab/connection. Very annoying
Please fix / confirm this bug.
You must be logged in to reply to this topic.