List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:October 29 2012 2:25pm
Subject:Re: Unknown database error
View as plain text  
The contents of datadir is typically owned by the mysql user and group.
Certain attributes on the datadir itself (ls -ld $datadir) can affect the
permissions of newly-created files and directories.  You need to talk to
you sysadmin,  with a eye towards doing something like

    chown -R mysql:mysql $datadir

I honestly cannot think of a scenario where the datadir should be
permissioned any other way.

On 2012-10-29 6:26 AM, "javad bakhshi" <javadbakhshi@stripped> wrote:


I get an Unknown database error when I am trying to connect to mysql using

I have created the database in mysql prompt as root:


I am pretty sure that the problem is a ownership issue, because when I do
ls -l in my datadir I get:

[javad64@udbl64 data]$ ls -l
total 20532
-rw-rw---- 1 javad64 mysql   10485760 Oct 26 14:10 ibdata1
-rw-rw---- 1 javad64 mysql    5242880 Oct 26 14:10 ib_logfile0
-rw-rw---- 1 javad64 mysql    5242880 Oct 19 15:28 ib_logfile1
drwx------ 2 javad64 javad64     4096 Oct 26 14:35 Lr0
drwx------ 2 javad64 mysql       4096 Oct 22 11:04 mysql
drwx------ 2 javad64 mysql       4096 Oct 22 11:04 test

which shows Lr0 doesn't have mysql ownership.

my question is:
1- Why does this happen? While I am creating the
database in mysql prompt as root.

2- How can I fix it? I don't have root access in the system I am using
so the chown solution is off table.

Best regards,
Javad Bakhshi,
Computer Science M.Sc
Department of IT, Uppsala University

Unknown database errorjavad bakhshi29 Oct
  • Re: Unknown database errorMichael Dykman29 Oct