# add user
adduser yang
passwd yang
# 赋予root权限
# 修改/etc/sudoers 文件，找到下面一行，在root下面添加一行，如下所示：
## Allow root to run any commands anywhere
root ALL=(ALL) ALL
tommy ALL=(ALL) ALL
# 修改完毕，现在可以用tommy帐号登录，然后用命令su – ，即可获得root权限进行操作。
# install mysql
rpm -ql mysql
yum install mysql
rpm -ql mysql-server
yum install mysql-server
service mysqld start
# install java
java -version
# install tomcat
rpm -ql tomcat6
yum install tomcat6 tomcat6-webapps tomcat6-admin-webapps
service tomcat6 start
# 安装tomcat6默认目录在/usr/share/tomcat6/下
# 配置文件默认目录在/etc/tomcat6/下
# 配置tomcat为admin和manager用户
# 修改文件/usr/share/tomcat6/conf/tomcat-users.xml
vi /usr/share/tomcat6/conf/tomcat-users.xml
# tomcat winalitetomcat
# visit /manager/html
# 8080 端口问题
ps -ef | grep tomcat
netstat -an | grep 8080
service iptables stop
vi /etc/sysconfig/iptables
# vi yy and p and change 22 to 8080
service iptables start
service iptables status
# 改为 80 端口
vi /usr/share/tomcat6/conf/serve.xml
vi /etc/tomcat6/tomcat6.conf
# install svnserver
yum install subversion
svnserve --version
mkdir -p /opt/svn/repos
svnadmin create /opt/svn/repos
cd /opt/svn/repos/conf
vi passwd
# yang 1234567890yang
# chen 1234567890chen
vi authz
vi snvserv.conf
svnserve -d -r /opt/svn/repos
# 开放 3690
# winscp 上传文件
# mysql
# mysql -u root -p
# CREATE DATABASE `test1` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
CREATE DATABASE `hmh` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
use xxx;
SOURCE ~/test.sql;
# linux and windows mysql 数据库大小写问题
vi /etc/my.cnf
# lower_case_table_names=1 lower_case_table_names参数： 0为敏感，1为不敏感
# Socket file /tmp/mysql.sock exists. Is another MySQL daemon already running with the same unix socket?
ps aux | grep mysql
service mysqld stop
mv /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock.bak
service mysqld start
# 中文乱码
set names utf8;
set character_set_results = utf8;
set character_set_client = utf8;
set character_set_connection = utf8;
# 重新导入