后端开发自己遇到的坑

1、配置防火墙,开启80端口、3306端口
vi /etc/sysconfig/iptables
-A INPUT -m state —state NEW -m tcp -p tcp —dport 80 -j ACCEPT #允许80端口通过防火墙
-A INPUT -m state —state NEW -m tcp -p tcp —dport 3306 -j ACCEPT #允许3306端口通过防火墙

或者
iptables -I INPUT -p tcp —dport 80 -j ACCEPT

备注:很多人把这两条规则添加到防火墙配置的最后一行,导致防火墙启动失败,正确的应该是添加到默认的22端口这条规则的下面

——————————————————————————————————————————————————————————————————————

# Firewall configuration written by system-config-firewall
# Manual customization of this file is not recommended.
*filter
:INPUT ACCEPT [0:0]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [0:0]
-A INPUT -m state —state ESTABLISHED,RELATED -j ACCEPT
-A INPUT -p icmp -j ACCEPT
-A INPUT -i lo -j ACCEPT
-A INPUT -m state —state NEW -m tcp -p tcp —dport 22 -j ACCEPT
-A INPUT -m state —state NEW -m tcp -p tcp —dport 80 -j ACCEPT
-A INPUT -m state —state NEW -m tcp -p tcp —dport 3306 -j ACCEPT
-A INPUT -m state —state NEW -m tcp -p tcp —dport 443 -j ACCEPT
-A INPUT -j REJECT —reject-with icmp-host-prohibited
-A FORWARD -j REJECT —reject-with icmp-host-prohibited
COMMIT

1、安装Apache
yum install httpd #根据提示,输入Y安装即可成功安装

/etc/init.d/httpd start #启动Apache

2、安装MySQL
yum install mysql mysql-server #询问是否要安装,输入Y即可自动安装,直到安装完成
/etc/init.d/mysqld start #启动MySQL
chkconfig mysqld on #设为开机启动
cp /usr/share/mysql/my-medium.cnf /etc/my.cnf #拷贝配置文件(注意:如果/etc目录下面默认有一个my.cnf,直接覆盖即可)

设置数据库密码:


mysql -uroot -p 直接回车
use mysql;
update user SET password=PASSWORD("root123") where user='root';
flush privileges;
exit;

$ wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
2. 安装mysql-community-release-el7-5.noarch.rpm包

$ sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
安装这个包后,会获得两个mysql的yum repo源:
/etc/yum.repos.d/mysql-community.repo
/etc/yum.repos.d/mysql-community-source.repo
3. 安装mysql

$ sudo yum install mysql-server
根据步骤安装就可以了,不过安装完成后,没有密码,需要重置密码。

4. 重置密码

重置密码前,首先要登录


$ mysql -u root
登录时有可能报这样的错:ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (2),原因是/var/lib/mysql的访问权限问题。下面的命令把/var/lib/mysql的拥有者改为当前用户:

$ sudo chown -R openscanner:openscanner /var/lib/mysql
然后,重启服务:

$ service mysqld restart
//权限问题
//给joe,主机为localhost分配所有权限(超级权限)
grant all privileges on *.* to joe@localhost identified by '1'
grant select,insert,update,delete,create,drop on vtdc.employee to joe@10.163.225.87 identified by ‘123′;
//刷新权限列表
flush privileges;

接下来登录重置密码:

$ mysql -u root
mysql > use mysql;
mysql > update user set password=password(‘123456‘) where user=‘root‘;
mysql > exit;
5. 开放3306端口

$ sudo vim /etc/sysconfig/iptables
添加以下内容:

-A INPUT -p tcp -m state ——————————————————————————————————————————————————————————————————————state NEW -m tcp ——————————————————————————————————————————————————————————————————————dport 3306 -j ACCEPT
保存后重启防火墙:

$ sudo service iptables restart


3、安装PHP5
3.1、安装PHP5
yum install php
根据提示输入Y直到安装完成

3.2、安装PHP组件,使 PHP5 支持 MySQL
yum install php-mysql php-gd libjpeg* php-imap php-ldap php-odbc php-pear php-xml php-xmlrpc php-mbstring php-mcrypt php-bcmath php-mhash libmcrypt
这里选择以上安装包进行安装,根据提示输入Y回车
/etc/init.d/mysqld restart #重启MySql
/etc/init.d/httpd restart #重启Apche


提示:查询各个软件的安装位置

rpm -ql httpd

rpm -ql mysql


rpm -ql php

1.默认 yum 仓库无法直接安装nginx,需要创建一个文件 /etc/yum.repos.d/nginx.repo,并将下面的内容复制进去:
[nginx]
name=nginx repo
baseurl=http://nginx.org/packages/centos/$releasever/$basearch/
gpgcheck=0
enabled=1

2.编辑并保存/etc/yum.repos.d/nginx.repo文件后,在命令行下执行
[root@localhost ~]# yum list | grep nginx
nginx.x86_64 1.8.0-1.el6.ngx nginx
nginx-debug.x86_64 1.8.0-1.el6.ngx nginx
nginx-debuginfo.x86_64 1.8.0-1.el6.ngx nginx
nginx-nr-agent.noarch 2.0.0-8.el6.ngx nginx

安装:yum -y install nginx

php和mysql单独安装之后是无法进行关联的,但是可以通过安装php-mysql软件来进行实现(可能需要对php-fpm程序进行重启操作)

原文地址:https://www.cnblogs.com/xilanglang/p/6370254.html