New to databases and accidentally removed privileges from root user; only privileges I currently have are USAGE and PROXY. This is a MySQL database that I access through HeidiSQL. Currently cannot access my data tables; is there a way to get these privileges restored? Did not create any other user accounts.
You can use following steps to regrant root priviledge.
mysqlonly, No need to input password
-p, maybe No need to input username
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';