Mac Terminal/ MySQL configuration issues | ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Question

I've been getting this error when trying to navigate to MySQL in the command prompt. System Preferences shows it's running through port 3306. I'm new to programming and I'm just trying to keep up with tutorials, but a lot of this knowledge is stacked and without a properly working local database things just continue to get more and more confusing.

Also have been receiving this error:

ERROR 1045 (28000): Access denied for user 'hostname'@'localhost' (using password: NO)

Answer 1

It seems like Mysql server has not started.

mysqld stop
mysql.server start

This will fix the issue.