Re: MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Posted by: willians nogueira
Date: November 30, 2018 06:17AM

Hi, Filipe.

Follow my settings : (Access denied remains)


mysql> select user, host, plugin, ssl_type from mysql.user;
+------------------+-----------+-----------------------+----------+
| user | host | plugin | ssl_type |
+------------------+-----------+-----------------------+----------+
| mysql.infoschema | localhost | caching_sha2_password | |
| mysql.session | localhost | caching_sha2_password | |
| mysql.sys | localhost | caching_sha2_password | |
| root | localhost | mysql_native_password | |
+------------------+-----------+-----------------------+----------+
4 rows in set (0.00 sec)



********

Java Exception connection:

Exception connection: Access denied for user 'root'@'localhost' (using password: YES)
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835)
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Conectar.<init>(Conectar.java:23)
at a_main_testar_conexao.main(a_main_testar_conexao.java:7)



******
my.ini

[client]

protocol=TCP


port=3306

ssl-mode=DISABLED

no-beep


[mysqld]
port=3306
datadir=C:/ProgramData/MySQL/MySQL Server 8.0/Data
default_authentication_plugin=mysql_native_password
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
log-output=FILE
general-log=1
general_log_file="ALIENWARE.log"
slow-query-log=1
slow_query_log_file="ALIENWARE-slow.log"
long_query_time=10
log-bin="ALIENWARE-bin"
log-error="ALIENWARE.err"

server-id=1
lower_case_table_names=1
max_connections=151
table_open_cache=2000
tmp_table_size=238M
thread_cache_size=10
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=464M
key_buffer_size=8M
read_buffer_size=64K
read_rnd_buffer_size=256K
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=8M
innodb_log_file_size=48M
innodb_thread_concurrency=17
innodb_autoextend_increment=64
innodb_buffer_pool_instances=8
innodb_concurrency_tickets=5000
innodb_old_blocks_time=1000
innodb_open_files=300
innodb_stats_on_metadata=0
innodb_file_per_table=1
innodb_checksum_algorithm=0
back_log=80
flush_time=0
join_buffer_size=256K
max_allowed_packet=4M
max_connect_errors=100
open_files_limit=4161

sort_buffer_size=256K
table_definition_cache=1400
binlog_row_event_max_size=8K
sync_master_info=10000
sync_relay_log=10000
sync_relay_log_info=10000
loose_mysqlx_port=33060

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
November 30, 2018 06:17AM


Sorry, only registered users may post in this forum.

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.