Lost admin user ; Update not allowed on current user in MySQL
1
vote
1
answer
118
views
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
Asked by Danish
(11 rep)
Jan 3, 2021, 09:30 AM
Last activity: Jan 3, 2021, 10:05 AM
Last activity: Jan 3, 2021, 10:05 AM