删除MariaDB
# rpm -qa|grep maria
mariadb-libs-5.5.65-1.el7.x86_64
# rpm -e mariadb-libs-5.5.65-1.el7.x86_64 --nodeps
安装依赖
yum install wget bison gcc gcc-c++ wget make cmake ncurses-devel libtool zilib-devel -y
解压
# tar -zxvf mysql-5.7.32-el7-x86\_64.tar.gz -C /usr/local/
cd /usr/local
# ln -s mysql-5.7.32-el7-x86\_64/ mysql
创建用户
groupadd mysql
useradd -g mysql mysql
echo "mysql"|passwd --stdin mysql
chown -R mysql:mysql /usr/local/mysql-5.7.32-el7-x86_64/
chown -R mysql:mysql /usr/local/mysql
创建目录
mkdir -p /data/data/
mkdir -p /data/binlog/
mkdir -p /data/log/
chown -R mysql:mysql /data/
配置my.cnf
vim /etc/my.cnf
[mysqld]
basedir=/usr/local/mysql/
datadir=/data/data/
log-bin=/data/binlog/mysql-bin
log-bin-index=/data/binlog/binlog.index
server-id=1
port=3306
socket=/data/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
explicit_defaults_for_timestamp=true
[mysqld_safe]
log-error=/data/log/mysqld.err
pid-file=/data/log/mysqld.pid
[mysql]
socket=/data/mysql.sock
# chown -R mysql:mysql /etc/my.cnf
配置环境变量
su - mysql
vim .bash_profile
MYSQL_HOME=/usr/local/mysql/
PATH=$PATH:$HOME/.local/bin:$HOME/bin:$MYSQL_HOME/bin
export MYSQL_HOME
export PATH
source .bash_profile
初始化
最后会提示临时用户名密码
$ mysqld --defaults-file=/etc/my.cnf --initialize
2021-03-25T09:47:02.521148Z 0 \[Warning\] InnoDB: New log files created, LSN=45790
2021-03-25T09:47:02.559535Z 0 \[Warning\] InnoDB: Creating foreign key constraint system tables.
2021-03-25T09:47:02.630236Z 0 \[Warning\] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 0d14591f-8d4f-11eb-a507-000c291ae5c9.
2021-03-25T09:47:02.631079Z 0 \[Warning\] Gtid table is not ready to be used. Table 'mysql.gtid\_executed' cannot be opened.
2021-03-25T09:47:03.864829Z 0 \[Warning\] CA certificate ca.pem is self signed.
2021-03-25T09:47:04.178007Z 1 \[Note\] A temporary password is generated for root@localhost: k#rjoAROO3/j
如下命令没有初始密码
$ mysqld --defaults-file=/etc/my.cnf initialize-insecure
启动
$ mysqld_safe --defaults-file=/etc/my.cnf &
修改密码
$ mysql -uroot -p
mysql> alter user root@localhost identified by 'root';
创建新库及用户
mysql> CREATE DATABASE hive charset utf8;
mysql> USE hive;
mysql> CREATE USER 'hive'@'localhost' IDENTIFIED BY 'hive';
mysql> GRANT ALL ON hive.* TO 'hive'@'localhost' IDENTIFIED BY 'hive';
mysql> GRANT ALL ON hive.* TO 'hive'@'%' IDENTIFIED BY 'hive';
mysql> FLUSH PRIVILEGES;
mysql> quit;