Re: [CentOS] MySQL ERROR - UNKNOWN_MYSQL_USER

2011-07-21 Thread Markus Falb
On 20.7.2011 23:07, Keith Roberts wrote: > This is strange behavior because as soon as I start mysqld > with a clean error log, I get the following messages: > > 110720 21:38:47 [Note] /usr/libexec/mysqld: ready for > connections. > Version: '5.5.14-log' socket: '/var/lib/mysql/mysql.sock' > po

Re: [CentOS] MySQL ERROR - UNKNOWN_MYSQL_USER

2011-07-20 Thread Ljubomir Ljubojevic
Keith Roberts wrote: > On Wed, 20 Jul 2011, Ljubomir Ljubojevic wrote: > >> To: CentOS mailing list >> From: Ljubomir Ljubojevic >> Subject: Re: [CentOS] MySQL ERROR - UNKNOWN_MYSQL_USER >> >> Keith Roberts wrote: >>> This is strange behavior becau

Re: [CentOS] MySQL ERROR - UNKNOWN_MYSQL_USER

2011-07-20 Thread Keith Roberts
On Wed, 20 Jul 2011, Ljubomir Ljubojevic wrote: > To: CentOS mailing list > From: Ljubomir Ljubojevic > Subject: Re: [CentOS] MySQL ERROR - UNKNOWN_MYSQL_USER > > Keith Roberts wrote: >> This is strange behavior because as soon as I start mysqld >> with a clean err

Re: [CentOS] MySQL ERROR - UNKNOWN_MYSQL_USER

2011-07-20 Thread Ljubomir Ljubojevic
Keith Roberts wrote: > This is strange behavior because as soon as I start mysqld > with a clean error log, I get the following messages: > > 110720 21:38:47 [Note] /usr/libexec/mysqld: ready for > connections. > Version: '5.5.14-log' socket: '/var/lib/mysql/mysql.sock' > port: 2500 MySQL Comm

[CentOS] MySQL ERROR - UNKNOWN_MYSQL_USER

2011-07-20 Thread Keith Roberts
This is strange behavior because as soon as I start mysqld with a clean error log, I get the following messages: 110720 21:38:47 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.14-log' socket: '/var/lib/mysql/mysql.sock' port: 2500 MySQL Community Server (GPL) by Remi 110720

Re: [CentOS] MySQL error 28, can't write temp files - how to debug?

2009-11-05 Thread Arturas Skauronas
On Thu, Nov 5, 2009 at 11:44 PM, Rudi Ahlers wrote: > Hi all, > > An error occured!Can't execute statement: Error writing file > '/tmp/MYL4qeT5' (Errcode: 28) > SQL: , , select * from tips order by rand() limit 0, 1 , > check if you have enough free inodes with df -i

Re: [CentOS] MySQL error 28, can't write temp files - how to debug? [SOLVED]

2009-11-05 Thread Rudi Ahlers
On Fri, Nov 6, 2009 at 1:02 AM, Les Mikesell wrote: > Rudi Ahlers wrote: > >> What else could cause this kind of problem? > You only have 449MB free on /tmp. It could easily fill that up during the > query, and then delete the file before you run df again. Run it while the > query

Re: [CentOS] MySQL error 28, can't write temp files - how to debug? [SOLVED]

2009-11-05 Thread Les Mikesell
Rudi Ahlers wrote: > What else could cause this kind of problem? You only have 449MB free on /tmp. It could easily fill that up during the query, and then delete the file before you run df again. Run it while the query is executing, I bet you see /tmp filling up. >>> Thanx,

Re: [CentOS] MySQL error 28, can't write temp files - how to debug? [SOLVED]

2009-11-05 Thread Rudi Ahlers
On Fri, Nov 6, 2009 at 12:44 AM, Les Mikesell wrote: > Rudi Ahlers wrote: >> On Thu, Nov 5, 2009 at 11:47 PM, Alan Hodgson wrote: >>> On Thursday 05 November 2009, Rudi Ahlers wrote: According to google search, errorcode 28 means the HDD is full. But it isn't: r...@vps:[

Re: [CentOS] MySQL error 28, can't write temp files - how to debug? [SOLVED]

2009-11-05 Thread Les Mikesell
Rudi Ahlers wrote: > On Thu, Nov 5, 2009 at 11:47 PM, Alan Hodgson wrote: >> On Thursday 05 November 2009, Rudi Ahlers wrote: >>> According to google search, errorcode 28 means the HDD is full. But it >>> isn't: >>> >>> >>> r...@vps:[~]$ df -h >>> FilesystemSize Used Avail Use% Mount

Re: [CentOS] MySQL error 28, can't write temp files - how to debug? [SOLVED]

2009-11-05 Thread Rudi Ahlers
On Thu, Nov 5, 2009 at 11:47 PM, Alan Hodgson wrote: > On Thursday 05 November 2009, Rudi Ahlers wrote: >> According to google search, errorcode 28 means the HDD is full. But it >> isn't: >> >> >> r...@vps:[~]$ df -h >> Filesystem            Size  Used Avail Use% Mounted on >> /dev/sda1          

Re: [CentOS] MySQL error 28, can't write temp files - how to debug?

2009-11-05 Thread Alan Hodgson
On Thursday 05 November 2009, Rudi Ahlers wrote: > According to google search, errorcode 28 means the HDD is full. But it > isn't: > > > r...@vps:[~]$ df -h > FilesystemSize Used Avail Use% Mounted on > /dev/sda1 84G 18G 62G 23% / > none 640M 0

[CentOS] MySQL error 28, can't write temp files - how to debug?

2009-11-05 Thread Rudi Ahlers
Hi all, I hope someone can help with this one. On one of our VPS's we have a fairly large MySQL database, which gives me the following error when running some queries against it: An error occured!Can't execute statement: Error writing file '/tmp/MYL4qeT5' (Errcode: 28) SQL: , , select * from t

Re: [CentOS] mysql error

2009-08-31 Thread Pintér Tibor
> You're getting that because "-ucountry" isn't a valid flag for > mysqladmin. Did you mean to log into the MySQL server as user > "country"? If so put a space after the "-u" mind the difference between mysqladmin and mysql itself. t ___ CentOS mailing

Re: [CentOS] mysql error

2009-08-30 Thread Michael Wright
thax's for that drew i will try that Mike - Original Message - From: "Drew" To: "CentOS mailing list" Sent: Monday, August 31, 2009 3:27 PM Subject: Re: [CentOS] mysql error >> [r...@localhost bcm]# mysqladmin -ucountry > > You're getting t

Re: [CentOS] mysql error

2009-08-30 Thread Drew
> [r...@localhost bcm]# mysqladmin -ucountry You're getting that because "-ucountry" isn't a valid flag for mysqladmin. Did you mean to log into the MySQL server as user "country"? If so put a space after the "-u" -- Drew "Nothing in life is to be feared. It is only to be understood." --Marie

[CentOS] mysql error

2009-08-30 Thread Michael Wright
Hi List i'm trying to setup my sever but in my terimal all i seam get is this message but cant go on . could someone help us out many thx's Mike yum install mysql mysql-server Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * base: mirror.optus.net * updates: mirror.