CODEWITHSUNDEEP
phpmysqlphpmyadminlaravel-5homestead
Rodney Zanoria
Rodney Zanoria

Reputation: 494

1044 - Access denied for user 'homestead'@localhost

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

Upvotes: 0

Views: 1100

Answers (1)

Dominik Mayrhofer
Dominik Mayrhofer

Reputation: 491

You can try

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

and then refresh the privileges with

FLUSH PRIVILEGES;

Upvotes: 1

Related Questions