mysql - Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges? -

i continuously receiving error.

i using mysql workbench , finding root's schema privileges null. there no privileges @ all.

i having troubles across platforms server used , has been of sudden issue.

root@127.0.0.1 apparently has allot of access logged in that, assigns localhost anyways - localhost has no privileges.

i have done few things flush hosts, flush privileges, ect have found no success or internet.

how can root access back? find frustrating because when around people expect "have access" don't have access can't go command line or , grant myself anything.

when running show grants root in return: error code: 1141. there no such grant defined user 'root' on host '%'

thanks can provide help

use the instructions resetting root password - instead of resetting root password, we'll going forcefully insert record mysql.user table

in init file, use instead

insert mysql.user (host, user, password) values ('%', 'root', password('yourpassword')); grant on *.* 'root'@'%' grant option;