1

mysql server restart failed

view story
linux-howto

http://serverfault.com – I want to recover my mysql root password so I have followed this tutorial and stopped the mysql server . when I am trying to start it its show a error message and won't start. I believe the error is due to read only file system. Is their any other way of restarting the mysql server root@web01:/home/# /etc/init.d/mysql stop Stopping MySQL database server: mysqld ^Z [2]+ Stopped /etc/init.d/mysql stop root@web01:/home/# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) root@web01:/home/# root@web01:/home/# (HowTos)

dayu's picture
Submitted by dayu on 08/30/2012

Stories similar to mysql server restart failed

Mysql fun! 3 years 44 weeks ago

I am trying to set my root password for my mysql database. After I enter /etc/init.d/mysqld start

Starting MySQL: [FAILED] [root@server server]# [root@server server]# mysqladmin -u root password 'mypassword' mysqladmin: connect to server at 'localhost' failed

How can i stop mysql server (installed using binary installation under /usr/local/mysql)?

When i go in /usr/local/mysql/bin and execute command

mysqld stop i get following error message :

[ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

[ERROR] Aborting

[Note] mysqld: Shutdown complete

and i can still see process for mysql server.

sa

how can i log in to MySQL 1 year 26 weeks ago

I am new to ubuntu and installed MySQL use a rpm file, and started it use sudo start mysql, when i try

mysqladmin -u root password test

I get

mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

I checked the my

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

For some reason my MySQL can't connect any more. I'm running three WordPress sites and I need to save the tables.

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.

mysqld fails on F16 41 weeks 3 days ago

I have installed mysql and phpmyadmin via, yum. I get the message

#2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) The server is not responding (or the local server's socket is not correctly configured).

The problem though, is with mysql itself.

# service mysqld start Redirecting to /bin/systemctl start mysqld.service Job failed.

So I just deleted a folder and a file in /tmp/ on my ubuntu server (12.10). Now everything related to MySQL is bugged. It also seems like the root mysql account I created has reset.

For some reason, my mysql cant connect any more. Im running 3 wordpress websites and I need to save the tables.