The mysql password expires resulting in a failure to connect to mysql

  • 2020-05-17 06:39:19
  • OfStack

The mysql password has expired. I encountered the connection with mysql today, but it always failed.
Error phenomenon 1:
An attempt by a client to checkout a Connection has timed out
The connection timeout error occurred in the first time, and the first response was to modify cpool.checkoutTimeout parameter was 18000, initially it was 500, and the result was still wrong.
In the change to 36000, and increased the number of c3p0 connections cpool.maxPoolSize =100

The following error 2 occurs at this point
Connections could not be acquired from the underlying database!
1 straight did not locate out, depend, suddenly remind of, Oracle 11g password before there is expired problem, mysql will also have, try, how to do not write more, see my blog
http://blog.csdn.net/dracotianlong/article/details/8100235
After the modifications, restart mysql and tomcat and you're done. It is estimated that the reason is the virtual machine, google, did not find more official instructions.

Related articles: