Kaskus

Tech

User telah dihapusAvatar border
TS
User telah dihapus
[WTA] Access denied for user 'root'@'localhost' on centos
help dong sepuh. ane kan install mysql. tapi mysqlnya minta password
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
GuestAvatar border
Komentar yang asik ya
Urutan
Terbaru
Terlama
GuestAvatar border
Komentar yang asik ya
Komunitas Pilihan