Mysql的源码编译

1.下载安装包wget https://downloads.mysql.com/archives/get/p/23/file/mysql-boost-8.3.0.tar.gz2.源码编译​ [rootmysql-node1 ~]# dnf install cmake3 gcc git bison openssl-devel ncurses-devel systemd-devel rpcgen.x86_64 libtirpc-devel-1.3.3-9.el9.x86_64.rpm gcc-toolset-12-gcc gcc-toolset-12-gcc-c gcc-toolset-12-binutils gcc-toolset-12-annobin-annocheck gcc-toolset-12-annobin-plugin-gcc -y ​ [rootmysql-node1 ~]# tar zxf mysql-boost-8.3.0.tar.gz [rootmysql-node1 mysql-8.3.0]# mkdir build [rootmysql-node1 mysql-8.3.0]# cd build/ ​ [rootmysql-node1 build]# cmake3 .. -DCMAKE_INSTALL_PREFIX/usr/local/mysql -DMYSQL_DATADIR/data/mysql -DMYSQL_UNIX_ADDR/data/mysql/mysql.sock -DWITH_INNOBASE_STORAGE_ENGINE1 -DWITH_EXTRA_CHARSETSall -DDEFAULT_CHARSETutf8mb4 -DDEFAULT_COLLATIONutf8mb4_unicode_ci -DWITH_BOOSTbundled -DWITH_SSLsystem -DWITH_DEBUGOFF ​ ​ [rootmysql-node1 build]# make3.部署mysql[rootmysql-node1 build]# make install [rootmysql-node1 build]# cd /usr/local/mysql/ ​ [rootmysql-node1 mysql]# vim ~/.bash_profile # .bash_profile ​ # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi ​ # User specific environment and startup programs export PATH$PATH:/usr/local/mysql/bin #设置mysql运行环境的环境变量 ​ ​ [rootmysql-node1 mysql]# source ~/.bash_profile ​ [rootmysql-node1 mysql]# useradd -r -s /sbin/nologin -M mysql ​ [rootmysql-node1 mysql]# mkdir -p /data/mysql [rootmysql-node1 mysql]# chown mysql.mysql /data/mysql/ ​ [rootmysql-node1 ~]# vim /etc/my.cnf [mysqld] datadir/data/mysql socket/data/mysql/mysql.sock4.mysql数据结构初始化[rootmysql-node1 ~]# mysqld --initialize --usermysql5.启动mysql[rootmysql-node1 support-files]# dnf install initscripts-10.11.8-4.el9.x86_64 -y ​ [rootmysql-node1 support-files]# cd /usr/local/mysql/support-files/ [rootmysql-node1 support-files]# cp -p mysql.server /etc/init.d/mysqld ​ [rootmysql-node1 support-files]# /etc/init.d/mysqld start Starting MySQL.Logging to /data/mysql/mysql-node1.err. . SUCCESS! ​ #开机启动 [rootmysql-node1 support-files]# chkconfig --level 35 mysqld on ​6.mysql的安全初始化[rootmysql-node1 ~]# mysql_secure_installation Securing the MySQL server deployment. ​ Enter password for user root: ​ The existing password for the user account root has expired. Please set a new password. ​ New password: ​ Re-enter new password: ​ VALIDATE PASSWORD COMPONENT can be used to test passwords and improve security. It checks the strength of password and allows the users to set only those passwords which are secure enough. Would you like to setup VALIDATE PASSWORD component? ​ Press y|Y for Yes, any other key for No: no Using existing password for root. Change the password for root ? ((Press y|Y for Yes, any other key for No) : no ​ ​ Remove anonymous users? (Press y|Y for Yes, any other key for No) : y Success. ​ ​ Normally, root should only be allowed to connect from localhost. This ensures that someone cannot guess at the root password from the network. ​ Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y Success. ​ By default, MySQL comes with a database named test that anyone can access. This is also intended only for testing, and should be removed before moving into a production environment. ​ ​ Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y - Dropping test database... Success. ​ - Removing privileges on test database... Success. ​ Reloading the privilege tables will ensure that all changes made so far will take effect immediately. ​ Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y Success. ​ All done! ​