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' port:

[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 - 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 Community

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 centos@centos.org From: Ljubomir Ljubojevic off...@plnet.rs 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 error log

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 centos@centos.org From: Ljubomir Ljubojevic off...@plnet.rs Subject: Re: [CentOS] MySQL ERROR - UNKNOWN_MYSQL_USER Keith Roberts wrote: This is strange behavior because as soon as I start mysqld

[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

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 r...@softdux.com 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

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 ahodg...@simkin.ca wrote: On Thursday 05 November 2009, Rudi Ahlers r...@softdux.com 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

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 ahodg...@simkin.ca wrote: On Thursday 05 November 2009, Rudi Ahlers r...@softdux.com wrote: According to google search, errorcode 28 means the HDD is full. But it isn't: r...@vps:[~]$ df -h FilesystemSize Used

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 lesmikes...@gmail.com wrote: Rudi Ahlers wrote: On Thu, Nov 5, 2009 at 11:47 PM, Alan Hodgson ahodg...@simkin.ca wrote: On Thursday 05 November 2009, Rudi Ahlers r...@softdux.com wrote: According to google search, errorcode 28 means the HDD is

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, that seems to have

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 lesmikes...@gmail.com 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?

2009-11-05 Thread Arturas Skauronas
On Thu, Nov 5, 2009 at 11:44 PM, Rudi Ahlers r...@softdux.com 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

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 list

[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:

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 Curie

Re: [CentOS] mysql error

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