1044 - Access denied for user 'homestead'@localhost

Question

Hi I'm not sure if this asked already but it looks like the other related questions aren't the same. Here's what happened

I've got phpmyadmin installed with my homestead. I was trying to explore how privileges will affect access to database.

What I did. I removed global access for user homestead and now I have no more database on my phpmyadmin and if I try to create a database, I get this error:

#1044 - Access denied for user 'homestead'@'%' to database

How do I correct or revert back

http://stackoverflow.com/questions/1709078/how-can-i-restore-the-mysql-root-user-s-full-privileges << Check that out, it should help — Rick Calder, May 16 '17 at 04:01

score 1 · Accepted Answer · answered May 16 '17 at 04:01

1

You can try

 GRANT ALL ON *.* TO 'homestead'@'%' IDENTIFIED BY 'password';

and then refresh the privileges with

FLUSH PRIVILEGES;

answered May 16 '17 at 04:01

Dominik Mayrhofer

459
9
19

Where in phpmyadmin shall I apply this? – Rodney Zanoria May 16 '17 at 04:02
You should have SQL. There you can enter the code and run it with ok. – Dominik Mayrhofer May 16 '17 at 04:04
I get this error code: #1045 - Access denied for user 'homestead'@'%' (using password: YES) – Rodney Zanoria May 16 '17 at 04:05
do you get the error at login or can you access the phpmyadmin page? – Dominik Mayrhofer May 16 '17 at 04:06
if you cant access the UI you should be able to change the rights with the shell. First changing to mysql with 'myql -u root -p' and then execute the statements i posted above. – Dominik Mayrhofer May 16 '17 at 04:10
when i go ti information_schema > user privileges, I see Grantee > homestead'@'% | Table_Catalog > def | Privilege_Type >usage | is_grantable >No. Does this help? – Rodney Zanoria May 16 '17 at 04:16
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/144303/discussion-between-rodney-zanoria-and-mayrhofer). – Rodney Zanoria May 16 '17 at 04:28

1044 - Access denied for user 'homestead'@localhost

1 Answers1