Removing MySQL completely on Linux

Question

I'm fairly new to Linux, when I first installed MySQL it was during an LAMP setup on personal machine with a Ubuntu Setup. ATM, I'm trying to get a fresh, clean install of only MySQL. I've been to trying to research how to fix this error:

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

But realized it's a wild goose-chase, this seems to be a common problem, with a number on solution of it not running in the background. Any Who, I still can't find out what my issue is and I know there is nothing important in this database, so:

 sudo apt-get purge mysql-server mysql-client

Or probably does work, but there is still (conf) files of it saved somewhere. What subdirectories/directories would I have to go into and do a 'sudo rm -f [db_files]' on. (Or other apt-get purge(s) am I missing)

Answer 1

The setting you are looking for is defined in the mysql config file located in /etc/mysql/ a purge will very likely not affect files which are located in etc especially if they have never been created at the install time(originally created by LAMP).

1. Purge all mysql stuff as you do above
2. Locate the config file in the given directory /etc/mysql , if you cant find it use "find" searching for '/var/run/mysqld/mysqld.sock' , it should also be in the configuration file where the default socket lies around
3. Remove the config file
4. Reinstall Mysql

If you have any issues, ask.

Answer 2

All database files of mysql are usually stored in /var/lib/mysql.

But your problem seems to be somewhere else: /var/run/mysqld/mysqld.sock is the default position for this files.

Look at the log files /var/log/mysql.err and into /var/log/syslog to track down the error why mysqld does not want to run.