General error: 1449 The user specified as a definer

0
votes

I installed new system (Ubuntu 20.04), I installed LAMP and cloned Laravel project. I created database blog and I wanted to migrate but I have this error.

SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('mysql.infoschema'@'localhost') does not exist (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABLE')

How can I solve this problem?

1
phpmysqllaravel
Change username to root, and as i expect your root does not have a password, so just set empty password. - mohammad.kaab

1 Answers

0
votes

Are you running MySQL 8?

mysql.infoschema is an account that comes with MySQL. If your system does not have one, make sure you have run mysql_upgrade.