I was told to try this:
chown mysql.mysql -R /var/lib/mysql chmod 750 -R /var/lib/mysql
and it worked afterward. So that's the datadir permission problem.
How can find the user mysql password? The hosting company which I got the dedicated server package from set that up of course. Should I go to phpAdmin and reset that password so that I know what it is from now on?
Thanks again!
Jordan
Tom Crimmins wrote:
[snip] I'm using version 3.23.58. I tried to create a database foo using phpAdmin(logged in as root) and got: ERROR 1006: Can't create database 'foo'. (errno: 13) ... drwx--x--x 2 mysql root 4096 Sep 15 10:34 mysql [/snip]
perror 13
Error code 13: Permission denied
File permissions look ok at that level, and I would assume that mysql user can get to that directory. You could login to your linux box as root then 'su - mysql' and see if you can create a directory in the mysql datadir as the mysql user. This isn't a grant table issue because I believe that will give you an access denied error.
--- Tom Crimmins Interface Specialist Pottawattamie County, Iowa