[LINUX] Various commands for building an environment with Apache

File related

-Transfer files (folders) from the local environment to the remote environment

Terminal


$ scp -r File name you want to send root@hostname:Remote directory you want to send (Ex.)/home/www)

・ Confirmation of file owner authority, etc.

Console


$ ls -l File name you want to check

-When you want to check the permissions of all files in the directory

Console


After moving to the directory you want to check
$ ll

-File owner authority settings, etc.

Console


$ chown -R owner:Group owner file name

Change the owner setting for the entire directory by adding -R

-When opening a file with vi, the characters are garbled and Japanese is not displayed.

Console


:set enc=utf-8

-When you want to check the latest error log when checking the log with vi

Console


:$

-Check the Apache error log

Console


$ cd /
$ vi /var/log/httpd/error_log

Commands related to MySQL

-Commands related to setting the security level of the password required when creating a user with MySQL

Console


-> global validate_password_policy="LOW or MEDIUM or HIGH"

-A command to display a list of password security levels in MySQL

Console


-> show global variables like '%validates%';

・ Check the status of MySQL

Console


$ systemctl status mysqld.service

・ MySQL log

Console


$ cd /
$ cat /var/log/mysql/mysqld.log

・ MySQL user list

Console


-> SELECT user, host from mysql.user

・ MySQL user creation

Console


-> create user 'username'@'hostname' identified by 'password';

-Delete MySQL user

Console


-> drop user 'username'@'hostname';

-Grant all permissions to a specific user

Console


->grant all privileges on database name.* to 'username'@'hostname';

-Reflecting changes made in MySQL

Console


-> FLUSH PRIVILEGES;

Recommended Posts

Various commands for building an environment with Apache
Building an Anaconda environment for Python with pyenv
Try building an environment for MayaPython with VisualStudioCode
Building an environment for natural language processing with Python
[Python] Building an environment with Anaconda [Mac]
Building an environment for "Tello_Video" on Raspbian
Building an environment for "Tello_Video" on Windows
Create an environment for Django x Apache x mod_wsgi with Vagrant (Ubuntu 16.04)
Building an environment for executing Python scripts (for mac)
Building an environment for matplotlib + cartopy on Mac
Commands for creating a python3 environment with virtualenv
Notes from installing Homebrew to building an Anaconda environment for Python with pyenv
Building an environment for "Tello_Video" on Mac OS X
[Linux] WSL2 Build an environment for laravel7 with Ubuntu 20.04
Building an environment for displaying organic compounds using RDKit
Create an environment for test automation with AirtestIDE (Tips)
Building an environment to use CaboCha with google colaboratory
Create an environment with virtualenv
[Python] Building an environment for competitive programming with Atom (input () can be used!) [Mac]
Let's get started with Python ~ Building an environment on Windows 10 ~
Create an environment for "Deep Learning from scratch" with Docker
Building a kubernetes environment with ansible 2
Django beginners tried building an environment
Building a virtual environment with Python 3
Created an environment for Anaconda & Jupyter
Commands for creating SNS with Django
Building a kubernetes environment with ansible 1
Building a Windows 7 environment for getting started with machine learning with Python
[Pyenv] Building a python environment with ubuntu 16.04
Building a Python3 environment with Amazon Linux2
Build an environment for Blender built-in Python
Procedure for building a kube environment on amazon linux2 (aws) ~ (with bonus)
[Definitive Edition] Building an environment for learning "machine learning" using Python on Mac
Note when creating an environment with python
Commands that were important when building the Laravel environment in the Apache environment (Note)
Building a Python 3.6 environment with Windows + PowerShell
[Mac] Building a virtual environment for Python
Crawl Follower for an account with Instagram
Building a conda environment for ROS users
Building a Python development environment for AI development
Building an AWS Fargate Service with AWS CDK
Creating an environment for OSS-DB Silver # 1_Create a Linux environment (CentOS7 virtual environment) with VirtualBox/Vagrant
Building an environment to comply with the Python coding standard (PEP8) with Eclipse + PyDev
Selenium + WebDriver (Chrome) + Python | Building environment for scraping
For beginners to build an Anaconda environment. (Memo)
Create execution environment for each language with boot2docker
Building a python environment with virtualenv and direnv
Building an environment that uses Python in Eclipse
Building a Python environment with WLS2 + Anaconda + PyCharm
Image Processing with Python Environment Setup for Windows
Introduction to Python "Re" 1 Building an execution environment
I get an error with all yum commands
[Building a CI environment in 2 hours] Procedure for building a Python Web server with CircleCI and passing an HTTP communication test
Procedure when building Ubuntu as a virtual environment with Vagrant + Virtualbox for LPIC Level 1.
Various Linux commands
I tried to build an environment for machine learning with Python (Mac OS X)
Building a Python environment for pyenv, pyenv-virtualenv, Anaconda (Miniconda)
Build an interactive environment for machine learning in Python
Recommendation of building a portable Python environment with conda
Building a Docker working environment for R and Python
Run with CentOS7 + Apache2.4 + Python3.6 for the time being