#!/usr/bin/env bash USER=”” PASSWORD=”” OUTPUTDIR=”” DAYS_TO_KEEP=60 databases=`mysql -u$USER -p$PASSWORD -e “SHOW DATABASES;” | tr -d “| ” | grep -v Database` cd $OUTPUTDIR for db in $databases; do if [[ “$db” != “information_schema” ]] && [[ “$db” != “performance_schema” ]] && [[ “$db” != “mysql” ]] && [[ “$db” != _* ]] ; then echo […]
|
||||||
|
How to install Fail2ban in rhel 6 & 7 What is fail2ban? Fail2ban works by scanning and monitoring log files for selected entries then bans IPs that show the malicious signs like too many password failures, seeking for exploits, etc. 1. Install Fail2Ban For RHEL 6 rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm For RHEL 7 rpm -Uvh […] The company intends to replace http with https in the Ngxin environment. It requires http to force a jump to https. This search on the Internet, the basic summary Configure rewrite ^(.*)$ https://$host$1 permanent; Or in the server configuration return 301 https://$server_name$request_uri; Or in the server with if, here refers to the need to configure […] ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. Create a user in Mysql in linux login to mysql as a root mysql -u root -p now create user with following command CREATE USER ‘testdb’@’localhost’ IDENTIFIED BY ‘test123’; if you got error like below. then you have to […] This problem is a little tricky, there are possible fixes that MySQL website has stated. Sad to say, the one’s I read in the forum and site didn’t fix my problem. What I encountered was that the relay-bin from my MySQL slave server has already been ‘rotated’, meaning deleted from the folder. This happens when […] |
||||||
|
Copyright © 2024 - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
Recent Comments