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" wrote:
Hi,
I get an Unknown database error when I am trying to connect to mysql using
C API.
I have created the database in mysql prom
Hi,
I get an Unknown database error when I am trying to connect to mysql using C
API.
I have created the database in mysql prompt as root:
CREATE DATABASE Lr0;
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
18 Apr 2002 12:41:31 -0500
> To: MySQL <[EMAIL PROTECTED]>
> Subject: BSD: Random unknown database error
>
> All:
>
> Recently I've run into a problem where I intermittently receive an "Unknown
> database" error while attempting to communicate with
All:
Recently I've run into a problem where I intermittently receive an "Unknown
database" error while attempting to communicate with a local MySQL server.
I read through the mail list archives and discovered that others reported
similar problems under BSD, but I didn
I know you people are busy but I have seen this question a few times on the lists to
no avail. *see below*
It has been figured out by my admin.
It appears that one or more entries in the ACL tables is corrupt, when this happens so
its preventing logins.
So you have to replace the ACL with a f
Jason Guritz wrote:
>
> mysql> show databases;
> +---+
> | Database |
> +---+
> | directory |
> | mysql |
> | phpBB |
> | testdb |
> | trial |
> +---+
> 5 rows in set (0.00 sec)
>
> mysql> use testdb;
> ERROR 1049: Unknown database 'testdb'
>
> Keep
mysql> show databases;
+---+
| Database |
+---+
| directory |
| mysql |
| phpBB |
| testdb |
| trial |
+---+
5 rows in set (0.00 sec)
mysql> use testdb;
ERROR 1049: Unknown database 'testdb'
Keeps happening to me too.
It was working the day before :
