[KLUG Members] MySQL problem: File permissions

[members@kalamazoolinux.org]

Hi,
Thx. Fixed it.  Had set the innodb data dir to /home/sanj/port. Sudoed as
mysql (user name for mysqld, got info by
ps -ax )

checked accessibility.  Had given access to port sub-directory but not
sanj. mysql usr could not navigate beyond home.

As root created a directory in / called ibdata and changed owner of  ibdata
directory to mysql

That fixed it.

Hope this might be useful for others.


Error message was  Innodb: Operating System error 13 in file operation
InnoDB : This means that mysqld does not have access to the directory
FileName :

Fixed the problem.

Thx,
Sanjay