:::: gangserver's blog ::::

Python 3: $ sudo apt install idle3 Python 2: $ sudo apt install idle-python2.7 IDLE execute $ idle or (background running) $ idle &

1. python library list backup $ pip freeze > requirement.txt 2. python library reinstall $ pip install -r requirement.txt

1. Python 64bit install(Check [V] Add Python 3.9 to PATH option) * Python 64bint version : 3.9.4 (ex, C:\Dev\Python\Python39) 2. Python 32bit install(Uncheck [ ] Add Python 3.9 to PATH option) * Python 32bit version : 3.9.2 (ex, C:\Dev\Python\python39-32) 3. Python version C:\Dev> python --version (or python -V) Python 3.9.4 mkdir venv 4. Virtual environment directory move C:\Dev> cd venv 5. com..

1. 방법1 GRANT ALL PRIVILEGES ON *.* TO '아이디'@'%' IDENTIFIED BY '비밀번호'; FLUSH PRIVILEGES; 2. 방법2 INSERT INTO mysql.user (host,user,authentication_string,ssl_cipher, x509_issuer, x509_subject) VALUES ('%','아이디',password('패스워드'),'','',''); GRANT ALL PRIVILEGES ON *.* TO '아이디'@'%'; FLUSH PRIVILEGES;

$ sudo mariadb -u root 로 비번없이 root 로그인 가능 $ sudo mysql_secure_installation 명령으로 root 비번 변경 후 사용 ---------------------------------------------------------------------------------------------------------------------- user@localhost:~$ sudo mysql_secure_installation [sudo] user의 암호: NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB SERVERS IN PRODUCTION USE! PLEASE READ EACH STE..

$ sudo apt-get install software-properties-common dirmngr apt-transport-https $ sudo apt-key adv --fetch-keys 'https://mariadb.org/mariadb_release_signing_key.asc' $ sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] https://mirror.yongbok.net/mariadb/repo/10.5/ubuntu focal main' $ sudo apt update $ sudo apt install mariadb-server

1. /etc/yum.repos.d/MariaDB.repo file create ----------------------------------------------------------------------------------------------------- # MariaDB 10.5 CentOS repository list - created 2021-04-15 02:51 UTC # https://mariadb.org/download/ [mariadb] name = MariaDB baseurl = https://mirror.yongbok.net/mariadb/yum/10.5/centos7-amd64 gpgkey=https://mirror.yongbok.net/mariadb/yum/RPM-GPG-KEY..