ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist

This commonly occurs when exporting views/triggers/procedures from one database or server to another as the user that created that object no longer exists. So basically you need to make sure you use the correct user in your database for all your migrations.

It sounds like you have the wrong user in the first place. Also if you did add/delete/update users make sure you run flush privileges; in mysql to make sure all caches are cleared regarding privileges ;)

@greyeyes Did you try this?

mysql -u root -p
mysql> SET GLOBAL innodb_fast_shutdown = 1;
mysql_upgrade -u root -p

@greyeyes I'd create a new user in MySQL, grant privileges on the database and try to use it instead or do the same for an existing user.

GRANT ALL ON *.* TO 'someuser'@'%' IDENTIFIED BY 'complex-password';
FLUSH PRIVILEGES;

Use Host as below in your .env,

    DB_HOST=127.0.0.1

Hi @greyeyes, did you solve this issue? I'm pulling my hair with the same problem.

I'm also having the same problem. I've got mysql 8.0.15 Homebrew on both of my computers. When I run 'use db_name' from the iMac I get the' definer ('mysql.infoschema'@'localhost') does not exist' error. When I checked out what users are in the mysql.users table, mysql.infoschema did not show up as a user on the iMac, which is the one getting the error. On my air, that user does exist. Try: select host, user from mysql.user;

https://dev.mysql.com/doc/refman/8.0/en/stored-objects-security.html

Here is the solution: https://stackoverflow.com/questions/17780630/table-mysql-user-doesnt-existerror

Hi. I have the same problem (user mysql.infoschema does not exists in mysql.user table. I looked at gladgladwrap "solution" but it does not work for me. Can someone help please?

I tried more to skip this error but its still exist so I hope everyone solved it correctly to reply me how got it

welcome I wanna ask u about this error how can I skip thanks in advance

Is there anyone who solved this problem?

@merveerbilici I'm having the same issue.

I'm having the same issue.

I think I'm quite late to the party but if you have any triggers set on your tables and the user who created it, has been deleted, then you will run into this error. I was facing the same issue. Tried clearing cache, config but nothing worked. I checked my db and found that there was a trigger set on table. Removing that trigger from the table did the trick. If you have any definer statements in you sql file, you can remove them before restoring.

I hope this helps someone. Cheers :)