Installing MySQL v6 in FreeBSD
FreeBSD places its packages under /usr/ports/. Now for databases, types this command
cd /usr/ports/databases/mysql60-server
Then issue
make
after make, issue
make install
You can even specify it's configuration options like --prefix by doing "make install --prefix=/usr/local" where it will install the mysql packages.
This is applied also to the client package, just follow the steps how the server is being installed.
Create /var/db/mysql if that direcotry doesn't exist, then "chown mysql:mysql /var/db/mysql" and "chmod 770 /var/db/mysql" for security. Run the mysql_install_db command which will create default tables that mysql will used on its server process.
Run the mysql background process by issuing the command "/usr/local/etc/rc.d/mysql-server start" or perhaps it might be "/usr/local/etc/rc.d/mysql-server.sh start". I think older BSD preserves the .sh suffix on the start up scripts.
Don't forget to provide password to your root. Issue this command "mysqladmin -u root password egret" where "egret" is my database password, just an example.
Hope this helps!
cd /usr/ports/databases/mysql60-server
Then issue
make
after make, issue
make install
You can even specify it's configuration options like --prefix by doing "make install --prefix=/usr/local" where it will install the mysql packages.
This is applied also to the client package, just follow the steps how the server is being installed.
Create /var/db/mysql if that direcotry doesn't exist, then "chown mysql:mysql /var/db/mysql" and "chmod 770 /var/db/mysql" for security. Run the mysql_install_db command which will create default tables that mysql will used on its server process.
Run the mysql background process by issuing the command "/usr/local/etc/rc.d/mysql-server start" or perhaps it might be "/usr/local/etc/rc.d/mysql-server.sh start". I think older BSD preserves the .sh suffix on the start up scripts.
Don't forget to provide password to your root. Issue this command "mysqladmin -u root password egret" where "egret" is my database password, just an example.
Hope this helps!
Comments