Tried some commands with drop user but it dont work see picture.
Asked
Active
Viewed 106 times
-3
-
2Which user you are logged on? Add code as text not as image – Jens Mar 02 '22 at 08:00
-
normaly with root – Acivev Mar 02 '22 at 08:02
-
It looks like a problem of user rights : see post https://stackoverflow.com/questions/56946299/how-to-resolve-error-1396-hy000-operation-alter-user-failed-for-rootlocal – Mar 02 '22 at 08:02
-
Did you try to even google this before asking it here? Secondly, you are meant to type your questions rather than pasting screenshots. – nelsonsule Mar 02 '22 at 08:02
-
yes, i did but nothing found for it – Acivev Mar 02 '22 at 08:05
-
https://sebhastian.com/mysql-error-1396/#:~:text=The%20MySQL%20ERROR%201396%20occurs,from%20your%20MySQL%20database%20server. – Lkbhai Lr Mar 02 '22 at 08:08
-
Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. – Community Mar 04 '22 at 14:05
1 Answers
0
Revoke all Privileges first before to proceed to drop user
REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'bloguser'@'localhost';
DROP USER 'bloguser'@'localhost';
This was lifted from https://www.cyberciti.biz/faq/how-to-delete-remove-user-account-in-mysql-mariadb/
Always ensure you do a proper research before you come here to ask your questions

nelsonsule
- 334
- 2
- 8
-
It gives me this "ERROR 1269 (HY000): Can't revoke all privileges for one or more of the requested users" – Acivev Mar 02 '22 at 08:12
-
you should be doing this as a root user with all privileges granted. use the command ```SHOW GRANTS``` to see your privileges – nelsonsule Mar 02 '22 at 08:16
-
-
-
-
mysql Ver 15.1 Distrib 10.3.32-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 – Acivev Mar 02 '22 at 08:33
-
ok i found a solution for it. I used phpmyadmin and deleted it and worked. Thx btw for the help. – Acivev Mar 02 '22 at 08:42
-
Ok. I think what you should have done was first revoke all privileges then revoke grant option before dropping the user in that order. – nelsonsule Mar 02 '22 at 08:45