I'd just like to apologize in advance for my inexperience with UNIX/MySQL. I'm a Graphic Designer that would like to add some dynamic capabilities to what I do on the web, so I'm not terribly versed in the subject matter.

Anyway, I run Mac OS 10.3 and downloaded and opened the .pkg installer. I believe it's MySQL v. 4.0.20

My problems come when I try to go through terminal and, well, actually use MySQL.

One of the books I have says that I should be able to log in with the following:

mysql -u root

but I get:

ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

So I tried to locate mysql.sock socket with: find/ -name "mysql.sock" and got:

find: /.Trashes: Permission denied
find: /Library/Logs/Console/mysqlGREG: Permission denied
find: /Library/MySQL/var: Permission denied
find: /private/etc/cups/certs: Permission denied
find: /private/var/backups: Permission denied
find: /private/var/cron: Permission denied
find: /private/var/db/dhcpclient: Permission denied
find: /private/var/db/netinfo/local.nidb: Permission denied
find: /private/var/db/openldap/openldap-data: Permission denied
find: /private/var/db/openldap/openldap-slurp: Permission denied
find: /private/var/db/shadow: Permission denied
find: /private/var/root/Library: Permission denied
find: /private/var/run/sudo: Permission denied
find: /private/var/spool/clientmqueue: Permission denied
find: /private/var/spool/cups: Permission denied
find: /private/var/spool/lpd: Permission denied
find: /private/var/spool/postfix/active: Permission denied
find: /private/var/spool/postfix/bounce: Permission denied
find: /private/var/spool/postfix/corrupt: Permission denied
find: /private/var/spool/postfix/defer: Permission denied
find: /private/var/spool/postfix/deferred: Permission denied
find: /private/var/spool/postfix/flush: Permission denied
find: /private/var/spool/postfix/hold: Permission denied
find: /private/var/spool/postfix/incoming: Permission denied
find: /private/var/spool/postfix/maildrop: Permission denied
find: /private/var/spool/postfix/private: Permission denied
find: /private/var/spool/postfix/public: Permission denied
find: /private/var/spool/printing/EC65EFB4-604F-11D6-8724-00039357AD88.Q: Permission denied
find: /private/var/vm/app_profile: Permission denied


Someone suggested that I check out my error log and this is what it says:

040820 18:24:54 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
040820 18:25:00 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
040820 18:25:03 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
040820 18:25:06 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
040820 18:25:11 InnoDB: Started
040820 18:25:11 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
040820 18:25:11 Aborting

040820 18:25:11 InnoDB: Starting shutdown...
040820 18:25:13 InnoDB: Shutdown completed
040820 18:25:13 /Library/MySQL/libexec/mysqld: Shutdown Complete

040820 18:25:13 mysqld ended

They suggested the problem lies in

> 040820 18:25:11 Fatal error: Can't open privilege tables:
> Table 'mysql.host' doesn't exist

And that maybe I need to run the mysql_install_db script. Problem is, whenever I do that (per the online MySQL manual), I get:

[localhost:~] galthoff% mv mysql-data-directory/mysql mysql-data-directory/mysql-old
mv: rename mysql-data-directory/mysql to mysql-data-directory/mysql-old: No such file or directory

So anyway, to make a long story short, I've spent the last three weeks perusing message boards, pouring over the online manual, trying different things to figure this out, and quite honestly, I'm no closer to getting this running. More confused than when I started.

So if one of you has it in your heart out there to help me through this a bit, I'd greatly appreciate it. I'm sure there are things I'm leaving out, but right now, I'm too confused to figure it all out.

Many thanks.