Change password from Mysql database

Self-Hosted | v5
1

How can I change user’s password from self-hosted Database? (I have issue with the SMTP setting).
ty

2

Hi,

@david can you please advise?

3

You would need to do this from tinker. from the project root run the following:

php artisan tinker

Then in the DB find the id of the user you wish to update, then in tinker run

$user = User::find(1);

where 1 is the id of the user

$user->password = Hash::make('yournewpasswordhere');
$user->save();
4

But I am on the shared hosting. Can I use PHPMyAdmin to achieve this? ty

5

No it is not possible to use phpmyadmin.

If you copy the password field from a known user you can use that users password however… which may be a better solution for you.