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,350 points
1,347 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,210 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
12,095 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,210 points
4,179 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
2,463 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,210 points
559 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,830 points
496 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,210 points
2,271 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,210 points
688 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,210 points
869 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,210 points
5,090 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP