Please could someone please help me set the mysql permissions of one of my users so that he can connect to his database from his home computer without using phpmyadmin. I'm not sure how to set his permissions ...

Thanks in advance,

Hoot

Try:

GRANT ALL ON database.* to user@remote-host IDENTIFIED BY "password"

where:

database is the name of the database you want to give them access to. user is their mysql user-id. remote-host is the hostname or ip address of the remote host you will allow them to connect from. password is thier mysql password.

Frank

The problem is that he wants to connect from his computer and if he has got a dial up connection he will never have the same IP

hoot

Some part (prob. the first three octets) will be constant for his ISP. You can do: user@"144.155.166.%" for example.

Frank