I have installed MySQL successfully (on Mac OS X) and am at the point where I want to create/show databases. MySQL Server Status says it's running but when I try to run mysql commands from /usr/local/mysql I get the error
ERROR 1045 (28000): Access denied for user 'Username'@'localhost' (using password: YES)
I am trying the command:
mysql> SHOW DATABASES
but still encountering this error and have done research to avoid this and came upon using this command to avoid granting permission
mysqld --skip-grant-tables
after running this command I get another error saying
mysqld: Can't change dir to '/usr/local/mysql-5.7.13-osx10.11->x86_64/data/' (Errcode: 13 - Permission denied)
2016-08-16T18:42:00.489762Z 0 [Warning] TIMESTAMP with implicit DEFAULT >value is deprecated. Please use --explicit_defaults_for_timestamp server >option (see documentation for more details).
2016-08-16T18:42:00.490049Z 0 [Warning] Insecure configuration for -->secure-file-priv: Current value does not restrict location of generated >files. Consider setting it to a valid, non-empty path...
I've been going in circles researching error after error and feel that I'm close but just missing one or a few key things. Please help me fix this!