MySQL Bugs: #31282: Error connecting to mysql ( solved)

Bug #31282	Error connecting to mysql ( solved)
Submitted:	28 Sep 2007 15:45	Modified:	8 Feb 2009 12:07
Reporter:	Aditya Tresnaprana	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S1 (Critical)
Version:	1.1.12	OS:	Windows (xp sp2)
Assigned to:	Mike Lischke	CPU Architecture:	Any
Tags:	character set, ReverseEngineering

Description:
After set the source to mssql and destination to mysql, I get this error message from the destination part (mssql connect seems ok) :

........
Opening connection ... 
Connection jdbc:mysql://localhost:3306/?user=admin&password=xxxxxxxx&useServerPrepStmts=false&characterEncoding=UTF-8
The connection to the target database could not be established (error: 0).
ReverseEngineeringMysqlJdbc.getVersion :Unknown initial character set index '48' received from server. Initial client character set can be forced via the 'characterEncoding' property.
Details: 
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
com.mysql.jdbc.Connection.configureClientCharacterSet(Connection.java:2345)
com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3913)
com.mysql.jdbc.Connection.createNewIO(Connection.java:2683)
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.ReverseEngineeringGeneric.getVersion(ReverseEngineeringGeneric.java:161)
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)

I think the password is ok, because when i try to mixed it up, the program give me 'access denied'. When i type password correctly, the 'access denied gone and
above error comed up.
The problem does not exists with other tools ( query browser and administation_kit).

How to repeat:
1.Run the migration toollkit
2.Set Source to mssql
3.Set Dest. to mysql. > next..
thats it. the problems there.

Suggested fix:

I dont think i am qualified for this, but might be problem with connectors.

i have latest mysql-connector-java-5.0.6-bin  in my system, but seems that this tools also have its own connector. (mysql-connector-java-5.0.4-bin) 

Hey yes its fixed.

I just delete the 5.0.4 and replace with the 5.0.6

thanks

Thank you for the bug report.

the problem is back in version 1.1.12 (mysql-gui-tools-5.0-r12-win32.msi).

I was using an access 2000 database.

Do you still see this problem with the latest release? I have recently done several migrations from MS SQL Server and never saw such an error.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".