让MYSQL不区分表名大小写的方法其实很简单:
1.用ROOT登录,修改/etc/my.cnf
2.在[mysqld]下加入一行:lower_case_table_names=1
3.重新启动数据库即可
Linux | CentOS 5.5 (64bit) |
---|---|
Java | JRE 1.7.0 update 5 |
Tomcat | 7.0.29 |
# tar xvzf jre-7u5-linux-x64.tar.gz # mv jre1.7.0_05 /usr/local # cd /usr/local # ln -s jre1.7.0_05 java
# useradd -s /sbin/nologin tomcat
# tar xvzf apache-tomcat-7.0.29.tar.gz # mv apache-tomcat-7.0.29 /usr/local # cd /usr/local # chown tomcat:tomcat -R apache-tomcat-7.0.29 # ln -s apache-tomcat-7.0.29 tomcat
JAVA_HOME=/usr/local/java CATALINA_HOME=/usr/local/tomcat export JAVA_HOME CATALINA_HOME
#!/bin/bash # # Startup script for the Tomcat Servlet Container # # chkconfig: 2345 35 65 # description: Tomcat is the servlet container that is used in the official \ # Reference Implementation for the Java Servlet and JavaServer \ # Pages technologies TOMCAT_USER=tomcat CATALINA_HOME=/usr/local/tomcat . /etc/rc.d/init.d/functions prog=tomcat start() { echo -n $"Starting $prog: " daemon --user $TOMCAT_USER $CATALINA_HOME/bin/startup.sh > /dev/null RETVAL=$? if [ $RETVAL -eq 0 ]; then echo_success else echo_failure fi echo [ $RETVAL = 0 ] && touch /var/lock/subsys/$prog return $RETVAL } stop() { echo -n $"Stopping $prog: " daemon --user $TOMCAT_USER $CATALINA_HOME/bin/shutdown.sh > /dev/null RETVAL=$? if [ $RETVAL -eq 0 ]; then echo_success else echo_failure fi echo [ $RETVAL = 0 ] && rm -f /var/lock/subsys/$prog return $RETVAL } # See how we were called. case "$1" in start) start ;; stop) stop ;; restart) stop start ;; status) INSTANCES=`ps --columns 512 -aef|grep java|grep tomcat|grep org.apache.catalina.startup.Bootstrap|wc -l` if [ $INSTANCES -eq 0 ]; then echo $prog is stopped RETVAL=3 else if [ $INSTANCES -eq 1 ]; then echo $prog is running 1 instance... else echo $prog is running $INSTANCES instances... fi RETVAL=0 fi ;; *) echo $"Usage: $prog {start|stop|restart|status|help}" exit 1 esac exit $RETVAL
# /sbin/chkconfig --add tomcat
# cd /etc/init.d # ./tomcat start
1
2
|
wget http://www.atlassian.com/software/jira/downloads/binary/atlassian-jira-5.0.4.tar.gz
wget http://www.atlassian.com/software/crowd/downloads/binary/atlassian-crowd-2.4.2.tar.gz
|
1
2
|
tar -zxvf atlassian-jira-5.0.4.tar.gz -C /usr/local/
tar -zxvf atlassian-crowd-2.4.2.tar.gz -C /usr/local/
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
mysql --user=root –p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 559 to server version: 5.0.13-rc-Debian_1-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database jiradb character set utf8;
Query OK, 1 row affected (0.02 sec)
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX on
jiradb.* TO 'jirauser'@'localhost' IDENTIFIED BY 'mypassword';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
|
1
2
3
4
5
6
7
8
9
10
11
12
|
[root@pek7-qat-01 ~]# mysql \--user=jirauser \--password=mypassword \--database=jiradb
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 54
Server version: 5.0.95 Source distribution
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
[root@pek7-qat-01 ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 55
Server version: 5.0.95 Source distribution
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> select host,user from mysql.user;
+-------------+----------+
| host | user |
+-------------+----------+
| 127.0.0.1 | root |
| localhost | jirauser |
| localhost | root |
+-------------+----------+
7 rows in set (0.00 sec)
mysql> update user set host='localhost.localdomain' where user='jirauser';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)
|
1
2
3
|
[root@pek7-qat-01 ~]# cd /usr/local/
[root@pek7-qat-01 local]# cd date/
[root@pek7-qat-01 date]# mkdir jira
|
1
2
|
[root@pek7-qat-01 date]# vim /usr/local/jira/atlassian-jira/WEB-INF/classes/jira-application.properties
jira.home = /usr/local/date/jira
|
Description=JIRA:商业
CreationDate=2009-10-25(创建时间) ContactName=xxx(管理员的名字) jira.LicenseEdition=ENTERPRISE ContactEMail=xxx@xxx.xxx(管理员的邮箱) Evaluation=false jira.LicenseTypeName=COMMERCIAL jira.active=true licenseVersion=2 MaintenanceExpiryDate=2099-10-24(维护过期时间) Organisation=xxx(组织名称) jira.NumberOfUsers=-1ServerID=B6FW-B4KW-J1A3-4DQB LicenseID=LID LicenseExpiryDate=2099-10-24(授权过期时间) PurchaseDate=2009-10-25(购买时间) |