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,370 points
1,140 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
• 69,220 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,768 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 30, 2018 in Big Data Hadoop by Omkar
• 69,220 points
3,895 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,220 points
4,652 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, 2019 in Big Data Hadoop by Omkar
• 69,220 points
724 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,220 points
769 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
740 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,220 points
2,548 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,220 points
962 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
• 69,220 points
1,660 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,220 points
5,457 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