Home > Database > Mysql Tutorial > body text

How to install MySQL database in FreeBSD13

WBOY
Release: 2023-05-31 16:21:30
forward
1470 people have browsed it

MySQL is an open source small relational database management system. MySQL is currently widely used in small and medium-sized websites on the Internet. Due to its small size, fast speed, low total cost of ownership, and especially the characteristics of open source, many small and medium-sized websites choose MySQL as their website database in order to reduce the total cost of website ownership.

How to install MySQL database in FreeBSD13
##Environment

FreeBSD 13-RELEASE

Modify the pkg source

You need to create

/usr/ first local/etc/pkg/repos directory, then create the FreeBSD.conf configuration file, close the default source, and then add the domestic software source.

root@freebsd:~ # mkdir -p /usr/local/etc/pkg/reposroot@freebsd:~ # vi /usr/local/etc/pkg/repos/FreeBSD.confFreeBSD: { 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
}
Copy after login

How to install MySQL database in FreeBSD13

Update pkg source:

root@freebsd:~ # pkg update -fUpdating 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.
Copy after login

How to install MySQL database in FreeBSD13
Install MySQL database

Search the pkg source What versions of mysql are there:

root@freebsd:~ # pkg search "^mysql"
Copy after login

How to install MySQL database in FreeBSD13

Install the mysql80 version below:

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

How to install MySQL database in FreeBSD13
Run MySQL

Next you will run the following command, which will add the MySQL service to the

/etc/rc.conf configuration file and start mysql on boot.

root@freebsd:~ # sysrc mysql_enable=yesmysql_enable:  -> yes
Copy after login

How to install MySQL database in FreeBSD13

Start the mysql service:

root@freebsd:~ # service mysql-server startStarting mysql.
Copy after login

View the service status and mysql listening port:

root@freebsd:~ # service mysql-server statusmysql is running as pid 2194.
root@freebsd:~ # sockstat -4lUSER     COMMAND    PID   FD PROTO  LOCAL ADDRESS         FOREIGN ADDRESS      
mysql    mysqld     2194  19 tcp46  *:33060               *:*
mysql    mysqld     2194  24 tcp4   127.0.0.1:3306        *:*
root     sshd       802   4  tcp4   *:22                  *:*
root     sendmail   781   3  tcp4   127.0.0.1:25          *:*
root     syslogd    709   7  udp4   *:514                 *:*
Copy after login

How to install MySQL database in FreeBSD13
Verify installation

To verify the installation, you can log in as root and check the database version using the following command:

root@freebsd:~ # mysqladmin -u root -p versionEnter password:
mysqladmin  Ver 8.0.25 for FreeBSD13.0 on 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
Copy after login

How to install MySQL database in FreeBSD13

The above is the detailed content of How to install MySQL database in FreeBSD13. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:yisu.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template