Trying to connect Excel to MySQL database

[Jeremy R]

I am attempting to connect Excel to my MySQL database. I have a few Wordpress sites on on a Linode VPS running LAMP.

I installed the Versoin 8.0.12 connector as per the Windows instructions.

In Excel (2016) I am going Data Tab > Get Data > from MySQL server.

For "Server" I have entered both mydomain.com and the public IP.

For "Database" I am entering the name of the database as I created it with the MySQL command "create database mydatabase;"

For "Username" and "Password" I am entering the username and password I created with the MySQL command "grant all privileges on mydatabase.* to 'myusername' identified by 'mypassword';"

I also tried the MySQL root user and password.


I get the error message we couldn't authenticate the credentials you provided.


This is my first time doing this, so I am sure I am doing something wrong.

Anybody have any ideas?