Everyone to connect to MYSQL

[likelylad]

I have a MYSQL Database.
I also have an Microsoft Access file that uses an ODBC connection to the MYSQL database.
I would like everyone to click on the Access file and use it from a central location.
I set up a System DNS connection from Access to Mysql.
The user used in this connection has full admin rights.

The problem I have is that no one else can read the data on the tables. How can I allow everyone to see the data in the tables without setting up a security profile for each user, which will be approximately 50 people.

[Pipe]

 

[sleipnir214]

You don't have to give each user his own password and userid.

Set up a single MySQL userid and password which can connect from any machine in your network. Give that user the permissions to manipulate the data in all tables in your MySQL database, but do not give that user admin-level access. (Give SELECT, INSERT, DELETE, and UPDATE, but no other permissions).

Set up a System DSN using the MyODBC driver on each workstation. The DSN on each workstation should have the same DSN name. In the configuration of the DSN, enter the same userid, password and DSN the same on all workstations. Make sure you take a look at the Access/MySQL gotchas here:

http://www.mysql.com/doc/M/y/MyODBC_clients.html

. Then link your Access tables to MySQL via the named DSN.

This is NOT the preferred way to do this. Should a user abuse the privileges provided by that single userid, you will have to cut off everyone until you have created a new userid and password and reconfigured all ODBC DSNs on all machines. It is, however, expedient. Just backup often.

______________________________________________________________________
Never forget that we are
made of the stuff of stars

 

[likelylad]

Thanks for the information.
It's not exactly what I wanted as I still have to go round 50 PC's to install the MyODBC drivers and link all the tables, however what you said has made me think of something else, I will let you know if it works

[Pipe]

 

[KarveR]

It is possible to set the system name to % for anything and then use the ip as (for example) 192.168.%.% for any machine on the 192.168 subnet. This works for me on a system where this account has only read privileges. ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.