1

ERROR 2002 (HY000): Can't connect to local MySQL server through socket

view story
linux-howto

http://stackoverflow.com – I am trying to change the data directory for mysql in a LAMP setup. The partition that LAMP is installed in cannot support the size of a .sql dump I am trying to import. I have another hardrive with plenty of room on it that I want all the data to live on. I have changed the datadir to my new directory and moved the /var/lib/mysql folder and content to it. I also updated the /etc/apparmor.d/usr.sbin.mysqld file to the following: #/var/lib/mysql/ r, #/var/lib/mysql/** rwk, /media/myData/dataDirUbuntu/mysql/ r, /media/myData/dataDirUbuntu/mysql/** rwk, Trying to restart MySQL, I get the f (HowTos)

linuxletgo's picture
Submitted by linuxletgo on 01/11/2013

Stories similar to ERROR 2002 (HY000): Can't connect to local MySQL server through socket

I've changed data directory in /etc/my.cnf.

Hi all,

I installed centos 5, with LAMP. httpd is working fine, ssh, ftp all working ok.

But, when I try to use mysql its not,

when I give the command

Code: mysql I get

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

I have mistakenly deleted some of the dependent file for mysql when I am trying to use mysql command i am getting following error :

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

I have tried reinstalling mysql-server but it still not resolved .

What should I do to bring back everything to normal condition.

Does anyone know how to change the LAN IP of your server and maintain connection to MySQL server.

I have phpmyadmin installed and when I changed the LAN IP I lost the ability to log in.

I recieved and error with: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I have a MySQL based website that also became unavailable when I try to acce

Can't start MySQL 42 weeks 5 days ago

Hi,

I have install MySQL serve in Fedora 16 32 bi distro that I have on my pc, but I can't start MySQL from command line. Can you please help?

I tried to change the database dirrectory, datadir, I did the following steps. My machine: Laptop Ubuntu 11.10 64-bit

Install: sudo apt-get install mysql-server mysql-client All Ok, I can create databases, tables, all ok. Change the datadir:

1) $ /etc/init.d/mysql stop 2) $ cp -R -p /var/lib/mysql /new_path 3) $ rm /new_path (this only remove files unnecessary) 4) $ gedit /e

The problem is that my MySQL server keeps crashing every few seconds. Even if I repeat a simple SQL command several times, the MySQL server goes down:

mysql> show databases; ERROR 2006 (HY000): MySQL server has gone away No connection.

I was setting up a soft link in linux. Here were the steps I followed:

> groupadd mysql > useradd -g mysql mysql > cd /usr/local > gunzip /home/Tim/Download/mysql.....gz | tar xvf - > ln -s /usr/local/mysql.... mysql

Cannot connect to mysql 43 weeks 2 days ago

Recently I have moved the data folder of MySql to the other folder as describe in the my.ini following:

[mysqld] port= 3306 socket= "D:/xampp/mysql/mysql.sock" basedir="D:/xampp/mysql" tmpdir="D:/xampp/tmp" datadir="I:/Dropbox/mysql/data" pid_file="mysql.pid" skip-external-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buff