error on connecting mysql hosted locally

Asked May 09 '18 at 20:51

Active May 09 '18 at 20:59

Viewed 56 times

I restored mysql dump and can be accessed in my terminal (I need to issue sudo mysql to access this db or even to start mysql) :

I know this is privilege issue. But when I call mysql in python program, I get this error:

   OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: NO)")

I tried both ways supplying password and keeping it blank.

Here is the screenshot:

SOLUTION

replace 'localhost' by 127.0.0.1

edited May 09 '18 at 20:59

asked May 09 '18 at 20:51

lpt

Have you tried this: https://stackoverflow.com/questions/6885164/pymysql-cant-connect-to-mysql-on-localhost – Merlin1896 May 09 '18 at 20:56
OMG, switching to 127.0.0.1 from localhost fixes. – lpt May 09 '18 at 20:59

0 Answers0