MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:afan Date:September 19 2006 1:19pm
Subject:access to mysql from outside
View as plain text  
what I have to do to be able to access to mysql on my web server from
other computer?
e.g., I want to access to web server using MySQL Administrator?
I have root access to web server.
As far as I know, mysql server is set up by edfault to be acessed only
through "localhost" and I have to add permission to specific IP to be able
to access it.

please, how?

on google I found this:

"If you CAN connect to the databse from the local host, but you get a
can't connect message from a remote host,
you meight want to check, if the "skip-networking" option in
/etc/mysql/my.conf is enabled.

the access from a remote host is disabled by default using:

bind-address = 127.0.0.1

If the the access from a remote host is needed you should comment this
line and also:

skip-networking"

first, I dont have /etc/mysql/my.conf file (mandrake 10.0) but have
/etc/my.cnf and there skip-networking is already commented. and there is
no line with bind-address?

Found this too:
"To restrict the access to port 3306 you may use in /etc/hosts.deny:

mysql: ALL

and in /etc/hosts.allow:

mysql: IP_ADDRESS_ALLOWED_1 IP_ADDRESS_ALLOWED_2"

is this enough?

thanks for any help.

-afan
Thread
access to mysql from outsideafan19 Sep
  • Re: access to mysql from outsideJoão Cândido de Souza Neto19 Sep