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
