Want to use Microsoft Access via ODBC connector to MySQL
Posted:
Tue Mar 03, 2009 9:20 pmby fairch
What is the default username and password to access the MySQL database? I want to use the MySQL ODBC connector to use Microsoft Access to access the vicidialnow tables.
Posted:
Wed Mar 04, 2009 2:38 amby mflorell
I would recommend creating new logins for use with ODBC so that you can always see whether it is connected easily from the mtop screen.
All you need to do is run the GRANT commands that you see in the SCRATCH_INSTALL document with different username and password than it specifies in there.
Be warned that an ODBC connection gives you total control over the database, that means you have access to all of the data, but you can also lock up the system or delete everything as well if you don't know what you are doing.