This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
sudo apt-get update -y | |
sudo apt-get install python3.6 -y | |
sudo apt-get install software-properties-common -y | |
sudo add-apt-repository ppa:deadsnakes/ppa | |
sudo apt-get update -y | |
sudo apt-get install python3.6 -y | |
sudo apt install python3-pip -y | |
# go to /usr/bin and edit pip3 to point to 3.6 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
list all NFS ports: | |
rpcinfo -p | awk '{print $3" "$4}' | sort -k2n | uniq | |
#edit https://www.cyberciti.biz/faq/centos-fedora-rhel-iptables-open-nfs-server-ports/ | |
sudo firewall-cmd --zone=public --permanent --add-port=111/tcp | |
sudo firewall-cmd --zone=public --permanent --add-port=111/udp | |
sudo firewall-cmd --zone=public --permanent --add-port=2049/udp | |
sudo firewall-cmd --zone=public --permanent --add-port=2049/tcp |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# https://linuxhint.com/install_python3_centos7/ | |
# https://tecadmin.net/install-python-3-7-on-centos/ | |
# alt | |
cd /tmp | |
sudo yum groupinstall -y "Development Tools" | |
wget https://www.python.org/ftp/python/3.7.1/Python-3.7.1.tar.xz | |
tar -xJf Python-3.7.1.tar.xz | |
cd Python-3.7.1 | |
./configure | |
make |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
use `<< database name >>`; | |
SET FOREIGN_KEY_CHECKS = 0; | |
SET @tables = NULL; | |
SET GROUP_CONCAT_MAX_LEN=32768; | |
SELECT GROUP_CONCAT('`', table_schema, '`.`', table_name, '`') INTO @tables | |
FROM information_schema.tables | |
WHERE table_schema = (SELECT DATABASE()); | |
SELECT IFNULL(@tables, '') INTO @tables; |