MySQL: Can't find any matching row in the user table

Asked Feb 22 '16 at 08:39

Active Feb 22 '16 at 11:08

Viewed 1,664 times

When I want to give a user full permission to the database like this:

GRANT PROXY ON 'homestead'@'%' TO 'homestead'@'localhost' WITH GRANT OPTION;

Users:

 +-----------+
    | User      |
    +-----------+
    | homestead |
    | homestead |
    | root      |
    | mysql.sys |
    | root      |
    +-----------+

It returns:

Can't find any matching row in the user table

edited Feb 22 '16 at 11:08

Ash

3,242
2
23
35

asked Feb 22 '16 at 08:39

Jamie

10,302
32
103
186

please check your environment using 'php artisan env' if it is local in homestead then you can run your migration. – Gautam Patadiya Feb 22 '16 at 08:45
That's just the point I can't! – Jamie Feb 22 '16 at 08:45
may be it is possible your environment is production because homestead default has permissions. – Gautam Patadiya Feb 22 '16 at 08:46
Please see my edit for .env file – Jamie Feb 22 '16 at 08:52
Shouldn't your query be: `GRANT PROXY ON homestead.* TO`? – Ash Feb 22 '16 at 08:59
@ash You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.* TO' at line 1 – Jamie Feb 22 '16 at 09:05
Ignore that - what you're doing is fine. I'm trying to understand the error - when you run that `GRANT` query does it respond with that `Can't find...` error? – Ash Feb 22 '16 at 09:13
Yes this is the error: ERROR 1133 (42000): Can't find any matching row in the user table – Jamie Feb 22 '16 at 09:15
So next question is does the `homestead` user exist on BOTH databases? – Ash Feb 22 '16 at 09:21
Yes it does exist in both. – Jamie Feb 22 '16 at 09:30

MySQL: Can't find any matching row in the user table

0 Answers0