Setting up MySQL is giving me a headache

Hi,

I've been at this for a week and I have to admidt that I'm lost on how to get MySQL up and running on my Mac (10.3.9). I downloaded and installed MySQL. I did find "mysql" and "mysql-5.0.45-osx10.3-powerpc" in my
/usr/local folder using the Terminal.

But in following all the info I gathered on the internet, I get nowhere. I get lots of "command not found" and things like that, and the prompt on Terminal did not change from my user name to MYSQL. How do I make sure that MySQL is installed correctly and how do I access it?

I've used MySQL through a GUI site, but I'm trying to learn how to run this myself but its driving my nuts...

Any help?

Thanks!
Jeremy

Thanks for the link...

I followed the directions up to step 5 ("To start the server, issue sudo echo first, then type sudo ./bin/mysqld_safe &")

This is what I get in return:

"A mysqld process already exists"

Does that mean in my previous experiments before I wrote to this forum, that I may have started up MySQL? This is where I've gotten stuck before.

Any suggestions?

Thanks alot for you help so far, Zotrium,

The result of "find /usr -name mysql" yielded:

/usr/local/mysql
/usr/local/mysql-5.0.45-osx10.3-powerpc/bin/mysql
find: /usr/local/mysql-5.0.45-osx10.3-powerpc/data: Permission denied
/usr/local/mysql-5.0.45-osx10.3-powerpc/share/mysql


so I used that first line for line 6, like so:

/usr/local/mysql-5.0.45-osx10.3-powerpc/bin/mysqltest

And this is what I got:
"mysqltest: Could not open connection 'default': 1045 Access denied for user 'jrmy'@'localhost' (using password: NO)
not ok"

That "1045 access denied" and "not ok" seem like bad things. I wonder if I screwed things up when I tried to set this up last weekend. Does it look like the alias isn't pointing to the right spot?

Jeremy

I feel like I'm getting closer to getting this working... BUT, this is what happened when I entered "/usr/local/mysql/bin/mysql -u root -p"

Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I enetered my computer admin password. I don't know of any mysql password that I may have set up. Is this telling me that I created a password for mysql and I am entering it incorrectly? If that is the case, how do I reset that?

Thanks,

Jeremy

Thanks for trying to help me...

If enter "/usr/local/mysql/bin/mysql -u root -p" (which I assume is the same as "mysql -u root -p" if I had the alais set up correctly) with or without the -p command I get this:

"ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)"

and I didn't enter a password. Then I tried it with every password I could think of and I still got that responce.

I'm trying to figure out all this Unix biz at the same time, so I feel extra dumb. Am I hopeless? I will keep plugging away at this, so if you have other ideas let me know.

Jeremy