Mysql unable to update security settings

Create a free Team What is Teams? Learn more. Asked 8 years, 11 months ago. Active 5 years ago. Viewed 10k times. I tried to configure MySQL server 5. Unable to connect to any of the specified MySQL hosts. Improve this question. Eran 2 2 silver badges 5 5 bronze badges.

Add a comment. Active Oldest Votes. Problem was with root access and firewall. Improve this answer. You can find it by clicking the question mark top right while editing.

Add a comment. Active Oldest Votes. Improve this answer. Community Bot 1. Jeremy Smyth Jeremy Smyth 5 5 bronze badges. I left that current root password field blank but only the error changed. Access denied for user 'root' 'localhost' using password: NO ". It means you have to remove mysql and installed it again — Hackerman. In that case you'll have to reset your existing password using one of the many answers for that on here, or perhaps just wipe your MySQL data directory on this machine if you don't need it.

No need to reinstall. See Rolando's comment below re: "skip-grant-tables. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. I've less knowledge about configuring Windows, how can I add items to the firewall list? Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science.

Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.