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
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
