修改/etc/my.cnf
old_passwords = 1
//old_passwords = 1为16位
//所以这里要先
//SET old_passwords = 0;
//这样使新密码的长度也变成41位
修改前:
修改后
UPDATE mysql.user SET Password = PASSWORD('password') WHERE user = 'zabbix';
修改/etc/my.cnf
old_passwords = 1
//old_passwords = 1为16位
//所以这里要先
//SET old_passwords = 0;
//这样使新密码的长度也变成41位
修改前:
修改后
UPDATE mysql.user SET Password = PASSWORD('password') WHERE user = 'zabbix';