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

Created:

2016-11-16 13:25:51 UTC

Modified:

2017-08-16 16:33:55 UTC

0

Was this article helpful?


Have more questions?

Submit a request

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

Applicable to:

  • Plesk 11.x for Windows
  • Plesk 12.5 for Windows

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

4 Comments

  • 0
    Avatar
    Ahmed

    I couldn't find the file "mysqlmng.exe" in bin folder

  • 1
    Avatar
    Artyom Baranov

    Hi Ahmed,

    %plesk_bin% is a shortcut for `C:\Program Files (x86)\Parallels\Plesk\admin\bin`

    and for just `bin` folder the shortcut %plesk_cli% is used.

    Please compare:

    >cd %plesk_bin%

    C:\Program Files (x86)\Parallels\Plesk\admin\bin

    >cd %plesk_cli%

    C:\Program Files (x86)\Parallels\Plesk\bin>

    So, please check `C:\Program Files (x86)\Parallels\Plesk\admin\bin` for `mysqlmng.exe`

  • 0
    Avatar
    Ahmed

    thank you @Artyom :)

     

    now I'm getting this error

    C:\Program Files (x86)\Plesk\admin\bin>mysqlmng.exe --add-local-super-user

    The system cannot find the file specified. (Error code 2) at RegOpenKeyEx subKey
    =SOFTWARE\MySQL AB\MySQL Server 0.0
       at (registry::open line 49)
       at execute console command --add-local-super-user(vconsoleapp::start line 122
    )
       at execute mysqlmng.exe --add-local-super-user(vconsoleapp::run line 139)

  • 0
    Avatar
Please sign in to leave a comment.