Issue Help. Plesk UbuntAfter update MariaDB from 10.1 to MariaDB 10.6 I can't access the databases

[MiguelSS]

Server operating system version

Plesk Obsidian

Plesk version and microupdate number

Versión 18.0.43

Hi everybody,

I hope you can help me in this issue.
Everything was fine before I update MariaDB from 10.1 to 10.6 (with this instructions: https://support.plesk.com)

Now, I can't access to my plesk. This is the error:

Type	Plesk\Exception\Database
Message	DB query failed: SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES)
File	Mysql.php
Line	79

But I read in other post in the forum, that I need to insert in the my.cnf
[mysql]
skip-grant-tables

With the Skip grant Tables I can access, but I can't use the databases.
So maybe you can help me on my issue.

Thanks in advance to help a newer pleskian ;-)

 

[Maarten.]

Hi,

What's the bind-address in my.cnf?

Resolved - systemctl start mariadb (10.6 error)

i got this error when i updated mariadb with new plesk update ● mariadb.service - MariaDB 10.6.5 database server Loaded: loaded (/usr/lib/systemd/system/./mariadb.service; disabled; vendor preset: disabled) Drop-In: /etc/systemd/system/mariadb.service.d...

talk.plesk.com

 

[MiguelSS]

Only to add more info. With the skip-gran-tables, this is the error on plesk:
Error: SQLSTATE[HY000]: General error: 1290 The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement

 

[MiguelSS]

Hi maartenv,

Thanks for your help. I don't have any bind-address in my.cnf:
This is what I have (attached)


Thanks again!

 

[IgorG]

skip-grant-tables is a temporary option to fix the original problem and you do not need to use MariaDB with this option enabled.
Find the solution in the KB articles and follow them strictly.

 

[MiguelSS]

Hi Igor,

Thanks, but can you helpme a little bit more? Where is the solution?
Sorry to be "newer"

 

[IgorG]

Hi Igor,

Thanks, but can you helpme a little bit more? Where is the solution?
Sorry to be "newer"

The solution in KB articles. For example, just use search by "Access denied for user 'admin'@'localhost'" phrase.
After that, you will find such article, for instance:

https://support.plesk.com/hc/en-us/articles/213364309-Unable-to-access-Plesk-GUI-Access-denied-for-user-admin-localhost-using-password-YES-

 

[MiguelSS]

Thanks Igor,
I have done your recommendation, but without success.
Any other idea o suggestion?
Really appreciate your help!

 

[IgorG]

but without success.

Contact Plesk Support Team in this case.

How to get support directly from Plesk?

Question How to get support directly from Plesk? Answer Lease-type Plesk licenses purchased directly from Plesk running on supported Plesk version include full free support. Perpetual-type license...

support.plesk.com