Mysql password expiration causes the connection not to Mysql_mysql
Source: Internet
Author: User
MySQL password expired, today encountered a connection to MySQL, always connected not up,
Error Symptom 1:
An attempt by a client to checkout a Connection has timed out
The first time a connection timeout error occurred, the first reaction is to modify the Cpool.checkouttimeout parameter is 18000, initially 500, the result is still wrong,
Modified to 36000, and increased the number of C3P0 connections cpool.maxpoolsize=100
The following error occurred at this time 2
Connections could not is acquired from the underlying database!
has not been positioned out, rely on, suddenly remembered that the Oracle 11g password has expired problem, MySQL will not have it, try, how to do not write more, see my blog
http://blog.csdn.net/dracotianlong/article/details/8100235
After the modification, restart MySQL and Tomcat, it's done. It is estimated that the reason for the virtual machine, Google, did not find a more official description.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service