fixed order of mysql calls in new-credentials; suppressed deprecation warning in strengh/need view