MySQL 8 cannot connect due to DB_HOST or DB_NAME

[Andrew Schell]

Hello, new-ish user here trying to debug a local SQL instance.

I've connected to the MySQLworkbench and the MacOs system preferences are all installed, the server shows it's up and receiving pings but when I enter the connection data in PyCharm it gives errors.

8.0.23 (MySQL Community Server - GPL)

If I enter this connection or changing DB_HOST to 'localhost' I get an error

DB_HOST = '127.0.0.1'
DB_USER = 'root'
DB_PASS = 'APassword12345'
DB_NAME = 'mysql_morning'

`pymysql.err.OperationalError: (1130, "10.14.1.61' is not allowed to connect to this MySQL server")`

I've been looking in MySQLworkbench for something like 'allow remote connections' but I'm at my local machine trying to run it and don't need ssh access yet.

PyCharm is telling me to use '(protocol=pipe)(path=\\.\pipe\MySQL)' as name in connection dialog but what does that mean?

I will create a separate user account once I can get this running but I'm stumped.