Re: ERROR 1045 (28000): Access denied for user 'MyUser'@'localhost' (using password: YES)
Posted by: Alexandre Salomé
Date: January 13, 2021 07:42PM

- What kind of application is this?

This application is TRACCAR, based os java



- Connection string in the application configuration?

I am follow the instrution of https://www.traccar.org/mysql/ :

<entry key='database.url'>jdbc:mysql://[HOST]:3306/[DATABASE]?serverTimezone=UTC&amp;useSSL=false&amp;allowMultiQueries=true&amp;autoReconnect=true&amp;useUnicode=yes&amp;characterEncoding=UTF-8&amp;sessionVariables=sql_mode=''</entry>

Did you disable SSL?

I think yes, looking the commnd above




- What's the authentication plugin for this user?
(SELECT plugin FROM mysql.user WHERE user = 'MyUser')


+-----------------------+
| plugin |
+-----------------------+
| caching_sha2_password |
+-----------------------+



I am able to connect when I give all privileges for this user:

grant all privileges on *.* to 'MyUser'@'localhost' with grant option;

It is no good, because this user must not be adminator. but only using the command above I am able to connect.


do you help me?

Alex / Brazil

Options: ReplyQuote




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.