发布的web项目连接在linux上的MySQL数据库不能运行起来，但是连接windows上的mysql可以，什么原因呢？？

好像是不能解析，默认安装的 MYSQL开启了DNS的反向解析,在MY.INI(WINDOWS系统下)或MY.CNF(UNIX或LINUX系统下)文件的[mysqld]下加入 skip-name-resolve这一句。

但是，这样会引起一个问题：连接mysql时，不能使用 localhost连接了，而是要使用IP地址的

关闭linux的selinux

关闭linux防火墙

关键你给的分太少！如下是上线达1年，稳定运行的配置。

---------------------------------------------------------、

属性文件

c3p0.driverClass=com.mysql.jdbc.Driver

c3p0.user=root

c3p0.password=edwin

c3p0.jdbcUrl=jdbc\:mysql\://192.168.1.123\:3306/edwin?useUnicode\=true&characterEncoding\=utf-8

c3p0.minPoolSize = 1

c3p0.maxPoolSize = 50

c3p0.initialPoolSize = 1

c3p0.maxIdleTime = 25000

c3p0.acquireIncrement = 1

c3p0.acquireRetryAttempts = 30

c3p0.acquireRetryDelay = 1000

c3p0.testConnectionOnCheckin = true

c3p0.automaticTestTable = t_c3p0

c3p0.idleConnectionTestPeriod = 18000

c3p0.checkoutTimeout=5000

---------------------------------------------------------

spring配置

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:aop="http://www.springframework.org/schema/aop"

xmlns:tx="http://www.springframework.org/schema/tx"

xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd

http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd

http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd

http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd" default-autowire="byName" default-lazy-init="false">

<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">

<property name="location">

<value>classpath:com/edwin/db/config/c3p0.properties</value>

</property>

</bean>

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">

<property name="driverClass">

<value>${c3p0.driverClass}</value>

</property>

<property name="jdbcUrl">

<value>${c3p0.jdbcUrl}</value>

</property>

<property name="user">

<value>${c3p0.user}</value>

</property>

<property name="password">

<value>${c3p0.password}</value>

</property>

<property name="minPoolSize">

<value>${c3p0.minPoolSize}</value>

</property>

<property name="maxPoolSize">

<value>${c3p0.maxPoolSize}</value>

</property>

<property name="initialPoolSize">

<value>${c3p0.initialPoolSize}</value>

</property>

<property name="maxIdleTime">

<value>${c3p0.maxIdleTime}</value>

</property>

<property name="acquireIncrement">

<value>${c3p0.acquireIncrement}</value>

</property>

<property name="acquireRetryAttempts">

<value>${c3p0.acquireRetryAttempts}</value>

</property>

<property name="acquireRetryDelay">

<value>${c3p0.acquireRetryDelay}</value>

</property>

<property name="testConnectionOnCheckin">

<value>${c3p0.testConnectionOnCheckin}</value>

</property>

<property name="automaticTestTable">

<value>${c3p0.automaticTestTable}</value>

</property>

<property name="idleConnectionTestPeriod">

<value>${c3p0.idleConnectionTestPeriod}</value>

</property>

<property name="checkoutTimeout">

<value>${c3p0.checkoutTimeout}</value>

</property>

</bean>

</beans>

-------------------------------------------------

t_c3p0 就是一个测试表！

---