教你如何在 FreeBSD 13 中安装 MySQL 数据库

环    境

FreeBSD 13-RELEASE

修改 pkg 源

需要先创建/usr/local/etc/pkg/repos目录，然后创建FreeBSD.conf配置文件，并将默认源关闭，然后添加国内软件源。

root@freebsd:~ # mkdir -p /usr/local/etc/pkg/repos
root@freebsd:~ # vi /usr/local/etc/pkg/repos/FreeBSD.conf
FreeBSD:{ enabled: no }
ustc:{
  url:"pkg+http://mirrors.ustc.edu.cn/freebsd-pkg//${ABI}/quarterly",
  mirror_type:"srv",
  signature_type:"fingerprints",
  fingerprints:"/usr/share/keys/pkg",
  enabled: yes
}

更新pkg源：

root@freebsd:~ # pkg update-f
Updating ustc repository catalogue...
Fetching meta.txz:100%916 B   0.9kB/s    00:01
Fetching packagesite.txz:100%6 MiB   6.5MB/s    00:01
Processing entries:100%
ustc repository update completed. 30371 packages processed.
All repositories are up to date.

安装 MySQL 数据库

搜索一下pkg源里面有哪些版本的mysql：

root@freebsd:~ # pkg search "^mysql"

下面安装mysql80版本：

root@freebsd:~ # pkg install -y mysql80-server mysql80-client

运行 MySQL

接下来你将运行下面的命令，这会将 MySQL 服务添加到 /etc/rc.conf配置文件中，并开机启动mysql。

root@freebsd:~ # sysrc mysql_enable=yes
mysql_enable:-> yes

启动mysql服务：

root@freebsd:~ # service mysql-server start
Starting mysql.

查看服务状态和mysql监听的端口：

root@freebsd:~ # service mysql-server status
mysql is running as pid 2194.
root@freebsd:~ # sockstat -4l
USER     COMMAND    PID   FD PROTO  LOCAL ADDRESS         FOREIGN ADDRESS      
mysql    mysqld     219419 tcp46  *:33060*:*
mysql    mysqld     219424 tcp4   127.0.0.1:3306*:*
root     sshd       8024  tcp4   *:22*:*
root     sendmail   7813  tcp4   127.0.0.1:25*:*
root     syslogd    7097  udp4   *:514*:*

验证安装

要验证安装，您可以用 root 身份登录并使用以下命令检查数据库版本：、

root@freebsd:~ # mysqladmin -u root -p version
Enter password:
mysqladmin  Ver 8.0.25 for FreeBSD13.0on amd64 (Source distribution)
Copyright (c)2000,2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Server version  8.0.25
Protocol version 10
Connection  Localhost via UNIX socket
UNIX socket  /tmp/mysql.sock
Uptime:4 min 16 sec
Threads:2  Questions:6  Slow queries:0  Opens:138  Flush tables:3  Open tables:54  Queries per second avg:0.023

总    结

到目前MySQL 8 已安装并运行在 FreeBSD 13上了。