Re: Connecting to MySQL via Excel problem
The ODBC driver your Excel is trying to use on on the same machine as Excel, which gather is NOT the machine with Mysql.
You'll need to go to the machine with MySQL, connect to mysql with commandline client using root, and GRANT privileges for
user@excel.machine or user@%.
Then in the ODBC driver on the Excel machine, the hostname is the ip address, or host name of the machine with mysql on it.
Good luck,
Barry.
Subject
Views
Written By
Posted
4668
October 19, 2011 01:40AM
2239
October 19, 2011 10:12AM
2223
October 19, 2011 10:27AM
Re: Connecting to MySQL via Excel problem
1872
October 19, 2011 12:59PM
2002
October 20, 2011 12:59AM
4106
October 20, 2011 11:54AM
2314
October 20, 2011 03:40PM
2038
October 22, 2011 12:26AM
2057
December 13, 2011 06:44PM
2039
December 28, 2011 01:26PM
2279
March 26, 2012 06:09AM
1984
March 26, 2012 06:11AM
1662
October 20, 2011 10:20AM
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.