MySQL Forums
Forum List  »  MySQL for Excel

Trying to connect Excel to MySQL database
Posted by: Jeremy R
Date: October 02, 2018 10:46PM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
Trying to connect Excel to MySQL database
1084
October 02, 2018 10:46PM


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.