linux install 할때 파티션
sda 8:0 0 1.8T 0 disk
├─sda1 8:1 0 600M 0 part /boot/efi
├─sda2 8:2 0 1G 0 part /boot
└─sda3 8:3 0 1.8T 0 part
├─cl-root 253:0 0 1.6T 0 lvm /
├─cl-swap 253:1 0 7.7G 0 lvm [SWAP]
└─cl-home 253:2 0 200G 0 lvm /home
yum -y install openssh-server openssh-clients openssh-askpass
systemctl start sshd.service
yum -y install mariadb-server mariadb
systemctl start mariadb.service
systemctl enable mariadb.service
yum -y install httpd
yum -y install php
yum -y install gd gd-devel
yum -y install libxml2 libxml2-devel
yum -y install openssl openssl-devel
yum -y install gmp gmp-devel
yum -y install mhash mhash-devel
yum -y install libmcrypt libmcrypt-devel
yum -y install mysql-server
yum -y install php-mysql
yum -y install php-devel
yum -y install php-gd
yum -y install php-mbstring
yum -y install php-mhash
yum -y install epel-release
yum -y update
yum -y install vsftpd
yum -y install php-pecl-ssh2.x86_64
yum groupinstall "GNOME Desktop Environment"
yum groupinstall "X Window System"
yum install java-11-openjdk-devel
java -version
service vsftpd start
systemctl enable vsftpd.service
systemctl stop firewalld
systemctl disable firewalld.service
systemctl start httpd.service
systemctl enable httpd.service
vi /etc/sysconfig/selinux
내용에서
SELINUX=enforcing 을 disabled 로 바꾼다.
저장
mysql_secure_installation
마리아 db의 root 비밀번호를 정하는것이 좋습니다. 아래의 phpMyAdmin 을 설치하고 실행시킬때는
비밀번호가 있어야 phpMyAdmin을 사용할수 있습니다.
service httpd restart
mysql설정
mysql -uroot -p mysql
Enter password: ni$$$$$$.
xe old db / xe new db 만들기
create database okchang0;
create database okchang1;
db확인
show databases;
id/pass 만들기: okchang0/ok8######8
create user 'okchang0'@localhost identified by 'ok8######8';
create user 'okchang1'@localhost identified by 'ok8######8';
추가명령
drop user '사용자ID'@localhost; // 사용자 삭제
delete from user where user = '사용자ID'; // 사용자 삭제
drop database DB명; // 데이터베이스 삭제
id확인
select host, user, password from user;
db와id연결
grant all privileges on okchang0.* to 'okchang0'@localhost identified by 'ok8#######8';
grant all privileges on okchang1.* to 'okchang1'@localhost identified by 'ok8#######8';
저장
flush privileges;
mount -t nfs 192.168.1.3:/volume1/data /mnt/nfs