Bug #83822 Confusing "ERROR 1133 (42000): Can't find any matching row in the user table"

• Submitted: 15 Nov 2016 9:45
• Reporter: Roel Van de Paar
• Status: Open
• Category: MySQL Server: Security: Privileges
• Severity: S4 (Feature request)
• Version: 5.7
• OS: Any
• CPU Architecture: Any

[15 Nov 2016 9:45] Roel Van de Paar

Description:
mysql> GRANT ALL PRIVILEGES ON test.* TO 'user@%';
ERROR 1133 (42000): Can't find any matching row in the user table
mysql> GRANT ALL PRIVILEGES ON test.* TO 'user@%' IDENTIFIED BY 'pwd';
Query OK, 0 rows affected, 1 warning (0.00 sec)

There are many people confused by this message, myself included.
http://forums.mysql.com/read.php?11,70424,70426#msg-70426
Is one of them. 
Search for "ERROR 1133 (42000): Can't find any matching row in the user table" for many more examples.

How to repeat:
GRANT ALL PRIVILEGES ON test.* TO 'user@%';

Suggested fix:
"ERROR 1xxx (42xxx): Cannot add user if no password is supplied via an IDENTIFIED BY 'password' clause. 

Or similar.

[4 May 2019 10:06] Nabila S

I am working on Koha ILMS (Ubuntu 16.04) which uses MySQL 5.7.26. When I try to uninstall Koha, using:

sudo koha-remove instancename

it should simply delete everything related to "instancename" from koha. But it gives error:

ERROR 1133 (42000) at line 1: Can't find any matching row in the user table

I did following solutions:

- Checked if User attached to "instancename" is available. (Ans: Yes)
- Checked if all Grants are allowed to user (Ans:Yes)
- Checked if User is having password. (Ans: Yes)
- Checked if mysql_secure_installation security tweak has been run (Ans: Yes)
- Recreated user
- Flush Privileges;
- Recreated New Koha Instance and tried to delete that. But Same error 1133 occures.