0

Weird issue. Can't connect to localhost MySQL database from command line, but I can through MySQL program, Sequel Pro. Any ideas why? I entered the same user/password, but I'm getting a access denied error for root@localhost

Extra question: can you run MySQL commands within Sequel Pro? I'm pretty new to MySQL, but I'm just trying to change a simple column definition.

EDIT: reset password from within Sequel Pro query for root, and was able to get it working.

blunatic
  • 325
  • 2
  • 6
  • 16

1 Answers1

1

MySQL has different accesses. You can allow a MySQL database to only serve requests from a specific machine, or only from the local machine.

However, note that MySQL differentiates login from "localhost" and from "127.0.0.1".

Try allowing both localhost, 127.0.0.1 and "%" to the account.

Alexandre Santos
  • 8,170
  • 10
  • 42
  • 64