Erico Morais
New Pleskian
Hy!
We had an issue earlier today that led to a failure in our SiteBuilder, which was rendered unavailable for our customers. So we decided to remove SiteBuilder and then install it again but we're now facing the following error during the installation:
"Access denied for user 'local_mysql_root'@'localhost' (using password: YES)"
This "local_mysql_root" user is properly created in our MySQL Server (the one where the customer's DBs are stored) and it features global privileges including Grant, so I assume this issue is strictly related to its password.
I can't seem to find much about this user online, how can I see what password Plesk is trying to log in with? I guess a simple password reset for that MySQL user would do it but, since this isn't Plesk's "admin" user, I assume its password can't be reset from "plesk sbin psadb".
Here's the full output:
Thanks!
We had an issue earlier today that led to a failure in our SiteBuilder, which was rendered unavailable for our customers. So we decided to remove SiteBuilder and then install it again but we're now facing the following error during the installation:
"Access denied for user 'local_mysql_root'@'localhost' (using password: YES)"
This "local_mysql_root" user is properly created in our MySQL Server (the one where the customer's DBs are stored) and it features global privileges including Grant, so I assume this issue is strictly related to its password.
I can't seem to find much about this user online, how can I see what password Plesk is trying to log in with? I guess a simple password reset for that MySQL user would do it but, since this isn't Plesk's "admin" user, I assume its password can't be reset from "plesk sbin psadb".
Here's the full output:
Code:
Installation started in background
Determinando os pacotes que precisam ser instalados.
Baixando arquivo SITEBUILDER-WIN_17.8.12/dist-windows/sitebuilder-core.msi: completado.
Baixando arquivo SITEBUILDER-WIN_17.8.12/dist-windows/sitebuilder-headers.msi: completado.
Baixando arquivo SITEBUILDER-WIN_17.8.12/dist-windows/sitebuilder-presets.msi: 0%
Baixando arquivo SITEBUILDER-WIN_17.8.12/dist-windows/sitebuilder-presets.msi: 100% foi concluído.
Instalando pacotes
Installing Web Presence Builder Core...
MSI: Error! Critical action 'Create Web Presence Builder database...' failed:
Command "D:\Program Files (x86)\Plesk\admin\bin\local_mysql_helper.exe" --create-database-and-user -database sitebuilder5 -database-user sitebuilder -database-user-password * failed with code 1. Output: mysqlmng failed: Failed to connect to database: Access denied for user 'local_mysql_root'@'localhost' (using password: YES)
at (MySQLDatabaseProvider::connect line 416)
at execute console command --exist-user(vconsoleapp::start line 93)
at execute "D:\Program Files (x86)\Plesk\admin\bin\mysqlmng" --exist-user "--user-login=sitebuilder"(vconsoleapp::run line 110)
(Error code 1)
at (CmdAction::Commit line 391)
at Execute action Create Web Presence Builder database...(executeList line 268)
Failed to install 'C:\ParallelsInstaller\parallels\SITEBUILDER-WIN_17.8.12\dist-windows\sitebuilder-core.msi': Fatal error during installation. (Error code 1603)
Error: The installation of the package 'sitebuilder-core' failed with code 1603. (install: Installing Web Presence Builder Core...)
Thanks!