Unable to install SpamAssassin: Access denied for user 'local_mysql_root'@'localhost'

Refers to:

  • Plesk 11.5 for Windows
  • Plesk 12.5 for Windows

Created:

2016-11-16 13:25:51 UTC

Modified:

2016-12-21 20:41:44 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to install SpamAssassin: Access denied for user 'local_mysql_root'@'localhost'

Symptoms

Unable to install SpamAssassin:

installing SpamAssassin...
MSI: Error! Critical action 'Creating bayes database...' failed:
Command "C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\bin\\local_mysql_helper.exe" --create-database-and-user -database sa_bayes -database-user sa_bayes -database-user-password * failed with code 3. Output: mysqlmng failed: Failed to connect to database: Access denied for user 'local_mysql_root'@'localhost' (using password: YES)
at (MySQLDatabaseProvider::connect line 420)
at execute console command --exist-user(vconsoleapp::start line 100)
at execute "C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\bin\\mysqlmng.exe" --exist-user "--user-login=sa_bayes"(vconsoleapp::run line 117)
(Error code 1)

Cause

User local_mysql_helper.exe does not exist in MySQL or it has incorrect password.

Resolution

Recreate local_mysql_helper.exe user:

"%plesk_bin%\\mysqlmng.exe" --add-local-super-user
Have more questions? Submit a request
Please sign in to leave a comment.