org.jkiss.dbeaver.model.exec.DBCConnectException: Access denied for user 'root'@'[client ip address]' (using password: YES)

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Expert tip

MySQL doesn't support some types of characters (such as emojis) with the utf8 encoding. You need to be on MySQL 5.5+ and force utf8mb4 (everywhere, client and server). You can do this sending the query "SET NAMES utf8mb4". Check this


Make sure you are using InnoDB storage engine and READ-COMMITTED transaction isolation level and increase the database server innodb_lock_wait_timeout variable to about 500.

Solutions on the web

via GitHub by oulenz
, 1 year ago
Access denied for user 'root'@'[client ip address]' (using password: YES)
via GitHub by oulenz
, 1 year ago
Access denied for user 'root'@'[client ip address]' (using password: YES)
via GitHub by Jiehong
, 10 months ago
The TCP/IP connection to the host value, port 1433 has failed. Error: "null. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
java.sql.SQLException: Access denied for user 'root'@'[client ip address]' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(
at com.mysql.jdbc.MysqlIO.checkErrorPacket(
at com.mysql.jdbc.MysqlIO.checkErrorPacket(
at com.mysql.jdbc.MysqlIO.checkErrorPacket(
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(
at com.mysql.jdbc.MysqlIO.doHandshake(
at com.mysql.jdbc.ConnectionImpl.coreConnect(
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(
at com.mysql.jdbc.ConnectionImpl.createNewIO(
at com.mysql.jdbc.ConnectionImpl.(
at com.mysql.jdbc.JDBC4Connection.(
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
at com.mysql.jdbc.Util.handleNewInstance(
at com.mysql.jdbc.ConnectionImpl.getInstance(
at com.mysql.jdbc.NonRegisteringDriver.connect(
at org.jkiss.dbeaver.model.impl.jdbc.JDBCDataSource.openConnection(
at org.jkiss.dbeaver.ext.mysql.model.MySQLDataSource.openConnection(
at org.jkiss.dbeaver.model.impl.jdbc.JDBCExecutionContext.connect(
at org.jkiss.dbeaver.model.impl.jdbc.JDBCDataSource.(
at org.jkiss.dbeaver.ext.mysql.model.MySQLDataSource.(
at org.jkiss.dbeaver.ext.mysql.MySQLDataSourceProvider.openDataSource(
at org.jkiss.dbeaver.registry.DataSourceDescriptor.connect(
at org.jkiss.dbeaver.ui.dialogs.connection.ConnectionWizard$

Users with the same issue

4 times, 6 hours ago
5 times, 1 day ago
18 times, 3 days ago
2 times, 6 days ago
326 times, 1 week ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.