Solution to 1449 and 1045 exceptions when connecting to MySQL

Solution to 1449 and 1045 exceptions when connecting to MySQL

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

Import the SQL to the local computer, execute the stored procedure or view the video error:

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

Permission issue, grant root all sql permissions

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


mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
#MySQL

1045 exception occurred during connection:

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

If it is MySQL 5.6 or later, 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.

Type FLUSH PRIVILEGES; to refresh the database.

If you have any questions, please leave a message or come to the community to discuss. Thank you for reading and I hope it can help you. Thank you for your support of this site!