Tuesday, December 03, 2024

MySQL 8.0.39 Grant problem.

A user with all privileges wasn't able to update a Procedure, got error below.

ERROR 1227: Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation.

We fixed it by running 

GRANT SYSTEM_USER ON *.* TO 'userWithProblem'; 

Still connected as user 'userWithProblem'



at No comments:
Labels: , ,
Subscribe to: Posts (Atom)

MySQL to MariaDB

 Here is a good description how to migrate to MariaDb MySQL to MariaDb Example of how to dump data from MySQL port=3307: mysqldump --user=ro...

  • Visual Studio 2010 versus COM-Object fails
    When converting an VB2008 application to VB2010 I run into trouble regarding COM objects while compiling.  you get errors like: Error    1...
  • vb.net how to set Structures and Enum global
    In a module you have declared a Structure or Enum that you will use through out a project. Module Module1 Public Structure dummy ...
  • (no title)
    Apache2 crashes on Ubuntu Linux 22.04.5 after Zabbix was updated to 7.0.26 During a upgrade of my Ubuntu server there was a new package for ...