您好,登錄后才能下訂單哦!
本篇內(nèi)容介紹了“FreeBSD13中怎么安裝MySQL數(shù)據(jù)庫”的有關(guān)知識(shí),在實(shí)際案例的操作過程中,不少人都會(huì)遇到這樣的困境,接下來就讓小編帶領(lǐng)大家學(xué)習(xí)一下如何處理這些情況吧!希望大家仔細(xì)閱讀,能夠?qū)W有所成!
MySQL是一個(gè)開放源碼的小型關(guān)聯(lián)式數(shù)據(jù)庫管理系統(tǒng),目前MySQL被廣泛地應(yīng)用在Internet上的中小型網(wǎng)站中。由于其體積小、速度快、總體擁有成本低,尤其是開放源碼這一特點(diǎn),許多中小型網(wǎng)站為了降低網(wǎng)站總體擁有成本而選擇了MySQL作為網(wǎng)站數(shù)據(jù)庫。
FreeBSD 13-RELEASE
需要先創(chuàng)建/usr/local/etc/pkg/repos
目錄,然后創(chuàng)建FreeBSD.conf配置文件,并將默認(rèn)源關(guān)閉,然后添加國內(nèi)軟件源。
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 }
更新pkg源:
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.
搜索一下pkg源里面有哪些版本的mysql:
root@freebsd:~ # pkg search "^mysql"
下面安裝mysql80版本:
root@freebsd:~ # pkg install -y mysql80-server mysql80-client
接下來你將運(yùn)行下面的命令,這會(huì)將 MySQL 服務(wù)添加到 /etc/rc.conf
配置文件中,并開機(jī)啟動(dòng)mysql。
root@freebsd:~ # sysrc mysql_enable=yesmysql_enable: -> yes
啟動(dòng)mysql服務(wù):
root@freebsd:~ # service mysql-server startStarting mysql.
查看服務(wù)狀態(tài)和mysql監(jiān)聽的端口:
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 *:*
要驗(yàn)證安裝,您可以用 root 身份登錄并使用以下命令檢查數(shù)據(jù)庫版本:
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
“FreeBSD13中怎么安裝MySQL數(shù)據(jù)庫”的內(nèi)容就介紹到這里了,感謝大家的閱讀。如果想了解更多行業(yè)相關(guān)的知識(shí)可以關(guān)注億速云網(wǎng)站,小編將為大家輸出更多高質(zhì)量的實(shí)用文章!
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。