Softaculous

Topic : error /var/lib/mysql/mysql.sock

Posted By: lolite on August 18, 2015, 6:07 am

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
MySQL root password is invalid!!!

help me error, any solution ?

Posted By: Brijesh on August 18, 2015, 3:08 pm | Post: 1

Hi,

Which panel are you using ?

-----------------------
Webuzo - Multi User Hosting Control Panel
AMPPS - Best WordPress/PHP/MySQL development tool

Posted By: AjitK29 on September 8, 2015, 7:08 am | Post: 2

Try

Code
sudo mysqladmin password newpassword

Type a new password..
and then

Code
sudo mysql -u root -p

Good luck

-----------------------
SAP Hosting On Cloud

Posted By: nikhil89 on September 8, 2015, 8:58 am | Post: 3

Quote From : lolite August 18, 2015, 6:07 am

MySQL root password is invalid!!!
help me error, any solution ?

To reset MySQL root password, Firstly stop MySQL service control panel and start MySQL in safe mode.:

Run following commands on your Terminal:

Code
cd /PATH/TO/MYSQL/bin/

mysqld_safe --skip-grant-tables

mysql -u root

USE mysql

mysql>UPDATE mysql.user SET Password=PASSWORD('mysql') WHERE User='root';

mysql>flush privileges;

mysql>quit

Hope this helps