1449 and 1045 exceptions occurred when connecting to MySQL. Solution: mysql1449

1449 and 1045 exceptions occurred when connecting to MySQL. Solution: mysql1449

How can I solve 1449 and 1045 exceptions when I connect to MySQL?

Mysql 1449: The user specified as a definer ('root' @ '%') does not exist Solution

Import the SQL statement to the local machine, execute the stored procedure or view the video, and report the following error:

Mysql 1449: The user specified as a definer ('root' @ '%') does not exist Solution

Permission issues: grant root all SQL Permissions

Mysql> grant all privileges on *. * to root @ "%" identified ". "; SQLException: The user specified as a definer ('book' @ '%') does not exist: solution grant all privileges on *. * to ebook @ "%" identified ". "; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) # Mysql

1045 exception during connection:

If it is earlier than mysql 5.6, enter UPDATE mysql. user SET Password = PASSWORD ('000000') WHERE User = 'root ';

For mysql 5.6 and later versions, enter UPDATE mysql. user SET authentication_string = PASSWORD ('root') where user = 'root ';

This is because there is no password field in the user table after 5.6.

Enter flush privileges and refresh the database.

If you have any questions, please leave a message or go to the community on this site for discussion. Thank you for reading this article. Thank you for your support!