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.