General error error: 1449 when searching MySQL Bank records

Question

General error error: 1449 when searching MySQL Bank records

Navigation

#1 by (2 votes)

1

I'm getting the error below when doing SELECT:

SELECT * FROM vn_horario_view;

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

How do I resolve this error?

mysql sql query

asked by anonymous 22.02.2017 / 20:00

1 answer

How to allow only a certain word? How to change the Netbeans IDE language On the Mac?

score 2 · Accepted Answer

If you imported the objects from another database you may have lost some DEFINER .

Try:

SELECT CONCAT("ALTER DEFINER='youruser'@'host' VIEW ", 
table_name, " AS ", view_definition, ";") 
FROM information_schema.views 
WHERE table_schema='your-database-name';

You can also create a new user giving him full access, if everything runs correctly you delete root and rename the new user to root (Gambiarra)!

Same problem in SOen