One Taste, One Spirit, One God

Bagi linuxers yg lupa akan password root mysql, berikut adalah cara-caranya utk mereset password root mysql anda:

# /etc/rc.d/init.d/mysql stop

# cd /usr/local/mysql/bin

# ./mysqld_safe --skip-grant-tables &

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

# /etc/rc.d/init.d/mysql start

# mysql -u root -pNEW-ROOT-PASSWORD

Gut luck guys

Linux, Web Server mysql, password