MySQL Forums
Forum List  »  Install & Repo

ERROR 1045 (28000): Access denied for user 'root'@'192.168.56.1' (using password: YES)
Posted by: Thomas Schläppi
Date: November 12, 2016 06:54AM

Hi MYSQL Admins,

I cannot connect from my laptop to my mysql server: (ERROR 1045 (28000): Access denied for user 'root'@'192.168.56.1' (using password: YES))

- Connectivity seems to be ok, port 3306 is open.
- MySQL Config file is ok, (bind-address = 192.168.56.2) is set.
- I think that the User Table is OK:

Here my user table (User/Host)
+------------------+-----------+
| root | % |
| debian-sys-maint | localhost |
| mysql.sys | localhost |
| phpmyadmin | localhost |
| root | localhost |
+------------------+-----------+
All Enums for root/% are set to Y


What do i missing?

Thomas

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

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.