I haven't tried to restore the database files yet from my backup, but what I ended up doing to solve all these permissions issues and everything wss this (this did not restore any of my database files, everything was fresh):
I Downloaded mysql 4.1 again; I opened the package and reinstalled it. This created a different version directory and reset the aliases to the program on my system.
In terminal, I created two shortcuts:
Then I followed the MacZealots Instructions for setting up mysql, typed in terminal:
sudo chown -R mysql data/
sudo ./bin/mysqld_safe &
(I don't know what that does exactly, but I think it has to do with setting the correct permissions for the /data/ directory that mysql accesses when it is running on the system, but I did it anyway)
Then I set the password for my
root@localhost account, hoping it would clear up the past problems I had been having:
/usr/local/mysql/bin/mysqladmin -u root password yourpasswordhere
Then I loaded up mysql:
mysql -u root -p
I entered my new password -- it worked! -- then at the
mysql> prompt I created a new database:
CREATE DATABASE wordpress;
And I was ready to go ... had to run the install.php file again but that was it. Everything is back ... can work on my themes again.
Sigh. Thanks for your help.