[bbmagic]

I have installed Marc Liyanage's MySQL package and I had it running for a while. It seems like I don't understand some of the concepts of administering the database. I have problems trying to shut down the terminal after making a table. It says that sh and mysqld are still running and thats true looking at top. If I try mysqladmin shutdown I can't because it says I don't have permission. I imagine this is because he has it running under user mysql in his directions. Why does he do that? I'm not that worried about security this is just a development (play) machine and not running openly on the web. I think I need a step by step tutorial working through installation and doing simple administration things. After installing his mysql package alot of the instructions I see on the net, even at the mysql site, don't work because of the convaluted installation. Is it normal to have it running under a diffent user like this? Any help would be appreciated.

[larkost]

It is normal to have mysql running as user 'mysql'. What you are running into is that you have not given yourself any permissions in the database itself. Read up on the security model and things should be much clearer.

Another note: due to a bug/lack of implementation of part of pthreads, MySQL cannot be shut down normally in MacOS X. as you don't normally shut down databases, this is not really a big issue. You can always 'sudo kill' the processes...