Mysql password expired, causing connection failure to mysql_MySQL
Source: Internet
Author: User
The mysql password has expired and the mysql bitsCN. commysql password cannot be connected. today, when I connect to mysql, I cannot connect to mysql,
Error 1:
An attempt by a client to checkout a Connection has timed out
The connection timeout error occurs for the first time. The first response is to modify the cpool. checkoutTimeout parameter to 18000, the initial value is 500, and the result is still incorrect,
When it is changed to 36000, and the number of c3p0 connections is increased. cpool. maxPoolSize = 100
The following error occurs at this time: 2 Connections cocould not be acquired from the underlying database!
I haven't located it all the time. I suddenly remembered that there was a problem with the expiration of the Oracle 11g password in the past. will mysql also have it? try it and I will not write much about it. See my blog.
Http://blog.csdn.net/dracotianlong/article/details/8100235
After modification, restart mysql and tomcat. It is estimated that it is the reason for the virtual machine. google does not find a more official description. BitsCN.com
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.