mysql常用命令

开启远程访问权限

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

修改用户密码
UPDATE user SET password=PASSWORD('kerberos') WHERE user='root';