Access Denied For User 'root'@' (using Password: YES)  (Doc ID 2260437.1)

Last updated on JUNE 21, 2017

Applies to:

Oracle SQL Developer - Version 4.1 to 4.2.0 [Release 4]
Information in this document applies to any platform.

Symptoms

Problem Summary
---------------------------------------------------
Using SQL Developer to to migrate data into oracle from MySQL Server, you are not able to connect and get the following error:

Access denied for user 'root'@' (using password: YES)

Connection to MySQL from the host works.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms