2

Preface: Im aware that there are many related questions. I've combed through all that I could find but havent been able to fix this

I installed mysql for mac (Mac OS X 10.9 (x86, 64-bit), DMG Archive)

When I try to use the terminal I get 

Blythes-MacBook-Air:bin blythe$ mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Blythes-MacBook-Air:bin blythe$

Or...

Blythes-MacBook-Air:bin blythe$ mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Blythes-MacBook-Air:bin blythe$

Any help is appreciated.

Blythe Simmons
  • 143
  • 3
  • 10
  • Perhaps [this](http://stackoverflow.com/q/6474775/62576) will help. – Ken White Jun 18 '15 at 18:55
  • unfortunately, i still couldnt get it to work, i edited my question to address that – Blythe Simmons Jun 18 '15 at 19:06
  • The command you say you typed was `./mysql -u root`, but the output you show is for `mysqladmin`. Visit the link I provided again, and *carefully* read the answers posted (which include how to reset the root password from safe mode if needed). – Ken White Jun 18 '15 at 19:12
  • Yeah-that was my mistake. For the safe mode approach, i get this error when i input: `mysql -u root`, I get `ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)` – Blythe Simmons Jun 18 '15 at 19:22
  • The safe mode is supposed to be ongoing, but for me it ends with `150618 15:24:56 mysqld_safe Logging to '/usr/local/mysql/data/Blythes-MacBook-Air.local.err'. 150618 15:24:57 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 150618 15:24:59 mysqld_safe mysqld from pid file /usr/local/mysql/data/Blythes-MacBook-Air.local.pid ended` – Blythe Simmons Jun 18 '15 at 19:26
  • So what does the `Blytes-MacBook-Air.local.err` file tell you? – Ken White Jun 18 '15 at 19:28
  • How do I access that file? – Blythe Simmons Jun 18 '15 at 19:31
  • The last comment you posted shows the exact location of the file. Do you not know how to find a directory or read a log file? (Just trying to ascertain your skill level.) When you started safe mode, did you `sudo` first as the instructions explained? – Ken White Jun 18 '15 at 19:33
  • I cant get access to the error file, when i try to open it with the terminal (I have no idea why) and yes i used sudo. Is there a way to completely wipe mysql from my machine and just restart the whole installation process? – Blythe Simmons Jun 18 '15 at 19:49
  • [How do you uninstall MySQL from OSX?](http://stackoverflow.com/q/1436425/62576). – Ken White Jun 18 '15 at 20:16
  • Alright, thanks for your answers. I had mysql working on this machine before and i think i installed a version forgetting i already had it and it messes up everything. Im just gonna wipe everythign and start from scratch. Thanks again – Blythe Simmons Jun 18 '15 at 20:17

0 Answers0