The data from the MariaDB database has not been completely deleted. How to clean by hand?

Question

MySQL

I deleted the user via cpanel. And then they turned off the light ... The process was not completed. Now I do not see this user in the system and decided to create it again. In the process of creation, it gave me this thing:

Cannot load from mysql.proc. The table is probably corrupted...

I made such a thing mysql_upgrade -uroot - but it didn't seem to help... How do I manually delete a user from the database?

Answer 1

is the base complete? could the base be corrupted

Answer 2

You need to try to restore the proc table from the mysql database. https://mariadb.com/kb/en/mariadb/repair-table/
USE mysql;
REPAIR TABLE proc;