MySQL Forums
Forum List  »  MySQL for Excel

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

Thanks,

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


Subject
Views
Written By
Posted
4489
October 19, 2011 01:40AM
Re: Connecting to MySQL via Excel problem
1904
October 20, 2011 12:59AM
1955
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.