Unable to set MySQL password even after "mysqld --initialize" (homebrew)

Asked Jun 08 '17 at 00:16

Active Jun 08 '17 at 00:17

Viewed 420 times

I understand this question has been asked many times on this forum, but I'm unable to log into the root for MySQL even after running mysqld --initialize, which sets a temporary password.

When I run mysql -uroot -p and enter the temporary password, I get:
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

I also tried: mysql -u root -h 127.0.0.1 -p and setting the password this way but I got a similar error as above (except using password: YES)

What is my course of action?

edited Jun 08 '17 at 00:17

asked Jun 08 '17 at 00:16

thingdr

what version are you using? – Jeric Cruz Jun 08 '17 at 00:17
5.7.18 based on brew info mysql – thingdr Jun 08 '17 at 00:18
have you tried using GUI? – Jeric Cruz Jun 08 '17 at 00:21
what do you mean? Can you give further information/context? – thingdr Jun 08 '17 at 00:22
Possible duplicate of [MacOSX homebrew mysql root password](https://stackoverflow.com/questions/9695362/macosx-homebrew-mysql-root-password) – Jeric Cruz Jun 08 '17 at 00:25

Unable to set MySQL password even after "mysqld --initialize" (homebrew)

0 Answers0