MySQLD aborts
Hi: I have version 4.0.20 on slack 10.0. Mysqld fails on startup. From mysqld is the following: 50821 11:10:44 mysqld started 050821 11:10:44 Warning: Can't create test file /var/lib/mysql/linus.lower-test ^G/usr/libexec/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13) 050821 11:10:44 Aborting 050821 11:10:44 /usr/libexec/mysqld: Shutdown Complete 050821 11:10:44 mysqld ended - I'm not much of a linux system guru, and I am guessing from the messages above that I have a problem with permissions. Can anyone point me to the solution? Many Thanks tim -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQLD aborts
Tim Johnson wrote: Hi: I have version 4.0.20 on slack 10.0. Mysqld fails on startup. From mysqld is the following: 50821 11:10:44 mysqld started 050821 11:10:44 Warning: Can't create test file /var/lib/mysql/linus.lower-test ^G/usr/libexec/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13) 050821 11:10:44 Aborting 050821 11:10:44 /usr/libexec/mysqld: Shutdown Complete 050821 11:10:44 mysqld ended - I'm not much of a linux system guru, and I am guessing from the messages above that I have a problem with permissions. Can anyone point me to the solution? Many Thanks tim You can get more info about an error message with perror: ~: perror 13 OS error code 13: Permission denied As you guessed, a permissions error. Apparently, the user running mysqld (usually user mysql) does not have access rights to /var/lib/mysql/. Most likely, user mysql is not set as the owner of /var/lib/mysql/, in which case you need to chown -R mysql:mysql /var/lib/mysql/ as root. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQLD aborts
... You can get more info about an error message with perror: ~: perror 13 OS error code 13: Permission denied As you guessed, a permissions error. Apparently, the user running mysqld (usually user mysql) does not have access rights to /var/lib/mysql/. Most likely, user mysql is not set as the owner of /var/lib/mysql/, in which case you need to chown -R mysql:mysql /var/lib/mysql/ as root. Bingo! That worked and I learned *two* things. :-) thanks tim -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]