Change password from Mysql database

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


@david can you please advise?

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');

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

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.