Brian: /* How to enable Show Engine Innodb Status */

2022-02-25T03:55:08Z

‎How to enable Show Engine Innodb Status

Brian: Created page with "==How to enable Show Engine Innodb Status== Are you trying to see the latest deadlocks or foreign key errors but run in to the following error: [Error Code: 1227, SQL State:..."

2022-02-25T03:54:40Z

Created page with "==How to enable Show Engine Innodb Status== Are you trying to see the latest deadlocks or foreign key errors but run in to the following error: [Error Code: 1227, SQL State:..."

New page

==How to enable Show Engine Innodb Status==

Are you trying to see the latest deadlocks or foreign key errors but run in to the following error:

[Error Code: 1227, SQL State: 42000] Access denied; you need (at least one of) the PROCESS privilege(s) for this operation

When this happens you will need to grant your user the PROCESS privilege.

GRANT SELECT, PROCESS ON *.* TO 'youruser'@'localhost';

===Creating a new user to view Show Engine Innodb Status===

Sometimes you find that a client or yourself wants to view Show Engine Innodb Status and they want a new user to do this with.

Here are the standard commands to create and grant them the privileges:

CREATE USER '<youruser>'@'%' IDENTIFIED BY '<password>';
GRANT SELECT, PROCESS ON *.* TO '<youruser>'@'%';
FLUSH PRIVILEGES;

This is the bare minimum to enable them to run (Show Engine Innodb Status)

@@ Line 7: / Line 7: @@
 When this happens you will need to grant your user the PROCESS privilege.
-  GRANT SELECT, PROCESS ON *.* TO 'youruser'@'localhost';
+  GRANT SELECT, PROCESS ON *.* TO '<youruser>'@'localhost';
 ===Creating a new user to view Show Engine Innodb Status===
@@ Line 15: / Line 15: @@
 Here are the standard commands to create and grant them the privileges:
-  CREATE USER '<youruser>'@'%' IDENTIFIED BY '<password>';
+  CREATE USER '<newuser>'@'%' IDENTIFIED BY '<password>';
-  GRANT SELECT, PROCESS ON *.* TO '<youruser>'@'%';
+  GRANT SELECT, PROCESS ON *.* TO '<newuser>'@'%';
   FLUSH PRIVILEGES;
 This is the bare minimum to enable them to run (Show Engine Innodb Status)

How to enable Show Engine Innodb Status - Revision history

Brian: /* How to enable Show Engine Innodb Status */

Brian: Created page with "==How to enable Show Engine Innodb Status== Are you trying to see the latest deadlocks or foreign key errors but run in to the following error: [Error Code: 1227, SQL State:..."