Reset SQL root password

[SeraphimNL]

Hey there,


I am trying to set up a webserver with apache, mysql and php on a old pentrium 4 computer. When I tried to setup my MySQL password, I created a password with punctuation in it. MySQL didn't want the password and gave some error about BASH. I tried changing my password again but now I constantly get the error that I am unable to login. I tried all the possibilities with the password I entered before but i just can't login to MySQL anymore. I found some help sites on how to reset your password by running MySQL in the safe mode but that didn't work for me. Can anyone help me resetting my password? Next time i'll use a pass without punctuation Every help is much appreciated! BTW, I also tried uninstalling MySQL with yum (yum remove mysql) and it uninstalled, but when I installed it again the password was still there

Thanks in advance!

[madhavdiwan]

if you dont mind removing mysql and all of the database's and files you've created this is easy,

yum remove mysql
go to /var/lib/mysql directory and delete all files you find there ..
yum install mysql

next time you run into this , its a good idea to set up at least two administrative accounts on any database system. (and never use one of them until something like this happens)
usually for mysql .. i have the root account .. which is the root user and its password.. and then my own account set up as an administrator in mysql with all of the privileges.. then each app gets its own administrator with privileges for only its own database.

[SeraphimNL]

Thank you man! It worked

Gonna make a extra user account asap

Thanks for the help!

[smr54]

A simpler way that doesn't involve removing everything should be. (Untested in awhile, who knows if it's changed?)

/usr/libexec/mysqld --skip-grant-tables --user=root

UPDATE mysql.user SET Password=PASSWORD('newpassword') WHERE User='root';

FLUSH PRIVILEGES;
quit

(In MySQL 4, after starting mysqld it was

USE mysql
UPDATE user
SET password=password("newpass")
WHERE user="root";

[leigh123linux]

Originally Posted by smr54

A simpler way that doesn't involve removing everything should be. (Untested in awhile, who knows if it's changed?)

/usr/libexec/mysqld --skip-grant-tables --user=root

UPDATE mysql.user SET Password=PASSWORD('newpassword') WHERE User='root';

FLUSH PRIVILEGES;
quit

(In MySQL 4, after starting mysqld it was

USE mysql
UPDATE user
SET password=password("newpass")
WHERE user="root";

Or

su
service mysqld stop
mysqld_safe --skip-grant-tables

from another terminal

mysql -u root mysql
UPDATE mysql.user SET Password=PASSWORD('newpassword') WHERE  User='root'; 
FLUSH PRIVILEGES; 
quit
su
service mysqld restart