CentOS에 Java & MySQL 설치 및 기본 셋팅

Java

# wget --no-cookies --no-check-certificate --header "Cookie: gpw_e24=http%3A%2F%2Fwww.oracle.com%2F; oraclelicense=accept-securebackup-cookie" "http://download.oracle.com/otn-pub/java/jdk/8u51-b16/jdk-8u51-linux-x64.tar.gz"

# tar xf jdk-8u51-linux-x64.tar.gz -C /usr/local/

# chown -R root. /usr/local/jdk1.8.0_51/

// 맨 아래 추가

# vi ~/.bash_profile

export JAVA_HOME=/usr/local/jdk1.8.0_51

export PATH=$PATH:$JAVA_HOME/bin

# source ~/.bash_profile

Mysql

# yum install -y mysql-server MySQL-python

// 파일 수정 및 추가

# vi /etc/my.cnf

controller # vi /etc/my.cnf

bind-address=192.168.56.0

default-storage-engine=innodb

innodb_file_per_table

collation-server=utf8_general_ci

init-connect='SET NAMES utf8'

character-set-server=utf8

# service mysqld start

# chkconfig mysqld on

# mysql_install_db

# mysql_secure_installation

// 유저 생성

# mysql -u root -p

mysql> grant all privileges on DBNAME.* to 'USERNAME'@'localhost' identified by 'PASSWORD' with grant option;

mysql> flush privileges;

// 비밀번호 찾기

# service mysqld stop

# mysqld_safe --skip-grant-tables &

# mysql

mysql> use mysql;

mysql> select host, user, password from user;

mysql> update user set password=password('NEW_PASSWOD') where user='USERNAME';

mysql> Bye

# /etc/rc.d/init.d/mysqld restart