【就业班作业】【第十三周】编译安装Mariadb，并启动后可以正常登录

一、以yum方式安装，启用maridb服务

yum -y install mariadb-server
systemctl start mariadb
ss -ntl   //tcp 3306端口
mysql_secure_installation  //数据库安全初始化脚本
mysql -U    //以安全模式登录，避免误删除等操作

二、以二进制方式安装，启用mariadb服务

1、准备磁盘
fdisk /dev/sda
n
t
8e
w
partprobe
lsblk
2、使用逻辑卷管理
yum -y install lvm2
pvcreate /dev/sda4
pvs
vgcreate mysql-vg /dev/sda4
vgs
lvcreate -L 10G -n mysql-lv mysql-vg
lvs
3、格式化逻辑卷
mkfs.xfs  /dev/mysql-vg/mysql-lv
vi /etc/fstab
/dev/mysql-vg/mysql-lv /data xfs defaults 0 0
mount -a 
4、准备二进制文件
wget -c https://mirrors.ustc.edu.cn/mariadb//mariadb-10.5.8/bintar-linux-systemd-x86_64/mariadb-10.5.8-linux-systemd-x86_64.tar.gz
5、安装二进制包
mkdir -p /data/mysql
useradd -r -s /usr/sbin/nologin -d /data/mysql/ mysql   //创建系统用户指定家目录
tar -xf mariadb-10.5.8-linux-systemd-x86_64.tar.gz -C /usr/local/
ln -sv mariadb-10.5.8-linux-systemd-x86_64/ mysql
chown -R root.root mariadb-10.5.8-linux-systemd-x86_64/
6、配置文件准备
vi /etc/my.cnf
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
user  = mysql
basedir = /usr/local/mysql
datadir = /data/mysql
skip_name_resolve = on 
[mysqld_safe]
log_error = /data/mysql/mysql.err
pid-file = /data/mysql/mysql.pid
7、创建数据库文件
cd /usr/local/mysql
./scripts/mysql_install_db --datadir=/data/mysql --user=mysql
8、准备服务脚本，并启动服务
chown mysql.mysql /var/lib/mysql
cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld  将脚本文件夹中启动脚本复制改名到初始化目录
chkconfig --add mysqld
chkconfig --list
或
cp ./support-files/mariadb.service /usr/lib/systemd/system/mysqld.service
systemctl daemon-reload
9、设置mysql客户端配置
vi /etc/my.cnf.d/mysql-clients.cnf
[mysql]
socket = /var/lib/mysql/mysql.sock
10、登录测试
mysql

mysql_secure_installation   //初始化数据库安全配置
vi  mysql_secure_installation
make_config() {
    echo "socket=/var/lib/mysql/mysql.sock" >>$config          //增加此项

三、源码编译安装mysql

yum -y install bison bison-devel zlib-devel libcurl-devel libarchive-devel boost-devel ?gcc gcc-c++ cmake ncurses-devel gnutls-devel libxml2-devel openssl-devel libevent-devel libaio-devel

useradd -r -s /sbin/nologin -d /data/mysql mysql

mkdir /data/mysql

chown mysql.mysql /data/mysql

tar -xf mariadb-10.2.18.tar.gz

cd mariadb-10.2.18/
cmake . \
-DCMAKE_INSTALL_PREFIX=/app/mysql \
-DMYSQL_DATADIR=/data/mysql/ \
-DSYSCONFDIR=/etc/ \
-DMYSQL_USER=mysql \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITHOUT_MROONGA_STORAGE_ENGINE=1 \
-DWITH_DEBUG=0 \
-DWITH_READLINE=1 \
-DWITH_SSL=system \
-DWITH_ZLIB=system \
-DWITH_LIBWRAP=0 \
-DENABLED_LOCAL_INFILE=1 \
-DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci

make && make install

echo 'PATH=/data/app/mysql/bin:$PATH' > /etc/profile.d/mysql.sh

cd /data/app/mysql/
scripts/mysql_install_db --datadir=/data/mysql/ --user=mysql

cp /data/app/mysql/support-files/my-huge.cnf /etc/my.cnf

cp /data/app/mysql/support-files/mysql.server /etc/init.d/mysqld
chkconfig --add mysqld
service mysqld start

mysql_secure_installation

（结束）