Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Error 1049, "Unknown Database mysql_native_password" on Copy Database

forums forums SQLyog SQLyog: Bugs / Feature Requests Error 1049, "Unknown Database mysql_native_password" on Copy Database

This topic contains 1 reply, has 2 voices, and was last updated by  dna 2 weeks, 4 days ago.

  • Author
  • #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?

  • #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.

    Our case:
    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.