MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:João Cândido de Souza Neto Date:September 19 2006 1:23pm
Subject:Re: access to mysql from outside
View as plain text  
You ought to conect on localhost and create a new user with the specific ip 
in the Host field.

<afan@stripped> escreveu na mensagem 
news:29350.216.248.119.34.1158671995.squirrel@ style="color:#666">stripped...
> 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