#检查系统自带数据库
rpm -qa|grep mariadb
#删除自带数据库
rpm -e --nodeps mariadb-libs
#安装数据库
yum -y install mariadb mariadb-server
#启动数据库
systemctl start mariadb
#登录数据库,密码为空
mysql -u root -p
#调制可以远程访问
grant all privileges on *.* to 'root'@'%' identified by 'vicbaily528@163' with grant option;
#刷新
flush privileges;
#初始化数据库
mysql_secure_installation
# 下面的步骤视情况而定
# 检查是否放开3306端口
firewall-cmd --query-port=3306/tcp
# 开通3306端口
firewall-cmd --permanent --add-port=3306/tcp
#重启防火墙
firewall-cmd --reload
Docker安装
# 下载镜像
docker pull mysql:5.7
# 运行容器
docker run -p 3306:3306 --name mysql \
-v /mydata/mysql/log:/var/log/mysql \
-v /mydata/mysql/data:/var/lib/mysql \
-v /mydata/mysql/conf:/etc/mysql \
-e MYSQL_ROOT_PASSWORD=root \
-d mysql:5.7
# -p 3306:3306: 将容器的 3306 端口映射到主机的 3306 端口
# -v /mydata/mysql/conf:/etc/mysql: 将配置文件夹挂载到主机
# -v /mydata/mysql/log:/var/log/mysql: 将日志文件夹挂载到主机
# -v /mydata/mysql/data:/var/lib/mysql/: 将配置文件夹挂载到主机
# -e MYSQL_ROOT_PASSWORD=root: 初始化 root 用户的密码
# MySQL 配置
vi /mydata/mysql/conf/my.cnf
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
skip-name-resolve
# 尝试登录容器
docker exec -it mysql mysql -uroot -proot
# 设置 root 远程访问
grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;
flush privileges;