MySQL TIPS

1：

Message: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.

Solution：SET SQL_SAFE_UPDATES = 0;

2：

远程登录

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '110110' WITH GRANT OPTION;