- 工信部備案號 滇ICP備05000110號-1
- 滇公安備案 滇53010302000111
- 增值電信業(yè)務(wù)經(jīng)營(yíng)許可證 B1.B2-20181647、滇B1.B2-20190004
- 云南互聯(lián)網(wǎng)協(xié)會(huì )理事單位
- 安全聯(lián)盟認證網(wǎng)站身份V標記
- 域名注冊服務(wù)機構許可:滇D3-20230001
- 代理域名注冊服務(wù)機構:新網(wǎng)數碼
Linux下安裝Mariadb,我是使用的centos 7.1系統,在yum源配置好的情況下
yum search mariadb
搜索結果如下
==================================================================================== N/S matched: mariadb =====================================================================================
mariadb-bench.x86_64 : MariaDB benchmark scripts and data
mariadb-devel.i686 : Files for development of MariaDB/MySQL applications
mariadb-devel.x86_64 : Files for development of MariaDB/MySQL applications
mariadb-embedded.i686 : MariaDB as an embeddable library
mariadb-embedded.x86_64 : MariaDB as an embeddable library
mariadb-embedded-devel.i686 : Development files for MariaDB as an embeddable library
mariadb-embedded-devel.x86_64 : Development files for MariaDB as an embeddable library
mariadb-libs.x86_64 : The shared libraries required for MariaDB/MySQL clients
mariadb-libs.i686 : The shared libraries required for MariaDB/MySQL clients
mariadb-server.x86_64 : The MariaDB server and related files
mariadb.x86_64 : A community developed branch of MySQL
mariadb-test.x86_64 : The test suite distributed with MariaD
percona-xtrabackup.x86_64 : Online backup for InnoDB/XtraDB in MySQL, Percona Server and MariaDB
Name and summary matches only, use "search all" for everything.
然后安裝mariadb-server.x86_64 mariadb.x86_64這兩個(gè)包(一個(gè)是服務(wù)一個(gè)是客戶(hù)端,不同的系統名字可能不一樣)
yum install mariadb.x86_64
yum install mariadb-server.x86_64
或者 yum groupinstall -y mariadb mariadb-server
或者直接yum install mariadb會(huì )直接裝好(我第一次就是直接使用這個(gè)命令裝好的)
裝完后啟動(dòng)mariadb
systemctl start mariadb
先進(jìn)一下數據庫試一下,沒(méi)問(wèn)題就是安裝完成
#########################################################################################
接下來(lái)就是初始化了
mysql_secure_installation #這是一個(gè)快速初始化的命令
首先他會(huì )提示輸入root密碼
Enter current password for root (enter for none):
初次安裝時(shí)沒(méi)有密碼的所以直接回車(chē)
然后Change the root password? [Y/n] 修改密碼
Remove anonymous users? [Y/n] 移除匿名用戶(hù),這個(gè)一般都要移除
Disallow root login remotely? [Y/n] 不允許root用戶(hù)遠程登錄,一般是不允許,所以yes
Remove test database and access to it? [Y/n] 刪除test數據庫,這個(gè)不是太重要
Reload privilege tables now? [Y/n] 是否重新加載授權表 yes
這樣基本初始化就完成了
###########################################################################################
設置字符集一般建議是在配置文件中設置,也可以在數據庫中設置,在數據庫中設置的話(huà)當服務(wù)重啟后就會(huì )恢復默認字符集,會(huì )出現亂碼現象
配置文件一般在/etc/my.cnf
vim /etc/my.cnf
在[mysqld]下添加如下配置
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
在[client]下添加 (有些配置文件沒(méi)有[client],是因為包含了 “!includedir /etc/my.cnf.d”這句話(huà),說(shuō)明其他配置在這個(gè)目錄中)
default-character-set=utf8
然后重啟mariadb
登錄數據庫查看字符集是否設置正確 show variables like "%character%";show variables like "%collation%"
這樣就設置成功了
創(chuàng )建數據庫:
CREATE DATABASE `test2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
導入sql文件
Source sql文件路徑
售前咨詢(xún)
售后咨詢(xún)
備案咨詢(xún)
二維碼
TOP