Linux系统安装MySQL

安装MySQL

1.查看安装的MariaDB列表

rpm -qa | grep mariadb

2.卸载所有安装的MariaDB(根据自己的MariaDB列表执行)

rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64
rpm -e --nodeps mariadb-5.5.68-1.el7.x86_64
rpm -e --nodeps mariadb-devel-5.5.68-1.el7.x86_64

3.再次查看安装的MariaDB列表，确保全部卸载

rpm -qa | grep mariadb

4.下载mysql的repo源

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

5.安装mysql-community-release-el7-5.noarch.rpm

sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm

6.安装mysql

sudo yum install mysql-server

7.启动mysql

service mysqld start

MySQL数据库基本操作

1.数据库密码设置

mysqladmin -u root -p password 'root'

2.创建数据库

create DATABASE ke;