'LINUX'에 해당되는 글 258건

<Location />

    Order Deny,Allow

    Deny from all

    Allow from 127.0.0.1 ::1 192.168.1.1

</Location>

<Directory /var/www/html>

    Order Deny,Allow

    Deny from all

    Allow from 127.0.0.1 ::1 192.168.1.1

</Directory>

<Location />

    Order Allow,Deny

    Allow from all

    Deny from 192.168.1.1

</Location>

<Directory /var/www/html/secret>

    AuthName "Secret Page!"

    AuthType Basic

    AuthUserFile /var/www/auth/.htpasswd

    AuthGroupFile /dev/null

    require valid-user

# htpasswd -bc /var/www/auth/.htpasswd 아이디 비밀번호

mysql -uroot -p비밀번호 mysql -e "create database example"

mysql -uroot -p비밀번호 mysql -e "GRANT ALL PRIVILEGES on example.* to 'example'@'localhost' identified by '유저비밀번호'"

mysql -uroot -p비밀번호 mysql -e "GRANT ALL PRIVILEGES on example.* to 'example'@'%' identified by '유저비밀번호'"

create database example;

GRANT ALL PRIVILEGES on example.* to 'example'@'localhost' identified by '유저비밀번호';

GRANT ALL PRIVILEGES on example.* to 'example'@'%' identified by '유저비밀번호';

mysql -uroot -p비밀번호 mysql -e "drop user 'example'@'%'"

mysql -uroot -p비밀번호 mysql -e "drop user 'example'@'localhost'"

mysql -uroot -p비밀번호 mysql -e "drop database example"

drop user 'example'@'%';

drop user 'example'@'localhost';

drop database example;

[mysqld]

port=33306

# systemctl restart mariadb.service

[root@conoha-jp ~]# firewall-cmd --permanent --zone=public --add-port=33306/tcp

success

[root@conoha-jp ~]# firewall-cmd --reload

success

[root@conoha-jp ~]# firewall-cmd --list-all

public (active)

  target: default

  icmp-block-inversion: no

  interfaces: eth0

  sources:

  services: dhcpv6-client ftp http https mysql ssh

  ports: 33306/tcp

  protocols:

  masquerade: no

  forward-ports:

  sourceports:

  icmp-blocks:

  rich rules:

# mysqldump -u유저아이디 -p비밀번호 dbname table_* > backup.sql

mysqldump: Couldn't find table: "table_*"

# mysqldump -u유저아이디 -p비밀번호 dbname $(mysql -u유저아이디 -p비밀번호 dbname -Bse "show tables like 'test_%'") > backup.sql

# mysql -u유저아이디 -p비밀번호 dbname -Bse "show tables like 'test_%'"

# iptables -I INPUT -p tcp --dport 3306 -j DROP

# iptables -I INPUT -s 127.0.0.1 -p tcp --dport 3306 -j ACCEPT

# service iptables save

[root@vps log]# iptables -L | grep mysql

ACCEPT     tcp  --  localhost.localdomain  anywhere            tcp dpt:mysql

DROP       tcp  --  anywhere             anywhere            tcp dpt:mysql

[root@conoha-jp ~]# mysql -hexample.com -uroot

ERROR 2003 (HY000): Can't connect to MySQL server on 'example.com' (110)

[mysqld]

log-bin=mysql-bin

expire_logs_days=7

long_query_time=3

slow_query_log=1

slow_query_log_file=slow-query.log

# mysql -u유저아이디 -p비밀번호 -e "PURGE MASTER LOGS BEFORE '2016-12-31 23:59:59'"

# mysql -u유저아이디 -p비밀번호 -e "PURGE MASTER LOGS BEFORE DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY)"

# cp /dev/null /var/lib/mysql/slow-query.log

cp: overwrite `/var/lib/mysql/slow-query.log'? y

# iptables -I INPUT -p tcp -s 허용아이피 --dport 포트번호 -j ACCEPT

# iptables -I INPUT -p tcp --dport 포트번호 -j DROP

# iptables -L

# iptables -D INPUT -p tcp -s 허용아이피 --dport 포트번호 -j ACCEPT

[root@vps bin]# iptables -I INPUT -p tcp -s 192.168.1.100 --dport 3306 -j ACCEPT

[root@vps bin]# iptables -L | grep mysql

ACCEPT     tcp  --  192.168.1.100        anywhere            tcp dpt:mysql

[root@vps bin]# iptables -D INPUT -p tcp -s 192.168.1.100 --dport 3306 -j ACCEPT

[root@vps bin]# iptables -L | grep mysql

pasv_enable=YES

pasv_min_port=50001

pasv_max_port=50040

<<Directory "/var/www/html">

    #AllowOverride None

    AllowOverride FileInfo AuthConfig Limit

</Directory>

RewriteEngine On

RewriteCond %{HTTP_HOST} ^www\.ivps\.kr$ [NC]

RewriteCond %{SERVER_PORT} !^443$

RewriteRule ^(.*)$ https://www.ivps.kr%{REQUEST_URI} [R=301,L]

<VirtualHost conoha.ivps.kr:443>

    SSLEngine on

    SSLCertificateFile /etc/letsencrypt/live/conoha.ivps.kr/cert.pem

    SSLCertificateKeyFile /etc/letsencrypt/live/conoha.ivps.kr/privkey.pem

    SSLCertificateChainFile /etc/letsencrypt/live/conoha.ivps.kr/fullchain.pem

    ServerName conoha.ivps.kr

    DocumentRoot /var/www/html

    ErrorLog logs/conoha.ivps.kr_error_log

    CustomLog logs/conoha.ivps.kr_access_log common

</VirtualHost>

# yum install mod_ssl