While accesing mysql in Ubuntu , after entering the correct password?

Question

I am getting this message :

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

What command you have used to be exact? – heemayl Nov 17 '15 at 04:43 — heemayl, Nov 17 '15 at 04:43
mysql -u root -p – Mrityunjay Kumar Singh Nov 17 '15 at 05:26 — Mrityunjay Kumar Singh, Nov 17 '15 at 05:26
Is the mysql server running? – heemayl Nov 17 '15 at 06:17 — heemayl, Nov 17 '15 at 06:17

score 1 · Answer 1 · answered Nov 17 '15 at 06:30

1

Your mysql server is not running. Try to set error logging in your /etc/mysql/my.cnf in [mysqld] section : log_error = /var/log/mysql/mysql-error.log , then restart mysql and look for errors. When you fix your errors you will access your mysql.

answered Nov 17 '15 at 06:30

Nikolay Nikolov

6,205

score 1 · Accepted Answer · edited Apr 13 '17 at 12:25

1

Just follow the steps below and you will be able to solve your error :

Install mysql-server using command sudo apt-get install mysql-server-5.5

After that , just run below commands in your terminal :

sudo service mysql stop
sudo /etc/init.d/apparmor reload
sudo service mysql start

Now , run the command mysql -u root -p , you will successfully enter into the mysql command prompt.

Note : I too was having the same error and found this answer from can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'.

I hope this helps. :)

edited Apr 13 '17 at 12:25

Community

1

answered Nov 17 '15 at 06:43

huzefa biyawarwala

140

Thanks for your suggestion,but it didn't work. – Mrityunjay Kumar Singh Nov 18 '15 at 04:36
You are getting the same error which you have mentioned in your question ? – huzefa biyawarwala Nov 18 '15 at 04:51

While accesing mysql in Ubuntu , after entering the correct password?

2 Answers2