MySQL Forums
Forum List  »  MySQL for Excel

Connection to MySQL database in mySQL for Excel
Posted by: Steinar Karlsøen
Date: October 19, 2017 08:48AM

With MySQL installer for Window 10 I have installed MySQL Workbench (6.3.7) and MySQL for Excel (1.3.6) on my computer. I have then made a MySQL connection (Standard TCP/IP over SSH) in MySQL Workbench to access a MySQL database in a remote webhosting. I can successfully access my database trough this connection, but when I use the same connections in an Excel worksheet, I get an error message that says «Connection attempt failed. Unable to connect to any of the specified SQL hosts».
I don’t understand this failure because the connection is working.

Options: ReplyQuote


Subject
Views
Written By
Posted
Connection to MySQL database in mySQL for Excel
136
October 19, 2017 08:48AM


Sorry, only registered users may post in this forum.

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.