JAEN

SQL

ALTER USER

CautionChange passwords/expiry

ALTER USER 'user'@'host' IDENTIFIED BY '<new>';

Rotates passwords and expiry — coordinate app config updates in the same change window.

Examples

  • ALTER USER 'webapp'@'%' IDENTIFIED BY 'N3w-S3cret!';Rotate an app user's password

Syntax

ALTER USER 'u'@'h' IDENTIFIED BY 'pw' [PASSWORD EXPIRE];

Before you run it

Old credentials fail the instant you rotate.

Related commands

The same reference, with no signal at all

Every command on this site, held on your device. The app adds 632 more: 1,510 commands and 120 fix flows, searchable with no connection. Free to install, no ads (some content is a one-time purchase).

Get it free on the App Store