MySQL 8 cannot connect due to DB_HOST or DB_NAME
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.
Subject
Views
Written By
Posted
MySQL 8 cannot connect due to DB_HOST or DB_NAME
538
November 08, 2022 10:22PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.