Navicat 1045 Access Denied

[nikil92 1]

Hello,

I've already been through a few forums and tried a few things.
When I connect to the server and then try to connect to Navicat, I always get access denied... using password: yes.

It says that there is no password but even then it doesn't work.

If I enter mysql -u root -p on the server and 123 as the password, I get an error. If I enter admin as password it tells me Welcome to Mysql. Or is admin a general password?

Does anyone have a solution?

 

Edited August 28, 2024 by nikil92

[SinusAlpha 3]

mysql version ?

[nikil92 1]

Spoiler

 

Edited August 29, 2024 by Metin2 Dev International
Core X - External 2 Internal

[SinusAlpha 3]

It seems that you have entered an incorrect password for the user in Navicat.

it's difficult to help you if i don't have any further information.
have you self installed mysql or are you using any ready-made server files in a virtual machine?

Normally you configure mysql after installation with mysql_secure_installation (where mysql_secure_installation is not required) and then a user is created. You do this by logging in via mysql -u root -p and assigning a user, for example:

CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' WITH GRANT OPTION;

then:

FLUSH PRIVILEGES;
exit;

This is just an example! As I said, I don't know exactly where the error lies. I suspect that you have chosen the wrong user and password for Navicat and therefore cannot log in.

[Samesaoul 1]

I encountered this problem before, I know that for my part I modified the "localhost" by the IP of my virtual machine, you can always try it costs nothing, moreover in order to help you more clearly it would have been wise to provide us with information on the files used.