"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,170 points
124 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
• 67,600 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 in Big Data Hadoop by Vijay Dixon
• 180 points
1,414 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
• 67,600 points
103 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
• 67,600 points
34 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
38 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
• 67,600 points
102 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
• 67,600 points
63 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
• 67,600 points
348 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
• 67,600 points
720 views