MySQL Forums
Forum List  »  Install & Repo

MySQL 5.7.16 lost root privileges
Posted by: Marco Bonciolini
Date: July 02, 2017 07:09AM

i have a strange issue on a web server (Windows Server 2012) with MySQL 5.7.16. Root lost privileges, i don't know why.

If i type mysql -uroot -ppassword appear an error (root@127.0.01) Access Denied using password YES

I tried to use another user with all privileges and i've seen that in host there is only localhost (not

How can i login with root@localhost and not with root@ It's very frustrating... Every account trying to use @ or @::1 but there exist only localhost in host and i can't change it.

So i don't know how to fix it.

Options: ReplyQuote

Written By
MySQL 5.7.16 lost root privileges
July 02, 2017 07:09AM

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.