MySQL on FreeBSD

[elzergone]

Basically...where do I get it?? How do I install it, etc? I'm a windows netadmin finding myself lost in this new world of open source


Thanks everyone.

 

[Fint]

as root, I think, do 'portinstall mysql'

 

[elzergone]

Nope, that didnt work. portinstall isnt a command it seems.

 

[craigmp]

I installed it from the ports tree. I don't have that much experience with FreeBSD but the install was pretty easy.

Login as root

Update your ports tree...I prefer to use the cvsup method.Using the Ports Collection

After that cd to /usr/ports/databases and look to see what version of mysql you want to install. Just type ls | more and you can use page up and page down to see the files listed. Once you find the version you want cd to that directory and type make install clean. It will start building mysql and install it. Once that is done type /usr/local/bin/mysql_install_db
Then type chown -R mysql /var/db/mysql/ and chgrp -R mysql /var/db/mysql/ This will change the group and owner of the database files so the mysql user can write to them. You don't want to have the mysql server running as root. After that type vi /etc/rc.conf vi is a text editor that I prefer to use. Use the arrow keys to move down to the last line in the file and press the i key to insert. Press enter to move down to the next line and then type mysql_enable="YES" Press esc a couple of times then press shift : type wq! It should take you back to the prompt. Reboot the machine and mysql should work. These are the steps I did to install mysql on my server at home. I'm sure there are other easier ways to do it. If anyone has any other ideas let me know.

 

[elzergone]

I installed it from the ports tree. I don't have that much experience with FreeBSD but the install was pretty easy.

Login as root

Update your ports tree...I prefer to use the cvsup method.Using the Ports Collection

After that cd to /usr/ports/databases and look to see what version of mysql you want to install. Just type ls | more and you can use page up and page down to see the files listed. Once you find the version you want cd to that directory and type make install clean. It will start building mysql and install it. Once that is done type /usr/local/bin/mysql_install_db
Then type chown -R mysql /var/db/mysql/ and chgrp -R mysql /var/db/mysql/ This will change the group and owner of the database files so the mysql user can write to them. You don't want to have the mysql server running as root. After that type vi /etc/rc.conf vi is a text editor that I prefer to use. Use the arrow keys to move down to the last line in the file and press the i key to insert. Press enter to move down to the next line and then type mysql_enable="YES" Press esc a couple of times then press shift : type wq! It should take you back to the prompt. Reboot the machine and mysql should work. These are the steps I did to install mysql on my server at home. I'm sure there are other easier ways to do it. If anyone has any other ideas let me know.

Thank you! That was fairly easy. Now can you help me with something else pretty please?

http://www.grpl.org/ism/install.html#apache

That. I'm confused.

 

[HHunt]

If you're trying to install apache and mod_perl, use ports instead of doing it by hand.
( Mod_perl is in www/mod_perl, apache is in www/apache13 or www/apache2. )

Btw: I'd suggest using ee instead of vi, it's easier.