List:General Discussion« Previous MessageNext Message »
From:Miguel Gonzalez Date:May 29 2013 6:57am
Subject:Re: SSH tunnels and non root accounts get "the server service or the configuration file could not be found"
View as plain text  
In my email I state quite clearly that tunnel is working with the root account so it's not
a matter of ports.

The error message shows that is trying to get some configuration from the user account
that is not working. Under root account I have found a file called .my.cnf with a
[client] entry as I said.

Regards,

Miguel




________________________________
 De: Tim Pownall <pownalltim@stripped>
Para: Miguel González <miguel_3_gonzalez@stripped> 
CC: mysql. <mysql@stripped> 
Enviado: Miércoles 29 de Mayo de 2013 3:29
Asunto: Re: SSH tunnels and non root accounts get "the server service or the
configuration file could not be found"
 

If you are tunneling port 3306 to your local machine, you need to have
mysql listen on the local port.

what ever port is being used on your local computer to operate the tunnel
to port 3306 remotely is the port you will use for mysql locally.

I hope this makes sense!


On Tue, May 28, 2013 at 7:05 PM, Miguel González <miguel_3_gonzalez@stripped
> wrote:

> Dear all,
>
>   Not sure if this the right mailing list address for asking this.
>
>   Server running Centos and MySQL.
>
>    Client is a windows xp machine.
>
>    I have setup a SSH tunnel with putty and run mysql administrator. It
> works fine with the root account.
>
>    With a non-root account I get
>
>    the server service or the configuration file could not be found. I can
> log on but I can't see the databases that I should be allowed to see.
>
>    Running a mysql -h 127.0.0.1 -u myuser -p mypassword from linux works
> fine
>
>     I have created a .my.cnf file in the home folder with 600 permissions
> in the linux box and filled it with:
>
>     [client]
>
>     pass='mypass'
>     user=myuser
>
>     Server configuration file is under /etc/my.cnf.
>
>     What am I doing wrong?
>
>     Regards,
>
>     Miguel
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>


-- 

Thanks,

Tim Pownall
Linux Systems Performance Specialist
610-621-9712
pownalltim@stripped
Thread
SSH tunnels and non root accounts get "the server service or theconfiguration file could not be found"Miguel Gonz├ílez29 May
  • Re: SSH tunnels and non root accounts get "the server service or theconfiguration file could not be found"Michael Dykman29 May
  • Re: SSH tunnels and non root accounts get "the server service or theconfiguration file could not be found"Tim Pownall29 May
    • Re: SSH tunnels and non root accounts get "the server service or the configuration file could not be found"Miguel Gonzalez29 May
      • Re: SSH tunnels and non root accounts get "the server service or theconfiguration file could not be found"Claudio Nanni29 May
        • Re: SSH tunnels and non root accounts get "the server service or the configuration file could not be found"Miguel Gonzalez29 May
          • Re: SSH tunnels and non root accounts get "the server service orthe configuration file could not be found"Claudio Nanni29 May