mysql and hpux installation issues

[BenIsCool]

I checked the data directory and information was created and owned by root/sys.

Just out of curiosity, i rm -rf'ed the data directory. I then su'ed to mysql and ran the configure script again. This time it completed 'succesfully'. There is now information in the data folder and it is all owned by mysql. However, as mysql, the configure script failed to start mysqld (where root was able to).

I don't know if the data created is valid and will work: I still have testing to do. But in the mean time, should user mysql be able to run mysqld?

Thanks

[V. Nyga]

yes - I'm running it this way.

V.

[Steven E. Protter]

Shalom,

You can not run mysql database owned by root.

I believe mysqld uses shares memory and having that memory owned by root makes it inaccessible by other users.

This problem seems totally connected to permissions and ownership, which needs to be revised.

These articles focus on Linux, however mysql works almost exactly the same way after depot install on hpux. Don't go back and try a tar based install.
http://dev.mysql.com/tech-resources/articles/mysql_intro.html

http://forum.mamboserver.com/showthread.php?t=67525

http://www.debianhelp.co.uk/mysql.htm

Don't confuse the root mysql password with the root user. They have nothing to do with one and other.

Creating tables with MYSQL user root is not a problem at all, though it is more powerful and may present a security hazard.

Get file permissions right before you begin.

SEP

[BenIsCool]

Thank you for the links. It is useful to have such information. However, they do not seem to address the problem I am facing in this post. I have read a great deal of the information you posted above already, before coming here to ask for help.

The problem is, that after following the documents referenced, the process does not work. I understand how to install it. How to run the setup. How the start the daemon. The problem is that it does not work.

Straight from the mysql manual, for example, I run the mysql_install_db script and it does not work. Through this posting I have found that running configure might provide an alternative.

Staright from the mysql manual I run mysqld_safe but it does not work.
I realize that it is a permissions issue and that is why I am posting here for help. What am I missing? I have followed the manuals. I have searched forums. I have even chmod -R'ed the whole directory to 777. Still no luck.

Please, any advice.
Thank you.