Topic: mysql-access from windows-stations

[Karl W. Mueller]

We have two php-solutions on our e-smith box, each with a mysql-database on the server. Now we want to access the database for adresses and other informations from some windows-boxes. There are no user-rights for the /var/lib/mysql directory and its subdirectories. (owner = mysql, group = mysql, rights = 700

Maybe at first sight,you could add all the users, who should access the database to the group mysql and change the rights to give them read-access.

I would appreciate a better and secure solution.

Thanx in advance

Karl W. Mueller

[Alex Wallace]

What I would do if I was you is:

Create usernames in mysql (they are different from the ones in your e-smith box)
check www.mysql.com for info on that, it is very easy, but you have to make sure that the users have access from the IPs or domain they use in mysql...

Once you have the users you want to enable you can download the ODBC driver for mysql from www.mysql.com and use whatever app you want to connect to mysql on your e-smith server...

I have a couple of VB apps that do exactly that...

Hope that helps...

[Jeff Martin]

See Darrell's How To "myODBC - how to set up Windows to access mySQL db"  found at

http://www.myezserver.com/docs/mitel/index.html

It might help

[Rangi Biddle]

another solution is to get phpMySQLadmin from phpwizard.net.  It's a web based interface that lets you create and setup databases and tables.  For security it has a login interface where you set which user is to run the mysql commands but you can have it use a specific user for a particular database or table.  So in other words if you are wanting to limit what a user is allowed to view then it's a reasonable solution.

I am sure that there are posts or even RPM's available for phpMySQLadmin from this website.

Anyway I hope this helps.