Error: SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('root'@'localhost') does not exist

I am receiving this error when trying to add/remove database users on my Plesk Obsedian server.

Unfortunately, the release version of MariaDB I'm using, 10.4.x, is not officially supported by them even though I installed the update via their instructions.

No matter.

Can someone provide a simple step by step to fix the problem?

I am not a database wizard, but I can dabble a bit in command line, and I'm terrific at copying and pasting.

Thanks.

Gene Steinberg

Answer Answered by André Mornard in this comment.

This request occured 7 months ago, but the answer still may be usefull for anybody encountering the same issue. I personnaly had the same message when I tried to create a view that relied on other views that did not exist in the schema or which definer user was not recognised by Mariadb. The solution is quite obvious: 1) Ensure that the definer user exists in your database. Create him if needed and do not forget to flush privileges. 2) Create or alter the dependances views with the correct definer user. 3) Create or alter the view for which the message occured with the correct definer user.

Sorry for Gene. I hope he found a solution by himself.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.