List:General Discussion« Previous MessageNext Message »
From:Miguel Gonzalez Date:May 29 2013 7:37am
Subject:Re: SSH tunnels and non root accounts get "the server service or the configuration file could not be found"
View as plain text  
I'm confused. Where should I issue those commands?

I have connected in the linux box with that user and when I start the mysql client I
issue those commands and I get the same result.

Do I have to issue those commands (where?) in the mysql administrator? When I log in
through the mysql administrator I get the username correctly.

Regards and thanks for the promptly answer


Miguel



________________________________
 De: Claudio Nanni <claudio.nanni@stripped>
Para: Miguel Gonzalez <miguel_3_gonzalez@stripped> 
CC: Tim Pownall <pownalltim@stripped>; mysql. <mysql@stripped> 
Enviado: Miércoles 29 de Mayo de 2013 9:24
Asunto: Re: SSH tunnels and non root accounts get "the server service or the
configuration file could not be found"
 


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