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: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 KaTeX parse error: Undefined control sequence: \* at position 42: …PRIVILEGES ON \̲*̲.\* TO 'root'@'…mysql_password’;flush privileges;"
mysql -u mysql_user−e"updatemysql.usersetauthentication_string=password(′mysql\_user -e "update mysql.user set authentication\_string=password('mysql_user−e"updatemysql.usersetauthentication_string=password(′mysql_password’)
where user=‘root’ and host=‘localhost’;flush privileges;"
3. 重新初始化数据库
需要预创建的数据库重新创建,比如初始化scm库
scm_prepare_database.sh mysql scm scm xxx
openEuler 是由开放原子开源基金会孵化的全场景开源操作系统项目,面向数字基础设施四大核心场景(服务器、云计算、边缘计算、嵌入式),全面支持 ARM、x86、RISC-V、loongArch、PowerPC、SW-64 等多样性计算架构
更多推荐
所有评论(0)