FreeBSD 4.9 and MySQL

What command do I use to install the MySQL database?

I tried a bunch of different ones and got it to kinda work. I ran a php script and it told me that 127.0.0.1 didn't have permission to access the database. Should I uninstall and reinstall, or should I use localhost instead of 127.0.0.1, or did I install the wrong thing, or what? Thanks in advance!

Type "pkg_info | grep mysql" and see if anything comes up. That will tell you if it's installed or not. If it's not listed, go to /usr/ports/databases and pick out one of the mysql listings to install. It's probably best to just go with the newest one listed unless you have reason otherwise. If you don't have ports installed or don't want to spend the time to compile it youself, I'm sure it's available as a binary package, too. Just a guess: "pkg_add -r mysql"

With it installed, type "mysql" at the prompt. If it lets you in (no password for root on localhost, should be the default), then you're pretty much set. Change passwords, create users, etc etc. If it doesn't let you in, then check mysql docs for how to do user administration. Check with "ps -aux | grep mysql" to make sure the server daemon is running if error messages make it look like it's not.