MySQL Forums
Forum List  »  MySQL Workbench

MySQL 8 cannot connect due to DB_HOST or DB_NAME
Posted by: Andrew Schell
Date: November 08, 2022 10:22PM

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 = ''
DB_USER = 'root'
DB_PASS = 'APassword12345'
DB_NAME = 'mysql_morning'

`pymysql.err.OperationalError: (1130, "' 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.

Options: ReplyQuote

Written By
MySQL 8 cannot connect due to DB_HOST or DB_NAME
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.