Using a configuration file for mysql is a good practice as you don't immediately expose credentials. Below, you are going to mysql cli and immediately using the db named dbName. 1mysql --defaults-file=/path/to/credentials.ini dbName where credentials.ini has this format: 1[client] …

1curl --config /path/to/config-file <url_here> where config-file has this format: 1-u username:password

Go to drupal root, then: 1drush upwd --password="newPassword_here" "the_user" More info in https://www.drupal.org/node/44164

1curl -u user:password <url_here>

1[root@rh icasimpan]# /usr/local/bin/automysqlbackup /etc/automysqlbackup/rh.conf 2Parsed config file "/etc/automysqlbackup/automysqlbackup.conf" 34# Checking for permissions to write to folders: 5base folder /var/lib ... exists ... ok. 6backup folder /var/lib/automysqlbackup ... exists ... writable? yes. …

Go to drupal root, then: 1drush st --show-passwords database In drush 9.7.2 (may also work for other sub-versions of drush 9), the following command should be used: 1drush st DB

For as long as you have root access to MySQL, this would work: 1UPDATE mysql.user SET Password=PASSWORD('new-password-here') WHERE USER='user-name-here' AND Host='host-name-here'; more details from https://www.cyberciti.biz/faq/mysql-change-user-password/