configuring mysql to accept connections

[drewmanji]

do i need to configure the mySQL database to accept connections from certain ips? right now the connections work fine from one machine but not another. each machine has the same include files that specify the ip and port for the mySQL db.

thanks in advance

drew

[jariizumi]

With root priv's, you have to give yourself permissions to that host:

GRANT ALL PRIVILEGES ON . TO [e-mail]

would give the user 'root' connecting from server 'box1.myhost.com' all the privileges on every table on every database. Of course, you should hypothetically change things so that you only give out the needed permissions to each computer... but hey, I wouldn't mind restrictionless access to any db server 😉

[Anon]

thanks!