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
