Manage Users

Crear usuario

https://dev.mysql.com/doc/refman/8.0/en/create-user.html https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql

CREATE USER 'USER_NAME'@'localhost' IDENTIFIED WITH authentication_plugin BY 'USER_PASSWORD';

Actualizar usuario

Cambiar la contraseña (USER_NEW_PASSWORD) de un usuario (USER_NAME) https://dev.mysql.com/doc/refman/8.0/en/alter-user.html

ALTER USER 'USER_NAME'@'localhost' IDENTIFIED WITH authentication_plugin BY 'USER_NEW_PASSWORD';

Cambiar el nombre (NEW_USER_NAME) de un usuario (OLD_USER_NAME) https://dev.mysql.com/doc/refman/8.0/en/rename-user.html

RENAME USER 'OLD_USER_NAME'@'localhost' TO 'NEW_USER_NAME'@'localhost';

Eliminar usuario

https://dev.mysql.com/doc/refman/8.0/en/drop-user.html

DROP USER 'USER_NAME'@'localhost';