0
I recently set up the most basic possible version of MySQL 5.6 and created a test schema in which a test table was placed. The connection is just named "Local instance MySQL" with host "localhost", port "3306" and server "MySQL Community Server (GPL).
I let SQL decide the user login name 'root'. I'm now trying to connect this test database to Excel using the data import 'From Other Sources' option.
When I try to establish a connection to server name "MySQL Community Server (GPL)" I receive the error "[DBNETLIB][ConnectionOpen (Connect().]SQL Server does not exist or access denied."
I've looked around and it turns out this is a very common and very generic error. So far I've made sure that the server is running that I can access it via MySQL workbench, and I've checked firewall settings. I was wondering if anyone has had the same problem occur after having just set up a basic test database for MySQL. I'm hoping that the fact that the associated database is just a locally hosted one table database without any bells or whistles will make it easier to diagnose the problem.
"I've tried a few of the solutions without much luck." Since we're not mind readers, what exactly have you tried already, and what were the results. Have you confirmed the MySQL server services are actually running? Can you successfully connect to it using something like MySQL Workbench? – Ƭᴇcʜιᴇ007 – 2014-12-23T19:38:37.030
@'TECHIE007 Sorry, I've updated to be more clear. I suppose I haven't actually tried that much but many of the other solutions involve resetting I've never modified or handling components that this simple single table database doesn't have. – 114 – 2014-12-23T19:45:18.940
No problems. So you CAN access it via MySQL Workbench? – Ƭᴇcʜιᴇ007 – 2014-12-23T19:52:57.823
@'TECHIE007 Sorry, yes, all I have done so far with the database is create it in MySQL Workbench and run it locally. – 114 – 2014-12-23T19:55:28.670
So, let me get this straight, you're picking "From Other Sources" then "From SQL Server", and then typing "MySQL Community Server (GPL)" as the "Server Name" on that dialog screen, correct? – Ƭᴇcʜιᴇ007 – 2014-12-23T19:59:03.703
@'TECHIE007 Yes, have I made a mistake already in doing that? – 114 – 2014-12-23T20:02:50.373
Yup. :) I'll post an answer for you. – Ƭᴇcʜιᴇ007 – 2014-12-23T20:04:18.950