List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:May 29 2013 7:24am
Subject:Re: SSH tunnels and non root accounts get "the server service or the
configuration file could not be found"
View as plain text  
Miguel,

Probably your non-root user is connecting as the anonymous account.

Try this:

Connect as your (problematic) non-root account and do this:

mysql> SELECT USER();
mysql> SELECT CURRENT_USER();

What do you see?

If it's as I imagine you should see different values and so just delete the
anonymous user from mysql.user table.

Best Regards

Claudio


2013/5/29 Miguel Gonzalez <miguel_3_gonzalez@stripped>

> 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
>



-- 
Claudio

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