How to install mysql and php on Centos7

This article mainly shares with you how to install mysql and php on Centos7. I hope it can help you.

Recommended related mysql video tutorials: "mysql tutorial"

Official website download and install mysql-server

Use the following three commands in sequence to install

wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpmrpm -ivh mysql-community-release-el7-5.noarch.rpm
yum install mysql-community-server

The installation process is as shown below

##Use after successful installation

systemctl start mysql Command to start mysql

As can be seen from the above figure, the initial installation of mysql root account does not have a password

Let’s do it next

Set the root account password Use the command set password for 'root'@'localhost' =password('password');

As shown below, we set the root account password In order to 123456 and log in successfully

Set up mysql remote connection

Give all database permissions to the root account

grant all privileges on *.* to root@'%'identified by 'password';

If it is a new user instead of root, you must first create a new user

create user 'username'@'%' identified by 'password';

Refresh privileges

flush privileges;

This way Our mysql database is configured and you can also connect remotely

---

Download php7

• Install php7

rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpmrpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm

• Use yum command to install php7

yum install php70w.x86_64 php70w-cli.x86_64 php70w-common.x86_64 php70w-gd.x86_64 php70w-ldap.x86_64 php70w-mbstring.x86_64 php70w-mcrypt.x86_64 php70w-mysql.x86_64 php70w-pdo.x86_64

##Install php -fpm and start

• yum install php70w-fpm php70w-opcache

Start php-fpm

systemctl start php-fpm

Test whether php and php-fpm Installation successful
Create a new index.php in the nginx root directory with the following content

Visit you The web server appears as shown below and the installation is successful

Official website download and install mysql-server

Use the following three commands in sequence to install

wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpmrpm -ivh mysql-community-release-el7-5.noarch.rpm
yum install mysql-community-server

The installation process is as shown below

##After successful installation, use systemctl start mysql

Command to start mysql

As can be seen from the above figure, the initial installation of mysql root account does not have a password

Let’s set the root account password

Use the command

set password for 'root'@'localhost' =password('password');

As shown below, we set the root account password to 123456 and logged in successfully

Set up mysql remote connection

Give all database permissions to the root account

grant all privileges on *.* to root@'%'identified by 'password';

如果是新用户而不是root 则要先新建用户

create user 'username'@'%' identified by 'password';

刷新权限 flush privileges;

这样我们的mysql 数据库就配置好了 还可以远程连接

---

下载php7

• 安装php7

rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpmrpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm

• 使用yum命令安装php7

yum install php70w.x86_64 php70w-cli.x86_64 php70w-common.x86_64 php70w-gd.x86_64 php70w-ldap.x86_64 php70w-mbstring.x86_64 php70w-mcrypt.x86_64 php70w-mysql.x86_64 php70w-pdo.x86_64

• 安装php-fpm 并启动

yum install php70w-fpm php70w-opcache

启动php-fpm

systemctl start php-fpm

• 测试php和php-fpm是否安装成功

在 nginx 根目录 新建index.php 内容如下

访问你的web服务器  出现下图 即安装成功

相关推荐：

Linux学习第三篇之Centos7安装mysql5.7.16数据库的详细介绍

详细介绍CentOS7安装Mysql并设置开机自启动的方法

gcc-centos7安装mysql workbench 依赖检测失败

The above is the detailed content of How to install mysql and php on Centos7. For more information, please follow other related articles on the PHP Chinese website!