Re: Simply accounting 2010 and Mysql ODBC 3.51

[Peter Brawley]

> I cannot seem to access any SA databases with Excel query or Mysql for Excel.

I know nothing about SA or ow it uses MySQL. It would need to use a MySQL account. SA authors probably preconfigured your MySQL account for specific access to SA data, but you will have to ask SA people about all that.

> When I use the user ID and password from simply I get a connection error, failed to connect with user and password.

If that's with SA software, ask them.

> Is there a generic UserID and password when Mysql is started by an application?

The convention for local general use is to create a mysql user named 'root', enabled for host=localhost, password of your choice, and give that user all privileges.