the user pecified as a definer ('mysql.infoschema'@localhost) does not exist
时间: 2023-08-09 16:06:54 浏览: 150
mysql中user
This error message indicates that the specified user, 'mysql.infoschema'@localhost, does not exist in the MySQL database. To resolve this issue, you can either create the user or modify the existing user to match the specified definer.
To create the user, you can use the following query:
```sql
CREATE USER 'mysql.infoschema'@localhost IDENTIFIED BY 'password';
```
Replace 'password' with the desired password for the user.
If the user already exists but has a different definer, you can modify the user using the following query:
```sql
ALTER USER 'mysql.infoschema'@localhost DEFINER = CURRENT_USER;
```
This will set the definer to the current user executing the query.
Remember to replace 'mysql.infoschema' with the appropriate username and 'localhost' with the correct host if needed.
阅读全文