localhost

RichardF

Verified User
Joined
Jul 5, 2005
Messages
59
Location
Netherlands
The mysql databases generated by users can only be connect to from the localhost.

How can I change that, that also from an other server one can connect to a database? Just in one specific case. Not that I want all new databases are open to the world :)

Kind regards,

Richard
 

roelp

Verified User
Joined
Feb 4, 2005
Messages
55
make sure your mysqld is started without the --skip-networking.
Then change the host for the users you want to allow to for example 'user'@'%'

you can find everything on the mysql website if you're willing to search for 2 minutes
 
Top