mysql 允许所有ip都可访问

2022-10-18 本文已影响0人骑着大象去上班

mysql 允许所有ip都可访问

use mysql
update user set host='%' where user ='root';
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;