General
cancel
Showing results for 
Search instead for 
Did you mean: 

mysql hpux install permissions issue

BenIsCool
Frequent Advisor

mysql hpux install permissions issue

Hello,

hpux 11.11
I have installed mysql 5.0.41.
It installed successfully.
I am trying to run mysql_install_db and it fails with error: 1005 can't create table 'db' (errno: 13)
The research I have done seems to indicate this is a permissions issue. I have created the user and group mysql and have made the user mysql a member of sys and bin and have even 777'ed /usr/local/mysql and /tmp but still no luck.
Please advise.
Thanks
2 REPLIES
Steven E. Protter
Exalted Contributor

Re: mysql hpux install permissions issue

Shalom,

Make sure the permissions on the table and folders the tables sit in have read write access to at least the owner.

You should, never, ever create tables as the root user. You must use the mysql user to create, edit or change tables.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
BenIsCool
Frequent Advisor

Re: mysql hpux install permissions issue

Hello,

Thank you for the reply. That is my issue. I cannot create tables as I cannot even run the install_db script or start the mysqld.

The user mysql cannot start mysqld or run mysql_install_db to create the grant tables etc.

In the past I have tried this as user root and it worked so I believe it is a permissions issue.

Any thoughts?

Thanks