SELECT command denied to user 'user'@'localhost' for table 'table'

Hello, We are experience an estrange problem with mysql and we need help to debug this properly. We have a mysql server 5.0.67 on a ubuntu intrepid. Sometimes we have one unique query that cannot be executed and we get this error: SELECT command denied to user 'user'@'localhost' for table 'tabl

Re: mysqld not writing to err-log

Thanks Eric, it worked. = On Tue, Jun 16, 2009 at 11:55 PM, Eric Bergen wrote: > Madan, > > Try: > > [mysqld] > log_error=/var/log/mysqld.log > > > > On Tue, Jun 16, 2009 at 10:48 AM, Madan Thapa > wrote: > > Hi, > > > > mysqld is not writing to err-log and i do not see an

Re: mysqld not writing to err-log

Hi Rick, It was't a permission issue though. I did compare with another server, that had the same thing working. [r...@server1 mysql]# ls -lh /var/log/mysqld.log -rw-r--r-- 1 mysql root 60M Jun 16 18:40 /var/log/mysqld.log [r...@server1 mysql]# grep err-log /etc/my.cnf err-log=/var/log/mysqld.lo

RE: IDE - Toad

I was skeptical of a tool with a goofy name like "Toad" and the website looks like absolute 1992 ass, so it didn't give me a "solid and professional" impression. Then a DBA here at work mentioned it and I had to give him a chance to speak and convince me... Well, after a few minutes of a demonstra

Re: mysqld not writing to err-log

It is probably writing to syslog. Try "cat /var/log/messages | grep -i mysqld" to search for entries made by mysqld. Walter On Tue, Jun 16, 2009 at 11:48 AM, Madan Thapa wrote: > Hi, > > mysqld is not writing to err-log and i do not see any log generated upon > mysql service restart. > > > In my.

mysqld not writing to err-log

Hi, mysqld is not writing to err-log and i do not see any log generated upon mysql service restart. In my.cnf = [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/lib/mysql/mysql.pid open_files_limit=16384 r...@server[~]# ll /var/log/mysqld.log -rw-r--r-- 1 mysql root 0 Nov 24

myisamchk buffer_size warnings

Hi I have MySQL 5.0.64 compiled from source. When I run myisamchk on any table I get the following warnings: Warning: option 'key_buffer_size': unsigned value 18446744073709551615 adjusted to 4294963200 Warning: option 'read_buffer_size': unsigned value 18446744073709551615 adjusted to 4294967

Tools on http://www.severalnines.com do not work.

Hi List, I have been trying to use bencher and chkfrag from http://www.severalnines.com. But I continue to receive the following errors../chkfrag: error while loading shared libraries: /usr/local/mysql/lib/libndbclient.so.4: cannot restore segment prot after reloc: permission denie

Re: how to define the correct index

I would create two separate indices on fields B and C Olaf On 6/16/09 4:25 AM, "Yariv Omer" wrote: > Hi > > I have the following problem > > I have a table with 3 fields ('Field_A', 'Field_B', 'Field_C') > My query is: > > Select Field_A from table where Field_b=10 order by Field_c ASC; >

how to define the correct index

Hi I have the following problem I have a table with 3 fields ('Field_A', 'Field_B', 'Field_C') My query is: Select Field_A from table where Field_b=10 order by Field_c ASC; I have performance issues even when i have tried to define index for this table How should i define the corerct index (b