在腾讯云服务器上安装Mysql

1.第一步，安装前，我们可以检测系统是否自带安装 MySQL
命令
rpm -qa | grep mysql

2.第二步，下载mysql.rpm源
命令
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

3.第三步,安装mysql源
命令
sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm

5.第四步，安装mysql
命令
sudo yum install mysql-server

6.查看版本号
命令
mysql -V

7.运行Mysql
命令
service mysqld start

8.查看Mysql是否运行
命令
service mysqld status

10.修改密码
命令
mysql -u root
alter user ‘root’@’%’ identified by ‘passwrod’;
flush privileges;

11.设置密码永不过期
命令
ALTER USER ‘root’@’%’ PASSWORD EXPIRE NEVER;
flush privileges;

13.设置允许外部远程访问
命令
mysql> use mysql;
mysql> select user,host from user;
如果没有”%”这个host值,就执行下面这两句:
mysql> update user set host=’%’ where user=‘root’;
mysql> flush privileges;
mysql> alter user ‘root’@’%’ identified with mysql_native_password by ‘root’;
mysql> flush privileges;
exit;

14.设置开启自启动
命令
systemctl enable mysqld
systemctl daemon-reload