MySQL installation roadblocks

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
JasonTC
Forum Commoner
Posts: 92
Joined: Wed Nov 02, 2005 11:05 am
Location: Grand Rapids, MI

MySQL installation roadblocks

Post by JasonTC »

All right, I'm using the following reference page: http://dev.mysql.com/doc/refman/5.1/en/ ... ation.html

I'm using Mac OS 10.4.3.

I've gotten to through step 2 with no apparent problems, but when I get to the very first part of step 3, I get "permission denied" messages, so I went back to step 2 to make sure I did everything correctly. They had two possible commands there and the one I used was "shell> scripts/mysql_install_db --user=mysql". Seemed to go off without a hitch. What I don't understand is this:
It is important to make sure that the database directories and files are owned by the mysql login account so that the server has read and write access to them when you run it later. To ensure this, the --user option should be used as shown if you run mysql_install_db as root. Otherwise, you should execute the script while logged in as mysql, in which case you can omit the --user option from the command.
How do I make sure the database directories and files are owned by the mysql login account? Where are the database directories and files? I assume in my mysql folder, but even if I were to find them, I wouldn't know what to do.
Post Reply