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 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

Written By
Trying to connect Excel to MySQL database
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.