D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] MySQL problems...

 



On Mon, 19 May 2008 09:22:05 +0100, "Robin Cornelius"
<robin.cornelius@xxxxxxxxx> wrote:
> On Sun, May 18, 2008 at 4:13 PM, Grant <gsewell@xxxxxxxxxxxx> wrote:
>>
>> Hi all,
>>
>> It's that time again - that time where I admit to being a numpty about
>> MySQL.  I'm happy with it when it works, but when it's not working I
>> haven't a clue where to begin troubleshooting.
>>
>> So... a short while ago my server ran out of disk space.  This has now
> been
>> rectified, but MySQL stopped behaving itself around the same time.  I
> don't
>> know if the two are connected, but MySQL is still not behaving itself.
>>
>> Where do I start?
>>
> 
> Log files,
> 
> /var/log/syslog or /var/log/mysql.log or mysql.err etc
> 
> Warnings, errors or anything down right suspicious!
> 
> Robin

Turns out I was looking in the wrong place.  There was nothing wrong with
the MySQL server... for some reason the privileges for my main database
user account was screwed up.  All is happy now.

Cheers anyway Robin.

Grant. :)


-- 
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html