环境
root@c7-105 ~]# cat /etc/redhat-release CentOS Linux release 7.6.1810 (Core) [root@c7-105 ~]# ls /home/tools/ mysql-5.7.30 mysql-boost-5.7.30.tar.gz
前置包安装
yum install cmake libaio -y
yum install -y gcc-c++ bison-devel ncurses-devel bison perl perl-devel perl perl-devel
yum install openssl openssl-devel ncurses ncurses-devel -y
安装
#ls /home/tools #tar -xf mysql-boost-5.7.30.tar.gz #cd mysql-5.7.30/ #cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.7.30/ -DMYSQL_DATADIR=/data/ -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DSYSCONFDIR=/etc -DWITH_BOOST=boost -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=bundled -DENABLED_LOCAL_INFILE=1 -DDEFAULT_CHARSET=utf8 -DEXTRA_CHARSETS=all -DDEFAULT_COLLATION=utf8_general_ci -DWITH_DEBUG=0 #ln -s /usr/local/mysql-5.7.30/ /usr/local/mysql #chown -R mysql.mysql /usr/local/mysql #cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld # cp /etc/{my.cnf,my.cnfbk} #>my.cnf #vi my.cnf [client] port=3306 default-character-set=utf8 socket=/tmp/mysql.sock [mysqld] basedir=/usr/local/mysql datadir=/data port=3306 socket=/tmp/mysql.sock character-set-server=utf8 explicit_defaults_for_timestamp=true innodb_file_per_table = 1 #echo 'export PATH=/usr/local/mysql/bin:$PATH' >>/etc/profile #source /etc/profile /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data 2021-01-14T14:30:21.046334Z 1 [Note] A temporary password is generated for root@localhost: pl,l*<0;WI/: [root@c7-105 data]# /etc/init.d/mysqld start Starting MySQL.Logging to '/data/c7-105.err'. SUCCESS!
进入数据库更改密码
mysql> alter user user() identified by "******";
使用systemd管理mysql
#vi /usr/lib/systemd/system/mysql.service [Unit] Description=MySQL Server Documentation=man:mysqld（8） Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html After=network.target After=syslog.target [Install] WantedBy=multi-user.target [Service] User=mysql Group=mysql ExecStart=/usr/local/mysql/bin/mysqld --defaults=/etc/my.cnf LimitNOFILE = 5000 #systemctl daemon-reload