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.na...@gmail.com> Para: Miguel Gonzalez <miguel_3_gonza...@yahoo.es> CC: Tim Pownall <pownall...@gmail.com>; mysql. <mysql@lists.mysql.com> 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_gonza...@yahoo.es> 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 <pownall...@gmail.com> >Para: Miguel González <miguel_3_gonza...@yahoo.es> >CC: mysql. <mysql@lists.mysql.com> >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_gonza...@yahoo.es >> 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 >pownall...@gmail.com -- Claudio
