linux

Forgotten mysql password?

by tini

or you received something like this?

ERROR 1045 (28000): Access denied for user ‘something’@’localhost’ (using password: NO)

– killall mysql services (killall mysql)
– mysqld_safe –skip-grant-tables &
– mysql -u root mysql
– UPDATE user SET password=PASSWORD(“wanted-password”) WHERE user=”root”;
– FLUSH PRIVILEGES;
– EXIT
– start mysql services (/etc/init.d/mysql start)