[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Remote MySQL connect



What is the 'correct' way to configure MySQL for remote connections?

The db in question is running fine and can be accessed via phpmyadmin, 
amongst other things.

The default my.cnf has:

  bind-address - 127.0.0.1

When I comment this out (and restart the db), I can connect remotely - 
so user/password and privs are fine) but this leaves the db wide open.

Say I want to provide remote access to 192.168.0.1. Can this be done via 
MySQL's config or must it be done via the firewall and removing bind-
address?

The machine is not on a fixed IP.

-- 
Best,
Marc



Reply to: