[ centos学习 ] centos7安装mysql

centos7安装mysql

1.卸载本来的mysql

rpm -qa|grep mysql  //查找本机安的mysql
yum -y remove xxx  //卸所有mysql,xxx代表上个指令查询出来的

2.下载mysql的repo源

cd  /usr/local/src /
sudo wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm   //下载文件,这里是mysql5.6版本 可以自己下载需要的版本

3.安装mysql

sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm //安装的名字根下载的名字
sudo yum install mysql-community-server

安装完成后重启mysql服务

service mysqld restart

第一次安装没有密码,需要设置密码

mysql -u root //登陆
set password for 'root'@'localhost' =password('password'); //括号里是自己要设置的密码
exit//退出mysql
mysql -u root -p//使用设置的密码登陆

---

---

---

备注

CentOS 7 版本将MySQL数据库软件从默认的程序列表中移除了，无法使用

yum install mysql server 

进行安装. 有两种解决办法: 1. 安装mariadb(完全兼容MYSQL)

安装mariadb，输入安装命令

[root@localhost home]# yum install mariadb-server mariadb

mariadb数据库的相关命令是：

   systemctl start mariadb  #启动MariaDB

   systemctl stop mariadb  #停止MariaDB

   systemctl restart mariadb  #重启MariaDB

   systemctl enable mariadb  #设置开机启动

先启动数据库

  [root@yl-web yl]# systemctl start mariadb

默认无密码

[root@localhost lzh]# mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 6
Server version: 5.5.52-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

 
 

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.01 sec)

2. 按照上面教程下载安装

安装好MySQL会将mariadb覆盖