ERPNext Foundation ERPNext Cloud Chat Blog Discuss Frappé* Donate

MYSQL Error during installation

installation_problem

#1

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)”)


#2

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


#3

sudo systemctl status mysql
● mysql.service
Loaded: not-found (Reason: No such file or directory)
Active: inactive (dead)

I AM GETTING THE ABOVE ERROR.


#4

sudo systemctl start mysql
Failed to start mysql.service: Unit mysql.service not found.


#5

i AM USING LUBUNTU 16.04 VERSION.


#6

Did you install mysql ? try the above replacing mysql with mariadb


#7

Try this solution given here : https://askubuntu.com/a/278220


#8

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.


#9

Go to below link and try that command it worked for me.