12

new centos dedicated server - cant get mysql working

view full story
linux-howto

http://www.unix.com – 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) (HowTos)

ziyi's picture
Submitted by ziyi on 12/29/2011 – Made popular on 12/29/2011

Stories similar to new centos dedicated server - cant get mysql working

Can't start MySQL 38 weeks 6 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?

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've changed data directory in /etc/my.cnf.

I'm trying to install MySQL on OS X.

First I tried MacPorts. I followed the instructions in step 3 of https://trac.macports.org/wiki/howto/MAMP, but when I ran mysqladmin5 or mysql5 I get:

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

The file mysqld.sock existed.

Then I tried installing using a .dmg from mysql.com.

My VPS had a hardware failure, and I was knocked out of service for the past 24 hours. Now that it's back up, MySQL refuses to work.

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.

Help with MySQL 32 weeks 1 day ago

Hey guys, so I've been running F17 for quite some time now, and earlier I attempted to install mysql for computer science class, and so far I have been the recipient of two not so unfamiliar errors I've gotten in the past while trying to install apache and other server software, number1 is it didn't prompt me to configure my mysql root password and secondly, every time I try to start it up I get t

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.

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