mysql设置访问权限_MySQL

如果想设置其他主机通过密码访问本地mysql，可以设置

GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'passwd' WITH GRANT OPTION;