MySQL connection error and its solution

Hai, today i faced a mysql connection problem while logging in to mysql prompt from the terminal

I am running on Fedora 14

Here i posted the error and its solution

Error:

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

Solution:

To solve the above error, it is necessary to start The MySQL Server – mysqld 

Start MySQL server:

As a root user, start the mysql server

service mysqld start

Stop MySQL server:

As a root user, stop the mysql server

service mysqld stop

Note: The file mysql.sock is automatically created when the MySQL server ( mysqld ) runs, otherwise it is not.

Advertisement