编译安装MySQL ，J2EE环境配置

安装依赖库和开发环境

#依赖库和开发工具

yum -y install gcc gcc-c++ autoconf libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs-devel krb5 krb5-devel libidn libidn-devel openssl openssl-devel openldap openldap-devel nss_ldap openldap-clients openldap-servers

 
#Mysql

yum -y install bison gcc gcc-c++ autoconf automake zlib* libxml* ncurses-devel libtool-ltdl-devel*

安装Mysql

#安装cmake
tar -zxvf cmake-2.8.6.tar.gz
cd cmake-2.8.6/
./configure
gmake && gmake install  && cd ../


#添加mysql用户
/usr/sbin/groupadd mysql
/usr/sbin/useradd -g mysql mysql
mkdir -p /data/mysql
chown -R mysql:mysql /data/mysql


#安装Mysql
tar -zxvf mysql-5.5.17.tar.gz
cd mysql-5.5.17
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql -DSYSCONFDIR=/etc/
make && make install


#设置Mysql
#在support-files目录中有五个配置信息文件：
#my-small.cnf (内存<=64M)
#my-medium.cnf (内存 128M)
#my-large.cnf (内存 512M)
#my-huge.cnf (内存 1G-2G)
#my-innodb-heavy-4G.cnf (内存 4GB)
cd /usr/local/mysql
cp ./support-files/my-medium.cnf /etc/my.cnf 
vi /etc/my.cnf
#在 [mysqld] 段增加
datadir = /data/mysql
wait-timeout = 30
max_connections = 512
default-storage-engine = MyISAM
#在 [mysqld] 段修改
max_allowed_packet = 16M 


#生成授权表
cd /usr/local/mysql
./scripts/mysql_install_db --user=mysql


#更改密码
/usr/local/mysql/bin/mysqladmin -u root password 123456


#开启mysql
/usr/local/mysql/bin/mysqld_safe &


#测试连接mysql
/usr/local/mysql/bin/mysql -u root -p 123456
show databases;
exit;


#设置开机启动
vi /etc/rc.d/rc.local


#加入
/usr/local/mysql/bin/mysqld_safe &

开始数据库导入

create database IF NOT EXISTS yh_exam default charset utf8 COLLATE utf8_general_ci; 

show databases;

use yh_exam;

重新登录

./mysql -u root -p --default-character-set=utf8

use yh_exam;

 source /root/yh_exam.sql

授权测试

 grant all privileges on *.* to 'testtest'@'%' identified by 'testpwd';

flush privileges;

JDK

vi /etc/profile

JAVA_HOME=/opt/jdk1.7.0_80
export JAVA_HOME
PATH=.:$PATH:$JAVA_HOME/bin

使配置生效

source /etc/profile

做软链接

 ln -s /opt/jdk1.7.0_80/bin/java /usr/bin/java