"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,040 points
32 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
• 65,850 points

Related Questions In Big Data Hadoop

0 votes
2 answers

How to connect Spark to a remote Hive server?

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

answered Mar 8 in Big Data Hadoop by Vijay Dixon
• 180 points
803 views
0 votes
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
• 65,850 points
52 views
0 votes
1 answer
0 votes
1 answer

Update hdfs data before stroring in MySql

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

answered Jan 27 in Big Data Hadoop by Omkar
• 65,850 points
18 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,590 points
23 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
• 65,850 points
62 views
0 votes
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
• 65,850 points
40 views
0 votes
1 answer
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
• 65,850 points
242 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.