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

1 year ago Gene Steinberg

It doesn't refer to the error above.

Can I have a real solution please?

 
1 year ago Gene Steinberg

Again, I'm not seeing a direct solution in that document to which I was referred.

I tried a couple and they didn't seem to be supported or help.

Is there something that I can use (SQL or Linux command line) to address the above problem on my server?

I posted a thread on the Plesk forum, since it's a Plesk server, and mostly got insults.

Please.

Peace, Gene

 
5 months ago André Mornard

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.

 
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.