- Beranda
- Komunitas
- Tech
- Linux dan OS Selain Microsoft & Mac
[WTA] Access denied for user 'root'@'localhost' on centos


TS
User telah dihapus
[WTA] Access denied for user 'root'@'localhost' on centos
help dong sepuh. ane kan install mysql. tapi mysqlnya minta password
padahal mysqlnya udah ane reset passwordnya pake cara ini
terus gw kasi password yang udah gw reset tetep error begini
ada saran laen gak sepuh?
thanks before
Code:
[root@localhost amet]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:YES)
padahal mysqlnya udah ane reset passwordnya pake cara ini
Code:
/etc/init.d/mysqld stop
mysqld_safe --skip-grant-tables &
mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD("newrootpassword") where User='root';
mysql> flush privileges;
mysql> quit
/etc/init.d/mysqld stop
/etc/init.d/mysqld start
terus gw kasi password yang udah gw reset tetep error begini
Code:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:YES)
ada saran laen gak sepuh?
thanks before
0
3.5K
1


Komentar yang asik ya
Urutan
Terbaru
Terlama


Komentar yang asik ya
Komunitas Pilihan