mysql错误1149_生产环境mysql 链接错误Your password has expired

生产环境服务器，项目部署好后重启报如下错误：### The error occurred while executing a query

### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException:

Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException:

Cannot create PoolableConnectionFactory (Your password has expired.

To log in you must change it using a client that supports expired passwords.)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1553)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:700)

at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:760)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)

at org.springframework.web.servlet.FrameworkServlet.configureAndRefreshWebApplicationContext(FrameworkServlet.java:658)

at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:624)

at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:672)

at org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:543)

at org.springframework.web.servlet.FrameworkServlet.initServletBean(FrameworkServlet.java:484)

at org.springframework.web.servlet.HttpServletBean.init(HttpServletBean.java:136)

at javax.servlet.GenericServlet.init(GenericServlet.java:158)

at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1282)

at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1195)

at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1085)

at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5318)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5610)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)

at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1259)

at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1998)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at java.lang.Thread.run(Thread.java:748)

刚开始以为是密码写错了，重新复制粘贴了密码，问题依旧，仔细看了下上面的报错信息，说的是密码过期了。

因为mysql是刚装好的，重新设置了新的密码后，设置允许远程连接，并在本地用sqlyog能正常连接，按理说应该正常的呀，远程能正常连接，本地(服务器和数据库在同一台机器)应该可以。

ssh连接服务器，命令行登录mysql，执行下面命令select host,user,password_expired from mysql.user;

发现了不正常的地方

这就说明了远程能正常连接，本地不行了，看来还真是过期了

重新设置下update mysql.user set password_expired='N';

再次查询，已经变成N了

然后重启程序，正常了