Welcome Guest. Please Login or Register  


You are here: Index > General Stuff > General Discussions > Topic : error /var/lib/mysql/mysql.sock



Threaded Mode | Print  

 error /var/lib/mysql/mysql.sock, /var/lib/mysql/mysql.sock (3 Replies, Read 21966 times)
lolite
Group: Member
Post Group: Working Newbie
Posts: 63
Status:
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 ?
IP: --   

error /var/lib/mysql/mysql.sock
Brijesh
Group: Softaculous Team
Post Group: Super Member
Posts: 5732
Status:
Hi,

Which panel are you using ?

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

error /var/lib/mysql/mysql.sock
AjitK29
Group: Member
Post Group: Newbie
Posts: 1
Status:
Try
Code
sudo mysqladmin password newpassword


Type a new password..
and then
Code
sudo mysql -u root -p


Good luck
               

-----------------------
SAP Hosting On Cloud
IP: --   

error /var/lib/mysql/mysql.sock
nikhil89
Group: Softaculous Team
Post Group: Elite Member
Posts: 467
Status:
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 :)
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is November 10, 2024, 6:10 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 10  |  Page Created In:0.031