netstat -tnlp

CentOS 7 방화벽 해제

# systemctl stop firewalld
# systemctl stop iptables
# systemctl stop ip6tables

# systemctl disable firewalld
# systemctl disable iptables
# systemctl disable ip6tables



iptables -I INPUT 1 -p tcp --dport 3306 -j ACCEPT
iptables -I OUTPUT 1 -p tcp --dport 3306 -j ACCEPT



/etc/my.cnf.d





CREATE TABLE `test_tb` (
    `sno` int(11) NOT NULL,
    `name` char(10) DEFAULT NULL,
    `det` char(20) DEFAULT NULL,
    `addr` char(80) DEFAULT NULL,
    `tel` char(20) DEFAULT NULL,
    PRIMARY KEY (`sno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


insert into test_tb set name='12';

show tables;

CREATE DATABASE goodswebdb;



CREATE USER 'goodsweb'@'localhost' IDENTIFIED BY '?????';
GRANT ALL PRIVILEGES ON goodswebdb.* TO 'goodsweb'@'localhost';



systemctl restart mariadb


저장소를 가져옴

wget -q -O - http://www.atomicorp.com/installers/atomic | sh
yum install php-mysqlnd
service mysql restart



php -i | grep 'Client API'


apt-get remove php5-mysql


apt-get update
apt-get install php5-mysqlnd


systemctl restart httpd
systemctl restart mariadb

systemctl stop httpd

systemctl restart mariadb



yum --skip-broken install




Error: php70w-common conflicts with php-common-5.4.16-48.el7.x86_64


y



rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
yum install php-mysqlnd




sudo yum remove php-common
sudo yum install php-mbstring



yum install php70w php70w-opcache


yum --skip-broken install

Error: php70w-common conflicts with php-common-5.4.16-48.el7.x86_64



rpm -Uvh http://mirror.innosol.asia/remi/enterprise/remi-release-7.rpm
yum install php70
yum install php70-php-mysqlnd php70-php-devel php70-php-gd php70-php-mcrypt php70-php-mbstring php70-php-pear php70-php-pecl-imagick php70-php-pecl-zip


yum install --skip-broken php-soap
yum remove php*
yum install php-soap






yum install scl-utils
yum install https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
yum install http://rpms.remirepo.net/enterprise/remi-release-7.rpm
yum install php70
yum install php70-php-mysqlnd
yum install php70-php-curl
yum install php70-php-simplexml
yum install php70-php-devel php70-php-gd php70-php-json php70-php-mcrypt php70-php-mbstring php70-php-opcache php70-php-pear php70-php-pecl-apcu php70-php-pecl-geoip php70-php-pecl-imagick php70-php-pecl-json-post php70-php-pecl-memcache php70-php-pecl-xmldiff php70-php-pecl-zip php70-php-pspell php70-php-soap php70-php-tidy php70-php-xml php70-php-xmlrpc



yum --enablerepo=remi-safe install php71 php71-php-mcrypt php71-php-devel php71-php-mbstring php71-php-mysqli php71-php-soap php71-php-xml php71-php-pecl-igbinary php71-php-pecl-ip2location php71-php-pecl-redis4 php71-php-intl php71-php-enchant php71-php-embedded php71-php-bcmath php71-php-process php71-php-mysql php71-php-json php71-php-dba php71-php-dbg php71-php-gd



yum install php70w-pearl php70w-devel