Nos conectamos a la BBDD (RDS)
mysql -h clientes-db01.c1b1gpl8oc34.eu-west-1.rds.amazonaws.com -u root -p
Verificamos que el usuario que queremos modificar existe:
mysql> SELECT user, host, db, select_priv, insert_priv, grant_priv FROM mysql.db where db = 'clientes';
+------------+------+------------+-------------+-------------+------------+
| user | host | db | select_priv | insert_priv | grant_priv |
+------------+------+------------+-------------+-------------+------------+
| clientes | % | clientes | Y | Y | N |
+------------+------+------------+-------------+-------------+------------+
y su password, encriptada:
mysql> SELECT user, host, password, select_priv, insert_priv, shutdown_priv, grant_priv FROM mysql.user where user = 'clientes';
+------------+------+-------------------------------------------+-------------+-------------+---------------+------------+
| user | host | password | select_priv | insert_priv | shutdown_priv | grant_priv |
+------------+------+-------------------------------------------+-------------+-------------+---------------+------------+
| clientes | % | *AE727CCE1B8DA6E59EAB603DE688F0432F28AAA6 | N | N | N | N |
+------------+------+-------------------------------------------+-------------+-------------+---------------+------------+
Con el siguiente comando, modificaremos el password, para el usuario clientes:
SET PASSWORD FOR 'clientes'@'%' = PASSWORD('abcdefg123456');
y su password nueva, encriptada:
mysql> SELECT user, host, password, select_priv, insert_priv, shutdown_priv, grant_priv FROM mysql.user where user = 'clientes';
+------------+------+-------------------------------------------+-------------+-------------+---------------+------------+
| user | host | password | select_priv | insert_priv | shutdown_priv | grant_priv |
+------------+------+-------------------------------------------+-------------+-------------+---------------+------------+
| clientes | % | *031BCE7180CAD8A1E330DC840CE56E548369994E | N | N | N | N |
+------------+------+-------------------------------------------+-------------+-------------+---------------+------------+