How to resolve the below error on Ubuntu 16.04
pymysql.err.OperationalError: (2003, “Can’t connect to MySQL server on u’localhost’ ([Errno 111] Connection refused)”)
How to resolve the below error on Ubuntu 16.04
pymysql.err.OperationalError: (2003, “Can’t connect to MySQL server on u’localhost’ ([Errno 111] Connection refused)”)
Check your MYSql status via this command :-
sudo systemctl status mysql
If it is not running, then use either sudo systemctl start mysql
or a shorter command sudo /etc/init.d/mysql start
sudo systemctl status mysql
● mysql.service
Loaded: not-found (Reason: No such file or directory)
Active: inactive (dead)
I AM GETTING THE ABOVE ERROR.
sudo systemctl start mysql
Failed to start mysql.service: Unit mysql.service not found.
i AM USING LUBUNTU 16.04 VERSION.
Did you install mysql ? try the above replacing mysql
with mariadb
Try this solution given here : How I can set-up MySQL on Lubuntu for education purpose? - Ask Ubuntu
The following packages have unmet dependencies:
mysql-server : Depends: mysql-server-5.7 but it is not going to be installed
E: Unmet dependencies. Try ‘apt-get -f install’ with no packages (or specify a solution).
I AM GETTING THE ABOVE ERROR.
Go to below link and try that command it worked for me.