mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost' - getting this error after my mac restarted itself

Question

I have Valet up and running on my computer - it was working fine until yesterday when my computer restarted and now I am getting this error

mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'

I dont understand why it would be working one day and then broken the next...

I am worried changing any settings will break it more as it was working prior to yesterday...

EDIT: other questions that are similar don't seem to work on MariaDB if I try and change privileges or update users I get this error ---

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'BY 'root'' at line 1

Check syntax error, may be try running SQL query manually first. — Juned, Sep 04 '19 at 07:16
They definitely are as I can access through sudo mysql -u root and brew services mariadb is started — Jaimee Page, Sep 04 '19 at 07:25

score 0 · Answer 1 · answered Sep 04 '19 at 07:11

0

Check your .env file; and confirm it against config/database.php; check if the credentials provided are correct.

answered Sep 04 '19 at 07:11

Kushal Arya

334
2
9

whereabouts would these files be located? – Jaimee Page Sep 04 '19 at 07:17
in application folder @JaimeePage – Kushal Arya Sep 04 '19 at 08:38

mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost' - getting this error after my mac restarted itself

1 Answers1