MySQL Forums
Forum List  »  MySQL for Excel

Re: Connecting to MySQL via Excel problem
Posted by: Marc Wilding
Date: October 20, 2011 12:59AM


I did have a user set up on the 'mysql' machine. But I had host set to local. So I guess that means it had to be on that machine. I kind of figured Local may mean the same network, not the same PC. So I have modified the user to Any Host. It does have quite a secure password (if any ever are) and I have cut back the privilidges just to the main edit priviliges and create and show Views (as I guess I may need these) I understand all the priviliges side, so if they don't work I can modify as and when.

Anyway it worked !!!! Yeahhhh!

Thanks for all your help. Now that I know that I can speak to the database, I can proceed to write some VBA to populate the database (hopefully) original data is all in a huge Excel sheet.

This is just a brilliant result to start the day. Thanks again!!!

Edited 1 time(s). Last edit at 10/19/2011 11:03PM by Marc Wilding.

Options: ReplyQuote

Written By
October 19, 2011 01:40AM
Re: Connecting to MySQL via Excel problem
October 20, 2011 12:59AM
December 28, 2011 01:26PM

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.