Hi Bryan,

Kindly  create user "mysql" belonging to group "mysql" (instead of mysqld)

Regards,
Ritu
bryan wrote:
> The log says mysqld doesn't have permission to the directory ibdata1:
>
> 080426 13:53:48  mysqld started
> 080426 13:53:48  InnoDB: Operating system error number 13 in a file operation.
> InnoDB: The error means mysqld does not have the access rights to
> InnoDB: the directory.
> InnoDB: File name ./ibdata1
> InnoDB: File operation call: 'create'.
> InnoDB: Cannot continue operation.
> 080426 13:53:48  mysqld ended
>
>
> I created a mysqld group and added the mysqld user to that group as well as 
> ran the following:
>
> chown -R mysqld:mysqld /var/mysql
> chmod -R 770 /var/mysql
>
> I verified the mysqld user in the passwd file: 
>
> #cat /etc/passwd
> ....
> mysqld:x:103:101::/home/mysqld:/bin/sh
>
> I must be missing something here as mysqld should have permissions for the 
> directory.  I even tried giving everyone rights with chmod -R 777 /var/mysql 
> and it still gives the error.
>
> Any thoughts or reasons for this would be really helpful, thanks
> _______________________________________________
> databases-discuss mailing list
> databases-discuss at opensolaris.org
> http://mail.opensolaris.org/mailman/listinfo/databases-discuss
>   


Reply via email to