MySQL: problems starting it
Hello - this year's project is to learn about MySQL, Apache and PHP and to get them working together to produce web databases.
I've got a copy of a book by O'Reilly which suggests I should compile MySQL from source. This makes sense when trying to get it working with PHP because you then get all the mysql_config files in the right places for PHP to compile against.
My problem isn't compiling MySQL: that went well; it's getting it to start. A lot of people seem to have this problem. :???:
I have an error code 13, and Googling won't turn up an answer. It seems to be a problem with mysqld accessing directories. I've tried every combination of chown I can think of. I've copied the MySQL config file (called my.cnf) into /etc . My error message looks like this:
Any clues? I'm using MySQL ver. 4.1.x Version 5.x.x probably has more than I need. In fact I just need to get a working LAMP system to play around with. The annoying thing is that no matter how many combinations of permissions I try (as root) the database still can't start.
070305 11:43:41 mysqld started
/usr/local/mysql/libexec/mysqld: Can't read dir of '/root/tmp/' (Errcode: 13)
/usr/local/mysql/libexec/mysqld: Can't create/write to file '/root/tmp/ibGsqDEW' (Errcode: 13)
070305 11:43:41 InnoDB: Error: unable to create temporary file; errno: 13
070305 11:43:41 [ERROR] Can't init databases
070305 11:43:41 [ERROR] Aborting
070305 11:43:41 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
070305 11:43:41 mysqld ended
If I install MySQL as an rpm I can start it from Mandriva's front-end ... but then I can't easily get PHP working with it.