0

I have been battling with this since 9AM and it is past 7:30 PM. My application was not able to communicate with mySQL. So I wanted to make sure I could get into it through phpMyAdmin. I can bring up the login screen(via localhost/phpmyadmin) in my browser, but It won't take my user and password. I've tried stopping it, running sudo mysqld --skip-grant-tables &, and then starting it. No dice. when I type mysql at the CLI I get

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

This makes sense since I don't have a /var/run/ directory. I tried mysql -u richb201 -p but I get

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

Is there anyway for me to remove mysql and just reinstall it?

Here is my current mysqld.conf which is NOT in the /run/ directory

[mysqld_safe]
socket      = /var/run/mysqld/mysqld.sock

nice        = 0

[mysqld]
#
# * Basic Settings
#
user        = mysql
pid-file    = /var/run/mysqld/mysqld.pid
socket      = /var/run/mysqld/mysqld.sock
port        = 3306
basedir     = /usr
datadir     = /var/lib/mysql
tmpdir      = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#

1 Answer 1

0

Is there anyway for me to remove mysql and just reinstall it?

Yes there is:

sudo apt remove mysql-server

or

sudo apt purge mysql-server

The latter will ensure that all packages related to the installation are removed including configuration files.

Then to reinstall:

sudo apt install mysql-server

To set mysql root password run sudo mysql_secure_installation command.

7
  • Thanks. when I run either remove or purge or install I get: Unable to locate package mysql. What to do? Feb 24, 2019 at 12:33
  • Are you sure mysql is installed? What is the output of systemctl status mysql? also try sudo apt purge mysql-server. Also the firewall could be the issue. sudo ufw allow mysql would resolve it.
    – denmu
    Feb 24, 2019 at 12:47
  • What is the output of systemctl status mysql? Unit mysql.service could not be found. I ran all of your suggestions. when I type $ mysql I get: mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Feb 24, 2019 at 12:51
  • Run sudo apt install mysql-server
    – denmu
    Feb 24, 2019 at 12:55
  • Ran it. Now when I type mysql I get : ERROR 1045 (28000): Access denied for user 'richb201'@'localhost' (using password: NO). Does that mean it is still there? Feb 24, 2019 at 13:01

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .