
- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
Installing MySQL on FreeBSD
MySQL can be installed on FreeBSD using the binary distribution which is provided by Oracle. The preferred and easiest way to install MySQL is to use the ‘mysql-server’ and ‘mysql-client’ ports which are available on http://www.freebsd.org/ website.
The advantage of using these ports are −
It comes with a working MySQL server and it contains all optimizations that are enabled, and help work on the user’s version of FreeBSD.
It is automatically configured and built.
The start up scripts are installed in /usr/local/etc/rc.d.
It gives the ability to the user to use pkg_info –L to see which of the files were installed.
It also gives the ability to the user to use pkg_delete to remove MySQL if it is no longer required on the machine.
The process to build MySQL requires GNU make (gmake) to work properly. If GNU make is not available, it has to be installed first, before MySQL is compiled.
The ports system can be installed using the below commands −
# cd /usr/ports/databases/mysql80−server # make ... # cd /usr/ports/databases/mysql80−client # make
The standard port installation will place the server into /usr/local/libexec/mysqld, and the startup script for MySQL server is palced in /usr/local/etc/rc.d/mysql-server.
The MySQL server can be installed using the ports system using the below code −
Examples
# cd /usr/ports/databases/mysql80-server # make deinstall ... # cd /usr/ports/databases/mysql80-client # make deinstall
- Related Articles
- Installing MySQL on macOS
- Installing MySQL on Linux
- Installing MySQL on Solaris
- Installing MySQL on Microsoft Windows
- Installing MySQL from source on linux
- Installing MySQL on Unix/Linux Using Generic Binaries
- Installing MySQL from Source
- Installing Python on Linux
- Installing Python on Windows
- Installing a MySQL Source Distribution
- Installing Python on Mac OS
- Installing AWS CLI on Linux
- Installing Java on Linux using SSH
- Installing MySQL Using Unbreakable Linux Network (ULN)
- Installing SAP JCo on Glassfish server 4.0
