Unable to start the mysql server in ubuntu

After running the command mysql -v in Ubuntu, I am getting the following error:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

6 Answers

I think this is because you are using client software and not the server.

• mysql is client
• mysqld is the server

Try: sudo service mysqld start

To check that service is running use: ps -ef | grep mysql | grep -v grep.

Uninstalling:

sudo apt-get purge mysql-server sudo apt-get autoremove sudo apt-get autoclean 

Re-Installing:

sudo apt-get update sudo apt-get install mysql-server 

Backup entire folder before doing this:

sudo rm /etc/apt/apt.conf.d/50unattended-upgrades* sudo apt-get update sudo apt-get upgrade 

Yes, should try reinstall mysql, but use the --reinstall flag to force a package reconfiguration. So the operating system service configuration is not skipped:

sudo apt --reinstall install mysql-server 

Try running

sudo apt-get install mysql-server 

if not installed.

By default, apt install MariaDB but not mySQL.

sudo apt install default-mysql-server 

If you would like to install real mySQL database by apt, follow these steps.

Firstly, we need to remove all preceding mysql installed on the host.

sudo apt-get --purge autoremove "^mysql.*" 

Dowload the stable package mysql-apt-config_0.8.15-1_all.deb from

sudo wget 

Install the downloaded release package:

sudo dpkg -i mysql-apt-config_0.8.15-1_all.deb 

Refresh your apt package cache to make the new software packages available

sudo apt update 

Install MySQL by executing:

sudo apt-get update sudo apt-get install mysql-server mysql-client 

libmysqlclient-dev 

Check mysql status:

sudo service mysql status 

I tried this also and more (re-installation etc.)

The answer was : I found query_cache_limit and removed it from the /etc/mysql/my.cnf file.

As soon as I removed it, the error log changed to a query_cache_size one so I removed that one too from my.cnf file. Within seconds, MySQL restarted successfully and I was back in business.

* Query Cache Configuration query_cache_limit = 1M query_cache_size = 16M * Logging and Replication # 

I fixed by "purging" every file related to mysql and reinstalling mysql-server:

sudo apt-get purge mysql-server mysql-client mysql-common sudo apt-get install mysql-server