From: javad bakhshi
Date: October 29 2012 10:26am
Subject: Unknown database error
List-Archive: http://lists.mysql.com/mysql/228513
Message-Id: <1351506369.39913.YahooMailNeo@web161501.mail.bf1.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="-167995730-1355956618-1351506369=:39913"

---167995730-1355956618-1351506369=:39913
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,=0A=0AI get an Unknown database error when I am trying to connect to mys=
ql using C API.=0A=0AI have created the database in mysql prompt as root:=
=0A=0ACREATE DATABASE Lr0;=0A=0AI am pretty sure that the problem is a owne=
rship issue, because when I do=0Als -l in my datadir I get:=0A=0A[javad64@u=
dbl64 data]$ ls -l=0Atotal 20532=0A-rw-rw---- 1 javad64 mysql=A0=A0 1048576=
0 Oct 26 14:10 ibdata1=0A-rw-rw---- 1 javad64 mysql=A0=A0=A0 5242880 Oct 26=
 14:10 ib_logfile0=0A-rw-rw---- 1 javad64 mysql=A0=A0=A0 5242880 Oct 19 15:=
28 ib_logfile1=0Adrwx------ 2 javad64 javad64=A0=A0=A0=A0 4096 Oct 26 14:35=
 Lr0=0Adrwx------ 2 javad64 mysql=A0=A0=A0=A0=A0=A0 4096 Oct 22 11:04 mysql=
=0Adrwx------ 2 javad64 mysql=A0=A0=A0=A0=A0=A0 4096 Oct 22 11:04 test=0A=
=0Awhich shows Lr0 doesn't have mysql ownership.=0A=0Amy question is:=0A1- =
Why does this happen? While I am creating the =0Adatabase in mysql prompt a=
s root.=0A=0A2- How can I fix it? I don't have root access in the system I =
am using=0Aso the chown solution is off table.=0A=0A=0A=A0=0ABest regards,=
=0AJavad Bakhshi,=0AComputer Science M.Sc=0ADepartment of IT, Uppsala Unive=
rsity=0A
---167995730-1355956618-1351506369=:39913--