0

I'm fairly new to mysql and terminal use, so please bear with me. I am trying to log in to mysql through the terminal on my mac, but it continually says Access denied for user 'root'@'localhost' (using password: YES) or (using password: NO). I have tried using the following passwords:

  • The password given to me when I downloaded MySQL Community Server (I received a pop-up that gave me a temp password)
  • 'root'
  • My Mac password
  • No password

While searching for the problem, I came across multiple articles saying to reset the password (here is one). They say to reset the password, you must stop the mysql server, and type in

sudo mysqld_safe --skip-grant-tables.

The issue is, when I type that command in, it still asks for a password, but as I understand, it should bypass asking for a password and let you set a new one. After I enter the above set of possible of passwords (again, I don't know what it should be), it tells me the command is not found. Please let me know if I am wrong or what I can do to remedy this.

Community
  • 1
  • 1
wizloc
  • 2,202
  • 4
  • 28
  • 54
  • Download a copy of mysqlworkbench. see if you can start a server instance and look for user privs. – john elemans Feb 03 '16 at 23:10
  • Hey thanks, apparently I had to start an instance of mysqlworkbench and log in there with the temp password once, then it prompted me to change the root password. If you would like to make this an answer I will accept it – wizloc Feb 04 '16 at 02:42

1 Answers1

0

Download a copy of mysqlworkbench. Start a server instance and look for user privs.

john elemans
  • 2,578
  • 2
  • 15
  • 26