RecoVery psswd MysQl


pas lgi mau ngintall cacti tba”da mslh sama mysqlq…pas mau msuk mysql buat konfigurasi cacti eh muncul tulisan
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’,,

trz mau tnya om n3wb13 tp sbuk jd tkut tnya’nya trz…tak brani² in deyh “kata om n3wb13,googling dunk” yawda buntut²nya cri di mbah google deyh…..trz aq nmu perintah ni…..

recovery psswd mysql

recovery password di mysql on centos

jika keluar pesan seperti yg di bawah ni :
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’
maka….

coba jalankan
/usr/bin/mysqladmin -u root password new-password

bila kluar “Access denied” for root@localhost try this method:
stop mysqldnya :
service mysqld stop
lalu start lgi dengan perintah :
/usr/libexec/mysqld –skip-grant-tables –user=mysql
lalu ssh lgi server kmu tpi jngan lewat telnet ya,,lalu jalankan perintah :
# mysql
maka akan muncul :
mysql>

setelah itu seting ulang psswrd mysql km….slmat mncoba ya…..😀

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: