????5.????????mySQL
????(1)???mysql
????>yum search mysql
????>yum install mysql.x86_64 mysql-server.x86_64
????(2)????mysql??????????μ? http://blog.knowsky.com/193552.htm??
???????????MySQL???????????
?????????????????????????MySQL????????????
????[root@localhost yuanyuan]#netstat -anp|grep 3306
????tcp        0     0 0.0.0.0:3306               0.0.0.0:*                   LISTEN      34693/mysqld ??
????> service mysqld start                             //???mysql????
????> mysql -uroot -p                                   //???
????>vim /etc/my.cnf                                   //???? --skip- grant-tables ????????????????????????MySQL??????
????>service mysqld restart                          //????mysql????
????> mysql -uroot -proot                            //?????????????
????> vim /etc/my.cnf                                 //???????????????????
????>service mysqld restart                        //????
??????3?????????????????????????????
????> vim /etc/my.cnf
????//????mysql??????????????????????????
??????[client]?????
????default-charater-set=utf8
??????[mysqld]?????
????collation_server = utf8_general_ci
????character_set_server = utf8
?????????????????mysqld
?????????Ч??:
????mysql> show variables like 'character_set_%';
????+--------------------------+----------------------------+
????| Variable_name            | Value                      |
????+--------------------------+----------------------------+
????| character_set_client     | utf8                       |
????| character_set_connection | utf8                       |
????| character_set_database   | utf8                       |
????| character_set_filesystem | binary                     |
????| character_set_results    | utf8                       |
????| character_set_server     | utf8                       |
????| character_set_system     | utf8                       |
????| character_sets_dir       | /usr/share/mysql/charsets/ |
????+--------------------------+----------------------------+
????????????????latin??????
????mysql>set character_set_database=utf8
????(4)?????????dh_test??????dh.sql
????mysql>create database dh_test
????>show database //??????????
????>mysql -uroot -p dh_test < dh.sql ?????? mysqldump -u userName -p  dabaseName  > fileName.sql //????sql
????>show tables //????????????
????>select * from user //????????????ok
????6.web?????????????????????????????????????
??????????????????????webroot?μ???????linux?μ?/usr/local/tomcat ?μ?webapps?￡?webroot???root
????>cd ROOT/WEB-INF/classes/config/properties/database.properties
???????????????dh???????????????mysql???????￡?????
????7.???mysql?????tomcat
????>service mysqld start
????>./startup.sh
????>tail -fn 300 ../logs/catalina.out
?????????????????????????
??????linux?????????????????????? ???? localhost????
??????????????????tomcat???????conf/server.xml???????????? http://blog.csdn.net/defonds/article/details/4192953 ??