- This topic has 11 replies, 6 voices, and was last updated 15 years, 8 months ago by
.
-
Posts
-
MySql 5.1 database connection problem in myecilpse 7.1
Database wizard :
Driver template : MySql Connector/J
Driver Name : mysqlDriver
Connection URL : jdbc:mysql://hostname:3306/
Driver Class Name : com.mysql.jdbc.DriverI hav selected “mysql-connector-java-5.1.7-bin.jar” after which Test Driver button is enabled.. after clicking on it, it is giving me a promt for password : mysql123, it is poping up an error message :
“Error while performing database login with the mysqlDriver driver :
communication link failure.Last packet sent to the server was 0 ms ago. ”
Please let me know what is the problem. ??
@kiran20v wrote:
MySql 5.1 database connection problem in myecilpse 7.1
Database wizard :
Driver template : MySql Connector/J
Driver Name : mysqlDriver
Connection URL : jdbc:mysql://hostname:3306/
Driver Class Name : com.mysql.jdbc.DriverI hav selected “mysql-connector-java-5.1.7-bin.jar” after which Test Driver button is enabled.. after clicking on it, it is giving me a promt for password : mysql123, it is poping up an error message :
“Error while performing database login with the mysqlDriver driver :
communication link failure.Last packet sent to the server was 0 ms ago. ”
Please let me know what is the problem. ??
sure that the mysql server is on ? did you try to connect to mysql manually ?
I have the same problem , with the Connection URL : jdbc:mysql://localhost
try to change hostname by localhost
Connection URL : jdbc:mysql://hostname:3306/
First are you sure “hostname” is correct and resolvable from your PC?
Yep
MySql is On and functional.
Connection URL : jdbc:mysql://hostname:3306/ is working fine on some systems.
I have tried with ‘localhost’ and ‘hostname’ too. same thing continues.Kiran
Driver template : MySql Connector/J
Driver Name : mysqlDriver
Connection URL : jdbc:mysql://hostname:3306/
Driver Class Name : com.mysql.jdbc.DriverUse this instead –
Driver template : MySql Connector/J
Driver Name : mysqlDriver
Connection URL : jdbc:mysql://localhost:3306/ (or) jdbc:mysql://localhost:3306/test (or) jdbc:mysql:///test
Driver Class Name : com.mysql.jdbc.DriverReplace “hostname” in the Connection URL, with either “localhost” or “Name(your SystemName)”.
Connection URL : jdbc:mysql://localhost:3306/ (or) jdbc:mysql://localhost:3306/test (or) jdbc:mysql:///test
Replace “hostname” in the Connection URL, with either “localhost” or “Name(your SystemName)”.
I have tried all of these :
jdbc:mysql://localhost:3306/test, jdbc:mysql://localhost:3306/, jdbc:mysql:///test .
The follwing error message is coming up :” Error while performing database login with mysqlDriver driver :
Access denied for the user “@’localhost’ (Using password :YES)
”kiran
The error message seems indicate the connection was made but the db server didn’t like the user name or password.
Im able to connect with MYSQL server with the same password through the command prompt, but unable to connect through db browser in myeclipse7.1.
Kiran
” Error while performing database login with mysqlDriver driver :
Access denied for the user “@’localhost’ (Using password :YES)
”Can you click on Window > Show/View > Problems and copy and paste the error. Also you can look into your log file located under [MyEclipse installation folder]\.metadata\.log for the appropriate error.
Kiran,
As Ray pointed out above, your database is up and running and MyEclipse does get to it, but the connection is refused. From Joy’s earlier message, please use
jdbc:mysql://localhost:3306 or jdbc:mysql://localhost:3306/testas a connection string, the latter is preferred, where “test” is the name of a database that should exist.
From the error message
Access denied for user ”@’localhost’ (using password: YES)
it appears that you have not specified a username. Have you specified a username in the “User name” field of the driver? If this is the root account then specifying
rootas the username should work. If this is not the root account, please make sure you specify the correct username.
