Centos7上安装mysql

1.确保服务器系统处于最新状态

[root@zhangdl_alicloud ~]# yum updateLoaded 
plugins: fastestmirrorDetermining fastest mirrors........Complete!
[root@zhangdl_alicloud ~]#

2.检查是否已经安装过

[root@zhangdl_alicloud ~]# rpm -qa | gerp mysql
-bash: gerp: command not found
[root@zhangdl_alicloud ~]# yum list installed | grep mysql
[root@zhangdl_alicloud ~]#

3.接下来，开始安装

[root@zhangdl_alicloud ~]# yum install mysql
[root@zhangdl_alicloud ~]# yum install mysql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
No package mysql-server available.
Error: Nothing to do

# 显示没有可用的包，使用wget 下载
[root@zhangdl_alicloud ~]# yum install wget   #先安装wget下载mysql的repo源
[root@zhangdl_alicloud ~]# wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm  #下载mysql的repo源
[root@zhangdl_alicloud ~]# rpm -ivh mysql-community-release-el7-5.noarch.rpm   #安装 mysql-community-release-el7-5.noarch.rpm包
# 重新执行命令
[root@zhangdl_alicloud ~]# yum install mysql-server

4.查看mysql状态

[root@zhangdl_alicloud ~]# systemctl status mysql
Redirecting to /bin/systemctl status mysqld.service
● mysqld.service - MySQL Community Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: inactive (dead)

# 启动mysql
[root@zhangdl_alicloud ~]# systemctl start mysql

5.登录

[root@zhangdl_alicloud ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.46 MySQL Community Server (GPL)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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


mysql>

6.修改密码

mysql> use mysql;  #使用mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> update user set password=password('新密码') where user ='root'; #修改密码
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4  Changed: 4  Warnings: 0
 
mysql> flush privileges;   #刷新权限
Query OK, 0 rows affected (0.00 sec)

7.授权远程登录

mysql>  GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

8.重启mysql

[root@zhangdl_alicloud ~]# systemctl restart mysql;