Unable to create mysql datasource from CFadmin

Hi,
I keep getting the following error when creating a new datasource for mysql 5 in cfadmin.
I have about 15 already working, my database is running fine and what even more confusion is that if I edit an existing datasource to point at my new database it works first time.

Has anyone come across this as I am running out of old datasources to rename and edit.

Connection verification failed for data source: myDataSource
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
The root cause was that: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
LmillardAsked:
Who is Participating?
 
witsCOMPUTINGConnect With a Mentor Commented:
I think you have limit of connection on your MySQL.

Try executing following query:

set global max_connections = 2000;

0
 
Gurpreet Singh RandhawaWeb DeveloperCommented:
Just Start your mysql server that is why it is showing an Error

Could not create connection to database server. Attempted reconnect 3 times. Giving up.

the above line states that it is looking if the mysql server is started or not, it tries for three times and then it gives up!

Just make sure your mysql server is started and working

have to installed wamp or xamp server, if any one, just click on wamp and start its services, it will work then

Cheers
0
 
LmillardAuthor Commented:
This is a development server running on my windows laptop, there were only about 5 connections runing at the time and the server was up and running for everything else other than the CF admin datasource connection.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
witsCOMPUTINGCommented:
@Lmillard: Did you tried increasing connection limit?
0
 
LmillardAuthor Commented:
Just tried and worked perfectly thanks,
0
 
Gurpreet Singh RandhawaWeb DeveloperCommented:
Great catch Thanks for the Info @wits
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.