Mysql db connection error
Posted by: Pedro Han
Date: August 23, 2010 08:25AM

I downloaded mysql-gui-tools-noinstall-5.0-r17-win32 and executed MySQLMigrationTool.exe at my box. My box is windows 7 x64 and installed xampp for windows 1.7.3 - MySQL 5.1.41.

At first step - connecting one of my dynamic server, MySQLMigrationTool has an error as the under-mentioned:


Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class MySQL JDBC Driver 5.0
Opening connection ...
Connection jdbc:mysql://source.wowip.kr:3306/?user=sourceur&password=sourceps&useServerPrepStmts=false&characterEncoding=UTF-8
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringMysqlJdbc.getSchemata :Access denied for user 'sourceur'@'192.168.0.1' (using password: YES)
Details:
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)
com.mysql.jdbc.Connection.createNewIO(Connection.java:2670)
com.mysql.jdbc.Connection.<init>(Connection.java:1531)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEngineeringGeneric.java:141)
com.mysql.grt.modules.ReverseEngineeringMysqlJdbc.getSchemata(ReverseEngineeringMysqlJdbc.java:42)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)


Any comment would be appreciated.

Options: ReplyQuote


Subject
Written By
Posted
Mysql db connection error
August 23, 2010 08:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.