MySQL installation in FreeBSD

Here is the steps to install MySQL in FreeBSD servers.

1. cd /usr/ports/databases/mysql*-server/

Note: * indicates that you can select the MySQL version as your wish.

2. make install clean

3. /usr/local/bin/mysql_install_db

4. chown -R mysql /var/db/mysql/

5. chgrp -R mysql /var/db/mysql/

6. /usr/local/bin/mysqld_safe –user=mysql &

7. /usr/local/bin/mysqladmin -u root password newpassword

8. Open the file /etc/rc.conf and add the following line

mysql_enable=”YES”