@ Jochem van Dieten
A connection limit in MySQL that is exhausetd should give a different error since then you would essentially connect and be disconnected.
Why presume that, when you're told there were 3 attempts to reconnect?
Ronski87, you can eliminate the connection-limit hypothesis by doing the following in the Administrator:
1) For that particular datasource, choose to Show Advanced Settings. Enter this query in the field Validation Query:
set @@global.max_connections = 1000;
2) Press the button to submit the changes.
3) Is the datasource now verified?
If not, my next bet will be one of Jochem's ideas, a firewall block.
Thanks for all reply's
I've tried to make with your suggestions, that means with Your suggestion BKBK -> still the same error.
Alexei -> this .jar's neither.
I downloaded Advanced Port scanner to test port's status. Every time (is firewall on or not) i have 3 to 5 ports opened (23 - telnet, 25 - smtp, 80 - www, 110 - pop3). Rest is blocked. I work on laptop, but situation with my standalone PC looks the same -> all ports are blocked, excepts this few.
Hi there again.
sorry guys (and girls if any ofc), i'm so stupid...
the only problem with my issue was that, i didn't set up new database in phpmyadmin (using MySQL). Now, i set new one, set user, password and... everything works fine.
sorry for that, human is learning for all the time
I want to thank everybody who helps me with posting, and see You again in the next issue
Hi, if You want to use DataSource with MySQL driver, you have to SET UP a new database via phpMyAdmin. It is a tool which with you can add and make everything you want with MySQL databases. Setting it up, adding new tables, edit tables and more. I'm using WAMPP (Apache, MySQL, PHP) - a windows web development environment. here yoe've got the link:
If You have more questions, write here or send me pm.
You don't need to use PHPMyAdmin to do this. PHPMyAdmin is just a web-based DB client. MySQL does come with its own GUI management tools. Or indeed one can just connect to the server on the command-line and do anything you like that way too ;-)
My impression of PHPMyAdmin - although I've not used it for 7-8yrs - was that it was to a proper GUI tool what Outlook Web Access is to MS Outlook: a rather poor cousin.
But - yes - to create a working CF DSN, there does have to be a database to connect to first, so one does need to create it if it doesn't already exist!
I'm having exact same issue.
Am able to connect via DW with PHP and everything works fine, then try connecting via CF9 Administration to the same database as PHP, I get same error message as above, then try connecting via DW with CF the error message is saying "access denied"
OS X 10.6.2 64 bit
MAMP Pro 1.8.4
CF 9 Developer Edition
One thing I have notice is that CF 9 installer produced error log and when reviewing couldn't identify any issues and all seems to be working fine except connecting to MySQL.
Can anyone assist?
You can try checking mySQL user settings in DB mysql TABLE user
In field "host" of your user CF requires to have "localhost". Some SQL shell (like the old gui tools of myMySQL) will set this field to "%".
NB: setting to "localhost" you will no more able to access remotely with that user. You may want to duplicate the row.
I've got the exact same issue, but I didn't install mysql with MAMP Pro but through macports. I've verified the location of my socket and mysql is up and running fine, listening on port 3306 and seems to accept both TCP/IP connections as well as through the socket.
I am on Mac OS Snow Leopard 10.6.3, running Coldfusion 9 and MySQL 5.1.47. The exact message I am getting when I try to verify the DSN from the Coldfusion Administrator is:
Connection verification failed for data source.
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.
Any insight into why I can't connect? All the online forums seem to suggest that it's the JDBC driver, but I am reluctant to replace the driver until I am absolutely sure that is the problem, since it might have other repurcussions.
I had the same problem with CF 11 and CF 10 on Mac, running Mysql with MAMP Pro. What I did in the end was a combination of these steps, I don't know if all are necessary but at least it works now
1. In MAMP pro go to -> file > edit template > MYSQL my.cnf (after you shut down the server)
2. Comment out MAMP_skip-networking_MAMP
3. Added: max_connections = 1000 (in section [mysqld])
4. Restart server in MAMP
5. In CF datasource I changed server settings to 127.0.0.1 port 3306