【运维案例】openEuler mariaDB替换为mysql

1.卸载原来的数据库

1.1 查询所安装的MariaDB组件:

[root@localhost logs]# rpm -qa | grep Maria*

MariaDB-server-5.5.49-1.el7.centos.x86_64

MariaDB-common-5.5.49-1.el7.centos.x86_64

MariaDB-client-5.5.49-1.el7.centos.x86_64

1.2 卸载数据库:

[root@localhost logs]# yum -y remove mari*

1.3 删除数据库文件:

[root@localhost logs]# rm -rf /var/lib/mysql/*

2. 安装mysql5.7

2.1 下载解压Mysql

```

wget https://obs.cn-north-4.myhuaweicloud.com/obs-mirror-ftp4/database/mysql-5.7.27-aarch64.tar.gz

tar xvf mysql-5.7.27-aarch64.tar.gz

mv /usr/local/mysql-5.7.27-aarch64 /usr/local/mysql

```

2.2 创建相关依赖

```

mkdir -p /usr/local/mysql/logs //创建logs目录

ln -sf /usr/local/mysql/my.cnf /etc/my.cnf

cp -rf /usr/local/mysql/extra/lib* /usr/lib64/

mv /usr/lib64/libstdc++.so.6 /usr/lib64/libstdc++.so.6.old

ln -s /usr/lib64/libstdc++.so.6.0.24 /usr/lib64/libstdc++.so.6

```

2.3 创建mysql组

```

groupadd mysql

useradd -g mysql mysql

chown -R mysql:mysql /usr/local/mysql

```

2.4 设置开机启动

```

cp -rf /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

chmod +x /etc/init.d/mysqld

systemctl enable mysqld

```

2.5 添加环境变量

/etc/profile添加下面两行代码:

```

export MYSQL_HOME=/usr/local/mysql

export PATH=$PATH:$MYSQL_HOME/bin

```

source /etc/profile

2.6 启动mysql

初始化mysql

mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data





开启mysql

systemctl start mysqld





查看状态

systemctl status mysqld

2.7 修改密码

mysql -u $mysql_user -e "GRANT ALL PRIVILEGES ON  *.* TO 'root'@'%' IDENTIFIED BY '$mysql_password';flush privileges;"

mysql -u $mysql_user -e "update mysql.user set authentication_string=password('$mysql_password') where user='root' and host='localhost';flush privileges;"

3. 重新初始化数据库

需要预创建的数据库重新创建,比如初始化scm库

scm_prepare_database.sh mysql scm scm xxx
1 个赞

yum源里mysql。但是有几个坑。之前刚用,systemctl start mysqld启动命令就不对。。。