centos7安装mysql
下载仓库源(https://dev.mysql.com/downloads/repo/yum/):
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
安装
sudo yum localinstall mysql80-community-release-el7-3.noarch.rpm
查看mysql可用版本号
yum repolist all | grep mysql
禁用8.0:
sudo yum-config-manager --disable mysql80-community
允许5.7
sudo yum-config-manager --enable mysql57-community
安装mysql
sudo yum install mysql-community-server
启动mysql:
sudo service mysqld start
查看状态:
sudo service mysqld status
mysql操作
查看数据库默认初始密码:
sudo grep ‘temporary password’ /var/log/mysqld.log
登录:
mysql -uroot -plUMf,rktK4Y.
更改密码:
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘数据库密码’
远程连接:
use mysql
update user set host = ‘%’ where user =‘root’
flush privileges
安装nginx
创建nginx的yum仓库源
cd /etc/yum.repos.d/
cat >> nginx.repo
[nginx-stable]
name=nginx stable repo
baseurl=http://nginx.org/packages/centos/$releasever/$basearch/
gpgcheck=1
enabled=1
gpgkey=https://nginx.org/keys/nginx_signing.key
module_hotfixes=true
[nginx-mainline]
name=nginx mainline repo
baseurl=http://nginx.org/packages/mainline/centos/$releasever/$basearch/
gpgcheck=1
enabled=0
gpgkey=https://nginx.org/keys/nginx_signing.key
module_hotfixes=true
安装
sudo yum install nginx