- yum安裝mariadb
yum? install?? mariadb-server
2. 規劃數據庫
mkdir? /mysqldb/330{6,7,8}/{etc,socket,pid,log,data}? -pv
3. 創建用戶
chown? -R? mysql.mysql?? /mysqldb
如果沒有mysql用戶則要重新創建
4. 生成數據庫
mysql_install_db –datadir=/mysqldb/3306/data ?–user=mysql
mysql_install_db –datadir=/mysqldb/3307/data ?–user=mysql
mysql_install_db –datadir=/mysqldb/3308/data ?–user=mysql
? ? ? ? ?查看數據庫路徑 show? variables? like? ‘%basedir%’； –basedir=/usr/? 默認
5. 生成配置文件
cp? /etc/my.cnf??? /mysqldb/3306/etc/
cp? /etc/my.cnf??? /mysqldb/3307/etc/
cp? /etc/my.cnf??? /mysqldb/3308/etc/
修改：
port=3306
datadir=/mysqldb/3306/data
socket=/mysqldb/3306/socket/mysql.sock
log-error=/mysqldb/3306/log/mariadb.log
pid-file=/mysqldb/3306/pid/mariadb.pid
#！includedir?? /etc/my.cnf.d???? （注釋掉）
7、8、同上修改
6.啟動腳本
rz 到系統中
cp mysqld /mysqldb/3306/
cp mysqld /mysqldb/3307/
cp mysqld /mysqldb/3308/
chmod 700 /mysqldb/3308/mysqld
chmod 700 /mysqldb/3307/mysqld
chmod 700 /mysqldb/3306/mysqld
vim? /mysqldb/3306/mysqld
vim? /mysqldb/3307/mysqld
vim? /mysqldb/3308/mysqld
修改：
port=3306
cmd_path=“/usr/bin”
7. systemctl? stop?? mariadb
8.啟動服務
/mysqldb/3308/mysqld start
/mysqldb/3307/mysqld start
/mysqldb/3306/mysqld start
9.連接實例
mysql? -S /mysqldb/3308/socket/mysql.sock
mysql? -S /mysqldb/3307/socket/mysql.sock
mysql? -S /mysqldb/3306/socket/mysql.sock
????????? 查看是否連接上 ??????? show? variables? like? ‘%port%’； 注意：腳本里有老王的坑 – ? ? ? ?
? ? ? ? ?p${mysql_pwd}??? 要輸入密碼 去掉這一行就好
- 彩蛋
select? user，host，password? form? mysql.user
? ? ? ?mysql.user??? 表示mysql數據庫里的user表
添加口令 :
update? mysql.user? set? password=password(“970628”)? where? user=’root’ ;
flush? privileges;? 使添加的生效
本文來自投稿，不代表Linux運維部落立場，如若轉載，請注明出處：http://www.www58058.com/100878
