4 years ago

Category: MySQL

Unfortunately, we come across a situation where our root user become unprivilege what does it mean? root user does not have rights to perform operations on databases. There is one solution, if you have any other privilege user so you can assign all privileges to root user but the case become worse when you don’t have any other user except root user.

The solution is simple you need to update all root privileges fields in user table (mysql database) but you can’t perform that operation because your root user don’t have rights instead of directly updating or executing query you could use mysqld — mysql daemon (service which is running in the background).

Now your root become privileged and will have rights to perform any sort of operation.