Question

I forgot my admin password. So, how to change admin password from database?

Answer 1

You can use the "forgot my password" link and put in your email address. If that's not working then in a PHP script or on the command line run this:

echo password_hash("password", PASSWORD_DEFAULT);

Replace "password" with the actual password you want to use. You'll get a string that starts "$2y$10...", copy that into the 'passhash' field of the users table for that user.