Error: Connection to the database server has failed: The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

Created:

2016-11-16 13:18:24 UTC

Modified:

2017-08-08 13:38:43 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Error: Connection to the database server has failed: The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

Applicable to:

  • Plesk 12.0 for Windows
  • Plesk 12.5 for Windows

Symptoms

Cannot create a new database user:

Error: Connection to the database server has failed: The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

OR

Plesk upgrade fails:

    MSI: Error! Critical action 'Initializing Task Manager database...' failed:
Command "C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\bin\\local_mysql_helper.exe" --create-database-and-user -database task_m
anager -database-user task_manager -database-user-password * failed with code 3. Output: Database task_manager successfully c
reated
mysqlmng failed: Can't execute GRANT ALL ON `task\\_manager`.* TO 'task_manager'@'localhost' IDENTIFIED BY '*********': MySql error 1290:The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
at (MySQLDatabaseProvider::execute line 511)
at execute console command --add-user(vconsoleapp::start line 100)
at execute "C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\bin\\mysqlmng.exe" --add-user "--database=task_manager" "--new-use
r-login=task_manager" "--new-user-password=*" "--allowed-host=localhost"(vconsoleapp::run line 117)
(Error code 1)

Cause

MySQL Server is started with skip-grant-tables option.

Resolution

  1. Locate the my.ini of the MySQL Server (by default, C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL\data)

  2. Remove skip-grabt-tables from my.ini file

  3. Restart MySQL Server service

Have more questions? Submit a request
Please sign in to leave a comment.