开心六月综合激情婷婷|欧美精品成人动漫二区|国产中文字幕综合色|亚洲人在线成视频

----------------------------------------------

使用root登錄

1.確保服務(wù)器系統(tǒng)處于最新?tīng)顟B(tài)

[root@localhost ~]# yum -y update

如果顯示以下內(nèi)容說(shuō)明已經(jīng)更新完成

Replaced:

  grub2.x86_64 1:2.02-0.64.el7.centos   grub2-tools.x86_64 1:2.02-0.64.el7.centos

Complete!

2.重啟服務(wù)器

[root@localhost ~]# reboot

3.首先檢查是否已經(jīng)安裝，如果已經(jīng)安裝先刪除以前版本，以免安裝不成功

[root@localhost ~]# php -v

或

[root@localhost ~]# rpm -qa | gerp mysql

或

[root@localhost ~]# yum list installed | grep mysql

如果顯示以下內(nèi)容說(shuō)明沒(méi)有安裝服務(wù)

-bash: gerp: command not found

4.下載MySql安裝包

[root@localhost ~]# rpm -ivh http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

或

[root@localhost ~]# rpm -ivh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

5.安裝MySql

[root@localhost ~]# yum install -y mysql-server

或

[root@localhost ~]# yum install mysql-community-server

如果顯示以下內(nèi)容說(shuō)明安裝成功

Complete!

6.設(shè)置開(kāi)機(jī)啟動(dòng)Mysql

[root@localhost ~]# systemctl enable mysqld.service

7.檢查是否已經(jīng)安裝了開(kāi)機(jī)自動(dòng)啟動(dòng)

[root@localhost ~]# systemctl list-unit-files | grep mysqld

如果顯示以下內(nèi)容說(shuō)明已經(jīng)完成自動(dòng)啟動(dòng)安裝

mysqld.service                                enabled

8.設(shè)置開(kāi)啟服務(wù)

[root@localhost ~]# systemctl start mysqld.service

9.查看MySql默認(rèn)密碼

[root@localhost ~]# grep 'temporary password' /var/log/mysqld.log

10.登陸MySql，輸入用戶名和密碼

[root@localhost ~]# mysql -uroot -p

11.修改當(dāng)前用戶密碼

mysql>SET PASSWORD = PASSWORD('Abc123!_');

12.開(kāi)啟遠(yuǎn)程登錄，授權(quán)root遠(yuǎn)程登錄

mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'a123456!' WITH GRANT OPTION;

13.命令立即執(zhí)行生效

mysql>flush privileges;

---------------------------------------------------------------------

其他功能:

# 檢查并且顯示Apache相關(guān)安裝包

[root@localhost ~]# rpm -qa | grep mysql

# 刪除MySql

[root@localhost ~]# yum remove -y mysql mysql mysql-server mysql-libs compat-mysql51

或

[root@localhost ~]# rpm -e mysql-community-libs-5.7.20-1.el7.x86_64 --nodeps

或

[root@localhost ~]# yum -y remove mysql-community-libs-5.7.20-1.el7.x86_64

# 查看MySql相關(guān)文件

[root@localhost ~]# find / -name mysql

# 重啟MySql服務(wù)

[root@localhost ~]# service mysqld restart

# 查看MySql版本

[root@localhost ~]# yum repolist all | grep mysql

# 查看當(dāng)前的啟動(dòng)的 MySQL 版本

[root@localhost ~]# yum repolist enabled | grep mysql

# 通過(guò)Yum來(lái)安裝MySQL,會(huì)自動(dòng)處理MySQL與其他組件的依賴(lài)關(guān)系

[root@localhost ~]# yum install mysql-community-server 

# 查看MySQL安裝目錄

[root@localhost ~]# whereis mysql

# 啟動(dòng)MySQL服務(wù)

[root@localhost ~]# systemctl start mysqld

# 查看MySQL服務(wù)狀態(tài)

[root@localhost ~]# systemctl status mysqld

# 關(guān)閉MySQL服務(wù)

[root@localhost ~]# systemctl stop mysqld

# 測(cè)試MySQL是否安裝成功

[root@localhost ~]# mysql

# 查看MySql默認(rèn)密碼

[root@localhost ~]# grep 'temporary password' /var/log/mysqld.log

# 查看所有數(shù)據(jù)庫(kù)

mysql>show databases;

# 退出登錄數(shù)據(jù)庫(kù)

mysql>exit;

# 查看所有數(shù)據(jù)庫(kù)用戶

mysql>SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;