MYSQL Server and MS access

[Michael Richardson]

Anthony,

Have you set up your user account to allow remote access?

Normally, you have to have several instances of your user 
account in mysql.user (the database mysql, table user). 
This allows host-level security.

by default, users have their host set to localhost, meaning 
that connections with that username are only allowed from 
the same machine.

What you would need to do is the following in the MySQL 
client:

GRANT <privleges> ON <table>.* TO ariga@'192.168.1.100' 
IDENTIFIED BY  'password']

replacing <privleges> with whatever access that user needs 
to <table> (or if you need access for every table and every 
db, *.*)

You *could* forget the ip address and make the user 
ariga@'%', but that opens you up to a whole slew of 
security issues.

More on account management:
http://www.mysql.com/documentation/mysql/bychapter/manual_M
ySQL_Database_Administration.html#User_Account_Management


When interacting with MySQL, I found that MySQL Control 
Center is pretty handy for performing user administration. 
Get it at:
http://www.mysql.com/downloads/mysqlcc.html

Hope that helps!

Michael Richardson
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Web Programmer, ePharmacotherapy Network
SUNY At Buffalo School of Pharmacy
309 Cooke Hall, North Campus (645-2828x266)