SEO

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

You ought to conect on localhost and create a new user with the specific ip
in the Host field.

<afan@afan.net> escreveu na mensagem
news:29350.216.248.119.34.1158671995.squirrel@www. afan.net...
> 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

afan@afan.net wrote:
> 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

You also need a port number (default is 3305) and that port must be open
in your firewall. Then you must have a userid and password defined in
MySQL (not the same as your system users!) which can connect from a
remote host - either by ip or "any" host.

To see if MySQL is listening, telnet or ssh into the server and try

telnet localhost 3305

If it connects, you 'll get garbage back but you know it's at least
listening on port 3305 (if you have another port number in your my.cnf,
use it instead of 3305).

If that works, go to a remote machine and try

telnet example.com 3305

(where example.com is your server and 3305 the same port as above). If
that works, then MySQL is listening for remote connections on the port.
You only need a userid/password which can connect. If the first
worked but the second didn't, chances are you have a firewall blocking
remote access.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================