Re: Connection error on remote database
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
Subject
Views
Written By
Posted
1359
August 26, 2017 03:58PM
720
August 26, 2017 03:59PM
Re: Connection error on remote database
1951
August 28, 2017 04:06PM
871
August 29, 2017 12:53PM
958
August 30, 2017 12:25PM
722
August 31, 2017 01:47PM
873
September 04, 2017 04:54AM
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.