Fix further 'mysql_user' vs ['mysql']['user'] issues

Should use the nested form throughout, was inconsistent. Also
removed the spec that there should be an error without defining
a username - we provide a default value of 'backup'.