Re: Connect To database error

[Mike Lischke]

> Failed to connect to mysql at 127.0.0.1:3306 with
> the user 'XXX'
> Access denied for user 'XXX'@'localhost' (using
> password: YES)

This doesn't make sense. You connect either from localhost or from 127.0.0.1. From a networking standpoint both are the same (for IPv4). The server however sees them as 2 different users. So make sure you have entries for both XXX@localhost and XXX@127.0.0.1 in your users table.

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/