Why mysql server ignore cancel while deleting user

Question

I created user called "Try" where global privileges I set it to all privileges

and once I checked it and delete it with "Drop the databases that have the same names as the users." checkbox checked

and go ahead click "go" I get this pop up

and click on "OK" as soon as I clicked I get the second warning pop up which is the following

and then click on cancel but process was not canceled because the user was removed and i got the success message which is the following

so I really wanna know that if there is any further configuration for that and if not why this happen or if it is unique problem for me only thanks in advanced

They're two separate confirmations. You said yes to the first one, so it did that step. You said no to the second one, so it didn't do that step. It did exactly what you told it to do. — ceejayoz, Jul 01 '20 at 00:23

score 2 · Accepted Answer · answered Jul 01 '20 at 06:42

There is no "Cancel" feature in MySQL. MySQL only executes SQL queries written in SQL language.

PHPMyAdmin is a convenience tool to execute SQL queries on MySQL server. When you perform an operation in PHPMyAdmin, it will execute one or more SQL queries on the server.

In this particular case, it first executes the DROP USER SQL query, and then shows a confirmation if you really want to DROP DATABASE.

There is no transaction here, so each step is executed individually.

Why mysql server ignore cancel while deleting user

1 Answers1