I work on MySQL. For making my database more secure I created new user and than deleted 'root' user which had all privileges. I think I did not give full privileges to new user. That's why it is giving error whenever I try to update a table in database.
UPDATE command denied to user 'crm_user'@'localhost' for table
In case I lost the superuser (in my case it was root) how can I retrieve or get all privileges to get control on my DB. DB is installed on my VPS so I have full control whatever need to do but I have no idea what to do. Please help. Thanks