MySQL Forums
Forum List  »  MySQL for Excel

Re: Connection error on remote database
Posted by: Javier Treviño
Date: August 28, 2017 04:06PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Connection error on remote database
68
August 28, 2017 04:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.