Crea los logins correspondientes para cada usuario con la contraseña generada de la siguiente manera:

CREATE USER 'nicolas'@'localhost' IDENTIFIED BY 'nicolas';
CREATE USER 'juan'@'localhost' IDENTIFIED BY 'juan';
CREATE USER 'sofia'@'localhost' IDENTIFIED BY 'sofia';
CREATE USER 'miguel'@'localhost' IDENTIFIED BY 'miguel';