How to reset Joomla admin password from the shell

database-administrationjoomla

any idea how I can reset/change Joomla admin password from the linux command line? I have root access to the box.

I don't think I can do it phpMyAdmid way.

I don't know where the Joomla db is located and how I can connect to it.

Update

I found configuration.php that tells me the db name, host (local) and db prefix. But I don't know the password. I am receiving ERROR 1045 (28000): Access denied for user 'edumate_joomla'@'localhost' (using password: NO)

Best Answer

I usually do this type of thing by inserting a known password hash directly into whatever database you're using with joomla. Assuming you have ample privileges on the database, you should be able to do this through either the CLI or phpMyAdmin.

I am not familiar with Joomla's database schema, but there should be something like a "users" table. Inside of that table, there should be a "password" column, containing password hashes, one for each user. You should be able to replace the password hash for your admin user with a known-good hash, either from a different Joomla install or from another Joomla user.

Related Solutions

Mysql – After setting root password why does MYSQL still allow me to login without a password

Looks like the password is set on the 'root'@'localhost' user entry, but not on the 'root'@'%' entry; password-free authentication would be allowed based on that.

For security purposes, reconsider allowing root access from anywhere. If you do need it, then just get rid of the localhost specifications:

drop user 'root'@'localhost';
drop user 'root'@'127.0.0.1';
drop user 'root'@'::1';

And set the password for the 'root'@'%' user:

set password for 'root'@'%' = password('passwordhere');

MySQL 5.5.16 – How to Prevent Anonymous Connections

You need to simply remove the anonymous user.

In the future, running /usr/bin/mysql_secure_installation (Location in RPM Installation) will prompt you to remove these anonymous users.

By default, a MySQL installation has an anonymous user, allowing anyone to log into MySQL without having to have a user account created for them. This is intended only for testing, and to make the installation go a bit smoother. You should remove them before moving into a production environment.

Remove anonymous users? [Y/n] y ... Success!

Update

Best Answer

Related Solutions

Mysql – After setting root password why does MYSQL still allow me to login without a password

MySQL 5.5.16 – How to Prevent Anonymous Connections

Related Topic