MySQL的安装及启动

myslq安装

1.查看Maria DB数据库并卸载掉

rpm -qa | grep mariadb

sudo rpm -e --nodeps mariadb-libs-5.5.65-1.el7.x86_64

2.使用rpm安装 MySql：

sudo rpm -ivh /opt/hive/mysql-community-common-5.7.18-1.el7.x86_64.rpm

sudo rpm -ivh /opt/hive/mysql-community-libs-5.7.18-1.el7.x86_64.rpm

sudo rpm -ivh /opt/hive/mysql-community-client-5.7.18-1.el7.x86_64.rpm

sudo rpm -ivh /opt/hive/mysql-community-server-5.7.18-1.el7.x86_64.rpm

3.安装后rpm查看Mysql的安装情况并配置/etc/my.cnf文件

rpm -qa | grep mysql

vim /etc/my.cnf在文件中插入：

default-storage-engine=innodb

innodb_file_per_table

collation-server=utf8_general_ci

init-connect='SET NAMES utf8'

character-set-server=utf8

4.启动MySql服务并查看状态：

systemctl start mysqld

systemctl status mysqld

5.初始化成功后生成临时密码，查看密码并修改：

mysql_secure_installation修改密码

6.启动数据库

mysql -uroot -p密码、

https://blog.csdn.net/liuwkk/article/details/107991195