Installing MySQL on FreeBSD

Go to the installation folder
cd /usr/ports/databases/mysql56-server

carry out the installation command
make install clean

After a long run of installation edit the below file
nano /etc/rc.conf

add this line and save&exit
mysql_enable="YES"

start the server
/usr/local/etc/rc.d/mysql-server start

Set the root password
mysqladmin -u root password "YOUR-PASSWORD-GOES-HERE"

connect to your server
mysql -u root -p

Then to see status type in

mysql=> STATUS;

mysql Ver 14.14 Distrib 5.5.40, for FreeBSD10.0 (amd64) using 5.2

Connection id: 10
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: more
Using outfile: ”
Using delimiter: ;
Server version: 5.5.40 Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 16 min 18 sec

Threads: 1 Questions: 22 Slow queries: 0 Opens: 33 Flush tables: 1 Open tables: 26 Queries per second avg: 0.022
————–






 

Leave a Reply

Your email address will not be published. Required fields are marked *