Question

5

mysqld gives errcode:13 because it can't create test files

rated 0 times [ 5] [ 0] / answers: 1 / hits: 40067 / 2 Years ago, wed, june 15, 2022, 6:50:02

New installation of 11.04.
Then I followed all instructions here:
http://www.howtoforge.com/installing-apache2-with-php5-and-mysql-support-on-ubuntu-11.04-lamp

Now when I run mysqld I get this error:

makara@rahu:~$ mysqld

111103 13:39:37 [Warning] Can't create test file /var/lib/mysql/rahu.lower-test

111103 13:39:37 [Warning] Can't create test file /var/lib/mysql/rahu.lower-test

mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13)

111103 13:39:37 [ERROR] Aborting

111103 13:39:37 [Note] mysqld: Shutdown complete

Someone on IRC said it might be a package issue??

Thanks
beet

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

landarre

Add To Favorites

Follow

Total Points: 254

Total Questions: 96

Total Answers: 109

Location: Burundi

Member since Sun, Apr 16, 2023

1 Year ago

answered 2 Years ago aveerakfas · Accepted Answer

mysqld should be ran as the mysql user. You should not run the daemon manually. Better start it as service like this:

sudo service mysql start

The error message points out that the mysql service cannot access certain files which it should not be allowed to acces in your user environment. So this behaviour should be correct. However, you should check whether the directories exist and who owns them and who has access to them (use ls -la for this purpose):

ls -la  /var/lib/

ls -la  /var/lib/mysql