Cant connect to local mysql server through socket var lib mysql mysql sock

0 votes

I am getting the above mentioned error when I try to login MySql. I have started the service using:

service mysqld start

And checked the status and verified it is running using this:

mysqladmin -u root -p status

But still getting the error. What is the problem?

Dec 26, 2018 in Big Data Hadoop by slayer
• 29,300 points
598 views

1 answer to this question.

0 votes

Seems like mysql.sock does not exist in the path /var/lib/mysql. First find where this file is using this command:

locate mysql.sock

Once you find the file and the path, create the symlink:

ln -s /<path to file found by previous command>/mysql.sock /var/lib/mysql/mysql.sock
answered Dec 26, 2018 by Omkar
• 69,130 points

Related Questions In Big Data Hadoop

0 votes
3 answers

How to connect Spark to a remote Hive server?

JDBC is not required here. Create a hive ...READ MORE

answered Mar 8, 2019 in Big Data Hadoop by Vijay Dixon
• 190 points
4,701 views
–1 vote
1 answer

How to uninstall and install mysql-server in centos?

Please find below the command to uninstall ...READ MORE

answered Dec 27, 2018 in Big Data Hadoop by Omkar
• 69,130 points
753 views
0 votes
0 answers
0 votes
1 answer

How to connect Sqoop to mysql Database?

Hi. You can connect Sqoop to MySql ...READ MORE

answered May 15, 2019 in Big Data Hadoop by Tina
1,056 views
0 votes
1 answer

Update hdfs data before stroring in MySql

Yes, you can update the data before ...READ MORE

answered Jan 27, 2019 in Big Data Hadoop by Omkar
• 69,130 points
124 views
0 votes
1 answer

Using Hadoop for Data Analytics.

Yes, your approach is correct - you ...READ MORE

answered Sep 28, 2018 in Big Data Hadoop by Frankie
• 9,810 points
94 views
0 votes
1 answer

How to open MySql console in Ubuntu?

sudo service mysqld restart mysql -u <username> root ...READ MORE

answered Dec 14, 2018 in Big Data Hadoop by Omkar
• 69,130 points
1,036 views
–1 vote
1 answer

Facing the below error while installing mysql in VM

We would like to say that the ...READ MORE

answered Dec 21, 2018 in Big Data Hadoop by Omkar
• 69,130 points
209 views
0 votes
1 answer

MySql connection problem "Cant connect to local mysql server through socket "var/lib/mysql/mysql.sock" .

First start the mysql server: service mysqld start To ...READ MORE

answered Dec 26, 2018 in Big Data Hadoop by Omkar
• 69,130 points
463 views
0 votes
1 answer

Hbase: Client not able to connect with remote Hbase server

You have to remove the localhost entry from hbase server's ...READ MORE

answered Nov 8, 2018 in Big Data Hadoop by Omkar
• 69,130 points
2,854 views