MySQL. i installed a a package install of the latest MySQL -of the unix [Mac OS X] variety. here's what i did (after the package installed installed itself): - i did this logged in as an administrator (me) AND below wherever it says mysql (as username) i entered my own username... so on the chown command i named myself as owner. this all works fine (afaik). now my question is... what is the difference between "owner", as described below, and "root"? and how do i now, if i should, enter a "root" password? (also i'm still not sure what a root password is for :( ****** After installing, do this (you must have administrator rights): 1. Create a new user in the "Users" System Prefs pane: 2. Name: "MySQL User"; 3. Short Name: "mysql"; 4.Password: whatever you want. Open a terminal window and type in the following commands (without the double quotes): 1. type "sudo mysql_install_db", enter administrator password when asked; 2. type "sudo chown -R mysql /usr/local/var/"; 3. type "sudo safe_mysqld --user=mysql &"; 4. Use it with "mysql test". ****** Thanks in Advance. Ted Rogers --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
