记录一次MySQL主从同步时候出现的错误代码1449

今天在做主从同步的时候,在show slave status\g的时候出现下面的错误:

The user specified as a definer (‘root’@’192.168.1.116’) does not exist

在网上找了一下,说是权限的问题

解决办法:
mysql> grant all privileges on *.* to root@"%" identified by ".";
Query OK, 0 rows affected (0.00 sec)


mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
记录一次MySQL主从同步时候出现的错误代码1449
0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
Scroll to top
0
Would love your thoughts, please comment.x
()
x