Ok i have looked through the MySQL Manual and nope, cannot find anything

How do you setup mysql, so machines on your network can access it????

i.e, mysql runs on 192.168.0.1

and then applications running on machines:

192.168.0.2
192.168.0.3
192.168.0.4

can all access the database

whats the syntax u have to type to get it to work???

Thanx

//edit, its a redhat 7.3 server by the way

thanx

For every pc that you want to connect to the database login into the database as administrator and give the command:

grant all privileges on database.* to user@ip identified by 'password';

all privileges = you give full acces to the specific database.
database.* = the database you want it to connect eg. mail.* (the .* must be after the name of the database)

user@ip = username you want and ip of the pc that will connect to the database.

'password' = the desired password.

Forgot to say that you can use hostnames insteed of ip's if you want and also check out on www.mysql.com about privileges in case you don't want to give full acces.

hmmmm im having no luck

im trying to get vb6 to connect to it so i can use mysql tables in the apps im gunna write which will run on the network

when i do test connection i get this :

Test connection failed because of an error in intialising provider. Client unable to establish connection

For the server field i have tried typing in

srv1 (server name)
192.168.0.1 (server internal ip)

both ping to the server fine

in the user table for mysql i give complete access to the user im using, from any host

and no luck

It seems as if its not even finding the server

even tho, the details i have typed are correct.

Anyone know what it could be?

you probably did this, but after changing premission and adding user you should flush-privileges or reload mysql.