Unable to start the mysql server in ubuntu

mysql ubuntu-16.04
Rohit Kumar picture Rohit Kumar · Dec 14, 2016 · Viewed 95.6k times · Source

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)

Answer

Dmitri Sandler picture Dmitri Sandler · Dec 14, 2016

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

Related questions

Default password of mysql in ubuntu server 16.04

I have installed ubuntu 16.04 server. Mysql server was installed by default in it. When I am trying to access the mysql with mysql -u root -p, I am unable to log in to mysql because I dont have the password. …

Read More
Can't reset root password with --skip-grant-tables on ubuntu 16

I am trying to reset the root password following MysqlPasswordReset but when I try to start the server with --skip-grant-tables the server doesn't start Ubuntu 16.04.1 LTS (GNU/Linux 4.4.0-59-generic x86_64) mysql Ver 14.14 Distrib 5.7.17, for Linux (x86_64) Server is running $ …

Read More
WARNING: Module mcrypt ini file doesn't exist under /etc/php/7.2/mods-available

I've been trying to install phpmyadmin in Ubuntu 16.04.3 LTS having a lamp installed, php 7.2, mysql Ver 15.1 Distrib 10.2.12-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 and apache2. and I am following this article from digitalOcean, but when I came to the part …

Read More