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 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: MySQL dying?
Mysql is used by just about every web host and is one of the most common database servers around the world. I do not have any intent to stop using mysql unless they start charging for it which I do not think will happen. Thanks, Tim Pownall Sr. Linux Systems Monitoring Hostgator.com LLC On Tue, Dec 4, 2012 at 11:45 AM, Anthony Pace wrote: > I have heard that due to Oracle taking over, the OS community is shifting > to other type of DB's . > > Any thoughts? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql > > -- Thanks, Tim Pownall GNU/Linux Systems Monitoring 610-621-9712 pownall...@gmail.com
Re: How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;
select * from table where column=value means it will return only rows that match. as long as you have proper indexing there should not be any issues. On Sun, Sep 23, 2012 at 1:23 PM, Luis Daniel Lucio Quiroz < luis.daniel.lu...@gmail.com> wrote: > Helo, > > Just wondering if is possible to block SELECT queries that doesnt have > a WHERE statement within. > > > LD > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql > > -- Thanks, Tim Pownall GNU/Linux Systems Monitoring 610-621-9712 pownall...@gmail.com