MySQL Forums
Forum List  »  MySQL Workbench

Re: MySQL 8.0.17 cannot connect to database
Posted by: Alan Jeffery
Date: November 19, 2019 04:01PM

The problem was solved by allowing the root user to access all hosts. By default MySQL 8.0 limits the root user to the "LocalHost" server. So you have to change it to '%'. Which, strange as it may seem, is what is allocated to any other user you set up when first installing.

Alan

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL 8.0.17 cannot connect to database
56
November 19, 2019 04:01PM


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.