Re: Connection error on remote database

[Javier Treviño]

Hi Steve,
The regular error message for failed credentials reads something like:

Authentication to host '<server-host>' for user '<your-user>' using method 'mysql_native_password' failed with message: Access denied for user '<your'user>@<server-host>' (using password: YES)

By "regular" I mean, creating a new connection within MySQL for Excel and connecting to a host via TCP/IP.

The error message you are getting leads me to think you need to connect through SSH. Have you created a SSH tunnel first? MySQL for Excel does not currently open a SSH tunnel on the fly as MySQL Workbench does.

If you need to connect using SSH you may try this guide:
https://blogs.oracle.com/mysql/guide-to-create-a-tunneled-ssh-connection-in-mysql-for-excel

Best regards.

====================================
Javier Treviño
MySQL on Windows Team