Centos 安装 httpd+php+mariadb

1、安装httpd

yum install httpd

 

2、安装php

yum install php-mysql php-gd libjpeg* php-ldap php-odbc php-pear php-xml php-xmlrpc php-mbstring php-bcmath php-mhash php-cli php-fpm php-common php-devel

 

3、安装mariadb

# yum install mariadb-server mariadb-client

设置：

# mysql_secure_installation;

在mysql里执行

grant all privileges on *.* to 'root'@'%' identified by '密码' with grant option;

让刚刚修改的权限生效

flush privileges;

解决乱码：

vim /etc/my.cnf

#在[mysqld]增加

collation-server=utf8_general_ci

character-set-server=utf8

 

vim /etc/my.cnf.d/client.cnf

[client]
default-character-set=utf8

 

vim /etc/my.cnf.d/mysql-clients.cnf

[mysql]
default-character-set=utf8

 

vim /etc/my.cnf.d/server.cnf

[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci
 

 

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using passwor)

 

#vim /etc/my.cnf

[mysqld]

skip-grant-tables

 

 

4、防火墙设置

firewall-cmd --zone=public --add-port=80/tcp --permanent

firewall-cmd --permanent --zone=public --add-port=3306/tcp

firewall-cmd --permanent --zone=public --add-port=3306/udp

firewall-cmd --reload

firewall-cmd --list-all   查询、开放、关闭端口

firewall-cmd --query-port=8080/tcp 查询端口是否开放