[nbusers] MySQL connection error: Communications link failure

  • From: verobel < >
  • To:
  • Subject: [nbusers] MySQL connection error: Communications link failure
  • Date: Sun, 25 Nov 2012 11:07:28 -0800 (PST)

Hi Fellow Netbeans programmers;

I am relatively new to netbeans (using V 6.9.1) but have resurrected some
old programs and made them work.
Now I am trying to connect to MySQL database V 5.5.20 but get a
communication error.

The MySQL is also relatively new. I can login to it ok with the command line
and have a couple small
databases/tables created.

I searched the forum for 'netbeans mysql connection error' posts and came
across a few over the years, the latest suggesting to change my.ini file to
comment out: 
#skip-networking 
and add:
bind-adresss=127.0.0.1   
which I did but still get the same error: *Unable to add connection. Cannot
establish a connection to 
jdbc:mysql://localhost:3306/stream1 using com.mysql.jdbc.Driver
(Communciations link failure)*

I believe the server is running since the database is running and taskmgr
show mysql.exe as an active process

I made these changes to the file pointed to in the startup icon (link below)
and restarted the database
and retried it. Still get same error.
"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe"
 "--defaults-file=C:\Program Files\MySQL\MySQL Server 5.5\my.ini" "-uroot"
"-p"

I am running Netbeans and MySQL in Windows7 environment.  In Netbeans I am
under Services and then under Database and drivers showing: JavaDB,
JDBC-ODBC bridge, MySQL, and MySQL(Connector/J driver)
and PostgresSQL. I right click on MySQL(Connector/J driver) and select
connect using..
jdbc:mysql://localhost:3306/stream1  
I am using User Name: root and the same password I use to login to the
database, but it doesn't want
to connect.

Please advise on how to successfully connect in this environment. I may
still have something configured wrong or perhaps not starting up properly,
who knows? 

Thx. John








--
View this message in context: 
http://netbeans-org.1045718.n5.nabble.com/MySQL-connection-error-Communications-link-failure-tp5717381.html
Sent from the Netbeans IDE Users mailing list archive at Nabble.com.


[nbusers] MySQL connection error: Communications link failure

verobel 11/25/2012

Project Features

About this Project

www was started in November 2009, is owned by jpirek, and has 21 members.
By use of this website, you agree to the NetBeans Policies and Terms of Use (revision 20131025.e7cbc9d). © 2013, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo
 
 
Close
loading
Please Confirm
Close