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

0 votes

Hi , I am getting below error while trying to login to mysql 
"Cant connect to local mysql server through socket "var/lib/mysql/mysql.sock" 

Please tell me how to solve this?

Dec 26, 2018 in Big Data Hadoop by slayer
• 29,170 points
352 views

1 answer to this question.

0 votes

First start the mysql server:

service mysqld start

To check if it is running, run this command:

mysqladmin -u root -p status

Check if you can connect now. If the error still exists, then try to change the permission of mysql directory

sudo chmod -R 777 /var/lib/mysql/
answered Dec 26, 2018 by Omkar
• 67,660 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,491 views
0 votes
1 answer

Hadoop Job Tracker problem. I cannot connect to http://localhost:50030/

I think you are using new version ...READ MORE

answered Nov 29, 2018 in Big Data Hadoop by Omkar
• 67,660 points
570 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,660 points
111 views
–1 vote
1 answer

Issue with MySql Server connection

Try to restart the mysqld server and then login: sudo ...READ MORE

answered Jan 2 in Big Data Hadoop by Omkar
• 67,660 points
24 views
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,660 points
35 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
42 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,660 points
117 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,660 points
66 views
0 votes
1 answer

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

Seems like mysql.sock does not exist in the ...READ MORE

answered Dec 26, 2018 in Big Data Hadoop by Omkar
• 67,660 points
141 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,660 points
831 views