pymysql.err.OperationalError while running site

[trentmu]

Here is a comprehensive post on the topic which should help

Can't connect to mysql server on u ' local host'[ Error 111] connection refused

Troubleshooting Check if you can access database for default website using bench mysql If fails, then find out if MySQL/MariaDB is running by sudo ps -Af | grep mysqld # determine process running sudo netstat -lnp | grep mysql # determine listening port number of mysql process ps -Af | grep mysqld root 10483 28913 0 21:52 pts/1 00:00:00 grep mysqld mysql 23228 1 0 Sep22 ? 00:02:36 /usr/sbin/mysqld OR Output must contain, Port number 3306 as LISTEN as follows: net…

Alternatively, maybe it’s just permissions…

Internal server error and Errno 111 connection refused

You have a mysql permission problem, try this mysql -uroot -pYourMYSQLpasswordOfChoice -Bse "GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.%.%.%' IDENTIFIED BY 'YourMYSQLpasswordOfChoice' WITH GRANT OPTION;" mysql -uroot -pYourMYSQLpasswordOfChoice -Bse "GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'YourMYSQLpasswordOfChoice' WITH GRANT OPTION;" mysql -uroot -pYourMYSQLpasswordOfChoice -Bse "GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.%.%' IDENTIFIED BY 'YourMYSQLpasswordOfCh…