SQLSTATE HY000 1698 - Contacts MySQL

[inter-web]

Hi, I hope someone knows what is my mistake?

1.- RainLoop version: 1.16.0 - Browser: Firefox - OS: Ubuntu 20.04

2.- PDO contacts it's enable, but PDO MySQL don't connect. - Img: https://i.imgur.com/HBC9cRH.png

3.- When I try to connect the contacts in MySQL, in the administration panel, it sends that error: SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' and I have not found how to solve it. - https://i.imgur.com/A7PhcGS.png -

4.- The password for the root user has already been updated, root - root. - https://i.imgur.com/hjvbhDs.png

5.- MySQL service restarted, VPS upgraded, VPS restarted.

[contacts] ; Enable contacts enable = On allow_sync = On sync_interval = 20 type = "mysql" pdo_dsn = "mysql:host=127.0.0.1;port=3306;dbname=rainloop" pdo_user = "root" pdo_password = "root" suggestions_limit = 30 ~ ~

Thank You very much !

[inter-web]

I'm still looking and...

Contacts in Rainloop does not have a MySQL database. This creates the error and I think another one, I'll post the trailer on the solution.

[inter-web]

Solved! ~ 1.- There was no MySQL Database 1.1 - The database was created manually. CREATE DATABASE IF NOT EXISTS rainloop

2.- The user "rainloop" was created for PDO MySQL Contacts. CREATE USER [IF NOT EXISTS] 'rainloop'@'localhost' IDENTIFIED BY 'your-pass';

3.- All privileges and password were granted for that user. GRANT ALL PRIVILEGES ON 'rainloop' TO 'rainloop'@'localhost';

It worked: https://i.imgur.com/bAGUejm.png