安装依赖包
[root@localhost src]# yum install -y ncurses-devel libaio-devel cmake
创建mysql用户
[root@localhost src]# useradd -s /sbin/nologin -M mysql
卸载mariaDB
[root@localhost src]# yum remove mariadb-libs #产生的my.cnf有干扰或删除/etc/my.cnf
下载解压安装
[root@localhost src]# wget https://cdn.mysql.com/archives/mysql-5.7/mysql-boost-5.7.26.tar.gz
#下载有boost版本减少后续麻烦
[root@localhost src]# ls
mysql-5.7.26.tar.gz nginx-1.22.1 nginx-1.22.1.tar.gz
[root@localhost src]# tar -xf mysql-boost-5.7.26.tar.gz
cmake . \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DMYSQL_TCP_PORT=3306 \
-DMYSQL_UNIX_ADDR=/usr/local/mysql/data/mysql.sock \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8mb4 \
-DDEFAULT_COLLATION=utf8mb4_general_ci \
-DWITH_SSL=system \
-DWITH_BOOST=boost
make && make install
授权
chown -R mysql.mysql /usr/local/mysql
初始化
mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
编写配置文件
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/data/mysql.sock
启动
service启动
/etc/init.d
systemd启动
vim /etc/systemd/system/mysqld.service
[Unit]
Description=MySQL Server
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE=5000
[Install]
WantedBy=multi-user.target
设置密码
mysqladmin -uroot -p password xxx
忘记密码重置密码
1.关闭数据库
2.进入维护模式 [root@www mysql]# mysqld_safe --skip-grant-tables --skip-networking &
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> alter user root@'localhost' identified by 'songjianjiang123';
Query OK, 0 rows affected (0.00 sec)
