How to reset Drupal 8 administrator password using phpMyAdmin?

This post describes in brief the steps to reset the Drupal 8  administrator password in case you forget them. Writing down passwords are a big no no, and no matter how hard we try to remember passwords, sometimes, we may miss it, especially if you have various different password for different systems. And forgetting passwords also usually happens on development systems when you set some dummy or random passwords, phuff!, you no longer remember them. In this post, we shall see how to reset Drupal admin user password easily from phpMyAdmin. 

Read more »

How to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default?

In this post we shall see How to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default?

Read more »

Unable to login to phpMyAdmin in XAMPP: Access denied for user 'root'@'localhost' (using password: NO)

 

Unable to login to XAMPP's phpMyAdmin page : Error #1045 - Access denied for user 'root'@'localhost' (using password: NO).
In this post we shall see how to set root password for phpMyAdmin to resolve the access denied error while accessing phpMyAdmin. This may usually happen if XAMPP is reinstalled on the same computer.

Read more »

Issue importing WordPress database from development to live server: 1273 - Unknown collation: 'utf8mb4_unicode_520_ci'

So I was trying to import a MySQL database exported from local development machine to a live server and I got the error thrown by phpMyAdmin:

#1273 - Unknown collation: 'utf8mb4_unicode_520_ci'

On some systems, the error could be: Unknown collation: 'utf8mb4_unicode_ci'

Read more »

How to reset Drupal admin user password easily from phpMyAdmin?

How to reset Drupal admin user password easily?
In this post, we shall see how to reset Drupal admin user password easily from phpMyAdmin. If it is on a production site, we can do "forgot password" to let Drupal send us a password reset link. But on local development server, we might not have a provision to do it. So we may need to do it some other ways. We can reset passwords for user from phpMyAdmin by running some scripts. But as you might already know that passwords in Drupal are hashed. So we need to know the hash code of a password before running such sql command. I have included a SQL code for password reset in Drupal 7 at the end of this post.

This example is on local Drupal 7 running on XAMPP (Windows). In this example, we generate a hash code of a password we desire and replace the existing hash code in PHPMYADMIN with the new one to change the password. Admin can then login in with the new password and may change the password as usually done in Drupal by editing the user.

Read more »