Question Updating mariadb password

[Dukemaster]

Hi friends of Plesk,
I never used a special password for mysql over 13 years using Plesk.
2 months ago I set a passwort for MariaDB 10.2 for the first time. Now I'm not able to login to do "mysql_upgrade".
I'm able to login psa database by

~# plesk db
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 1049
Server version: 10.2.18-MariaDB-1:10.2.18+maria~bionic mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [psa]>

But not with

root@server:~# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

The old passwort I have set doesn't work any longer. Perhaps it's expired or I use the wrong one.

Could you please help me to update/reset a new password for MariaDB 10.2 (Ubuntu18.04 + PLESK 17.8.11)?

Lots of greets

 

[virtubox]

Hi friends of Plesk,
I never used a special password for mysql over 13 years using Plesk.
2 months ago I set a passwort for MariaDB 10.2 for the first time. Now I'm not able to login to do "mysql_upgrade".
I'm able to login psa database by

~# plesk db
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 1049
Server version: 10.2.18-MariaDB-1:10.2.18+maria~bionic mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [psa]>

But not with

root@server:~# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

The old passwort I have set doesn't work any longer. Perhaps it's expired or I use the wrong one.

Could you please help me to update/reset a new password for MariaDB 10.2 (Ubuntu18.04 + PLESK 17.8.11)?

Lots of greets

Hello @Dukemaster

you can try to use :

MYSQL_PWD=$(cat /etc/psa/.psa.shadow) mysql -uadmin

 

[Dukemaster]

Thank you very much @virtubox. It worked fine. Thumbs up.
But I've already the problem that mysql_upgrade fails? Perhaps you know why?

root@server:~# mysql_upgrade
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
FATAL ERROR: Upgrade failed

Greets

 

[Dukemaster]

Thanks god for looking again in the PLESK SUPPORT ARTICLE (Ubuntu18.04) which I used to upgrade MariaDB 10.1 to 10.2 few weeks ago.
This article was updated exactly with the informations I needed now.
Magic quotes which leaded to success:

Upgrade MySQL databases:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin

Restart mysql service:

# service mariadb restart

Execute this command to update the package version inside Plesk:

# plesk sbin packagemng -sdf

Thanks for your time helping me and watching this thread. Next job is to change the root database password...
Greets