Jumat, 25 Februari 2011
Reset Password at MYSQL on ubuntu Lucid
After one week, configure my lucid,and learn about how to instal LAMP i have problem when login to phpmyadmin, almost 3 day search the problem couse when i instal no password filled and many time i try the metode from any forum to forum to get login on phpmyadmin but still not succes. Finaly this day i can login to my phpmyadmin follow the step from help.ubuntu.com and below the step you can use for reset password root and change it with your new password.
1.Stop the mysql demon process using this command :
sudo /etc/init.d/mysql stop
2.Start the mysqld demon process using the --skip-grant-tables option with this command
sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &
3.start the mysql client process using this command
mysql -u root
4.from the mysql prompt execute this command to reset/update your password
SET PASSWORD FOR root@'localhost' = PASSWORD('password');
5.If you have a mysql root account that can connect from everywhere, you should also do:
UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
note:
open your terminal first and copy the bold text to terminal from no 1 ~ 5 one by one
for item 5 dont forget change this word newpwd with your new password
many thanks to kecoa-ngamuk, user from kaskus forum who was write the link to
help.ubuntu.com
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar