Access denied for user 'root'@'localhost' Backtrack 5 R3

Error karena service mysql nya mati

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

problem ketika mysql baru di instal di backtrack :


ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

solusi : Reset ulang password atau recover ulang password dengan cara 

# service mysql stop
# mysqld_safe --skip-grant-tables &
$ mysql -u root

mysql> use mysql;
mysql> update user set password=PASSWORD("YOUR-NEW-ROOT-PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit

# service mysql stop
# service mysql start
$ mysql -u root -p

Tweet

Postingan terkait:

Ditulis Aluna — Thursday, September 26, 2013 — Add Comment — Backtrack, Linux, Mysql, Ubuntu