Re: SSH tunnels and non root accounts get the server service or the configuration file could not be found
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
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
Re: SSH tunnels and non root accounts get the server service or the configuration file could not be found
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
Re: SSH tunnels and non root accounts get the server service or the configuration file could not be found
Hi Miguel, I'm confused. Where should I issue those commands? Yes from the MySQL Administrator. From what you say it seems that you end up being authenticated as the ''@'localhost' user. Connect again with the MySQL Administrator and the non-root account and issue: mysql SHOW GRANTS; What user do you see after: 'Grants for ' ? Cheers -- Claudio
SSH tunnels and non root accounts get the server service or the configuration file could not be found
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
Re: SSH tunnels and non root accounts get the server service or the configuration file could not be found
Your windows-based client never sees the files on the linux server. All the tunnel provides is the ability to treat port 3306 of your linux box as-if it was a port local to your windows system. It does not, can not make file access transparent across those systems. On Tue, May 28, 2013 at 8: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 -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
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