mysql实验

mysql实验

在Linux下部署mysql

下载源码安装需要用到的软件

yum  install cmake gcc-c++ openssl-devel -y
yum install ncurses-devel.x86_64   rpcgen.x86_64  -y

导入libtirpc-devel-0.2.4-0.16.el7.x86_64.rpm

yum install libtirpc-devel-0.2.4-0.16.el7.x86_64.rpm -y

导入mysql-boost-5.7.44.tar.gz

tar zxf mysql-boost-5.7.44.tar.gz

源码编译安装mysql

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql -DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_EXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_unicode_ci -DWITH_BOOST=/root/mysql-5.7.44/boost/boost_1_59_0/
make -j4  && make install

部署mysql

dnf install initscripts-10.11.6-1.el9.x86_64 -y
cd /usr/local/mysql/
useradd -s /sbin/nologin -M mysql
mkdir /data/mysql -p
chown mysql.mysql -R /data/mysql
cd /usr/local/mysql/support-files/
cp mysql.server /etc/init.d/vim ~/.bash_profile
export PATH=$PATH:/usr/local/mysql/bin
source ~/.bash_profile
yum install mariadb-connector-c-config-3.2.6-1.el9_0.noarch -y
vim /etc/my.cnf
[mysqld]
datadir=/data/mysql
socket=/data/mysql/mysql.sock
symbolic-links=0
mysqld --initialize --user=mysql
/etc/init.d/mysqld start
chkconfig mysqld on

数据库安全初始化

测试：

见pdf