How to reset Drupal 8 administrator password using phpMyAdmin?

<div dir="ltr" style="text-align: left;" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJkoK1elTgkRC8IAlldroldLKOy8wJcMf7rUt2QxGK_xJ6qT6fUbK_reOcBPKXH7vTTOzIwQvOyvXWlodCSYmhDI6kqODwtNVEml0nUuLnnQN_6-mWzh4MiPSUX3A2-f0rlci_1Cacv-4/s400/How+to+reset+dupla+7+admin+user+password+easily.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to reset Drupal 8 administrator password using phpMyAdmin?" border="0" data-original-height="266" data-original-width="400" height="265" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJkoK1elTgkRC8IAlldroldLKOy8wJcMf7rUt2QxGK_xJ6qT6fUbK_reOcBPKXH7vTTOzIwQvOyvXWlodCSYmhDI6kqODwtNVEml0nUuLnnQN_6-mWzh4MiPSUX3A2-f0rlci_1Cacv-4/s400/How+to+reset+dupla+7+admin+user+password+easily.jpg" title="How to reset Drupal 8 administrator password using phpMyAdmin?" width="400"></a></div><div style="text-align: justify;"><br></div><div style="text-align: justify;">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. </div></div><a href="https://techubber.blogspot.com/2018/08/how-to-reset-drupal-8-administrator-password-phpmyadmin.html#more">Read more »</a>

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 b...

Read more »

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

<div dir="ltr" style="text-align: left;" trbidi="on"><div dir="ltr" style="text-align: justify;" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyUjcQzxiSUZh0YOjQh4UAMUTmLdlPn4gMPIarh0IkMdo2JfhYikzRMG2kxRk4AFCTlIUxwi0kiNOaKeIJbBn6OWYYlRA9wq5DMlL0V3EAth3Kt1paUR6wRzSdCJQ4-qiS3bC9WOQaoPA/s1600/xampp-apache-http-port-80-8080.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default" border="0" data-original-height="538" data-original-width="833" height="412" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyUjcQzxiSUZh0YOjQh4UAMUTmLdlPn4gMPIarh0IkMdo2JfhYikzRMG2kxRk4AFCTlIUxwi0kiNOaKeIJbBn6OWYYlRA9wq5DMlL0V3EAth3Kt1paUR6wRzSdCJQ4-qiS3bC9WOQaoPA/s640/xampp-apache-http-port-80-8080.png" title="How to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default" width="640"></a></div><br>In this post we shall see How to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default? <br></div></div><a href="https://techubber.blogspot.com/2018/04/how-to-configure-xampp-to-open-apache-phpmyadmin-on-port-8080-xampp-control-panel.html#more">Read more »</a>

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 »

Read more »

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

<div dir="ltr" style="text-align: left;" trbidi="on"><div dir="ltr" style="text-align: justify;" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyUjcQzxiSUZh0YOjQh4UAMUTmLdlPn4gMPIarh0IkMdo2JfhYikzRMG2kxRk4AFCTlIUxwi0kiNOaKeIJbBn6OWYYlRA9wq5DMlL0V3EAth3Kt1paUR6wRzSdCJQ4-qiS3bC9WOQaoPA/s1600/xampp-apache-http-port-80-8080.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default" border="0" data-original-height="538" data-original-width="833" height="412" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyUjcQzxiSUZh0YOjQh4UAMUTmLdlPn4gMPIarh0IkMdo2JfhYikzRMG2kxRk4AFCTlIUxwi0kiNOaKeIJbBn6OWYYlRA9wq5DMlL0V3EAth3Kt1paUR6wRzSdCJQ4-qiS3bC9WOQaoPA/s640/xampp-apache-http-port-80-8080.png" title="How to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default" width="640" /></a></div><br />In this post we shall see How to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default? XAMPP Control Panel tries to open the Apache and phpMyAdmin pages at http://localhost, which is using http port 80. After changing Apache http port from 80 to 8080, Apache and phpMyAdmin can no longer be opened on port 80. So by clicking on "Admin" button on the XAMPP Control Panel, Apache and phpMyAdmin pages will not open. Instead we will see that the site cannot be reached.<br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7a8P8UCSM5ICsQfesz9kVM7UXZ1ycftSgotOqeGVkR2L0byQd6D30UPt0Z146lthGkqF36T7eZY49hOtOU25-Nw2xDcn3HYkLRyxWveJxqFt9TtjosXIpcsA2oPn7iShlp72klaEhpxM/s1600/xampp-control-panel-admin-apache-http-port-80-8080.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="after-changing-port-8080-apache-page-not-opening-xampp" border="0" data-original-height="795" data-original-width="1467" height="346" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7a8P8UCSM5ICsQfesz9kVM7UXZ1ycftSgotOqeGVkR2L0byQd6D30UPt0Z146lthGkqF36T7eZY49hOtOU25-Nw2xDcn3HYkLRyxWveJxqFt9TtjosXIpcsA2oPn7iShlp72klaEhpxM/s640/xampp-control-panel-admin-apache-http-port-80-8080.png" title="after-changing-port-8080-apache-page-not-opening-xampp" width="640" /></a></div><br />In such a case, we need to manually add port 8080 after localhost in the URL in the browser address bar. Or, we can also configure XAMPP to open Apache and phpMyAdmin to open on port 8080 by default when the Admin button on XAMPP Control Panel is clicked.<br /><br /><b><span style="font-size: large;">How to change Apache http port from 80 to 8080 in XAMPP?</span></b><br />Watch this short video for steps. Or refer to <a href="http://techubber.blogspot.com/2014/08/how-to-change-apache-server-localhost-port-80-to-8080-wamp.html">this article</a> for the steps.<br /><br /><iframe allow="autoplay; encrypted-media" allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/MaFB6od53Aw" width="560"></iframe> <br /><span style="font-size: large;"><b>How to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default?</b></span><br /><br />As mentioned above, XAMPP Control Panel tries to open the Apache and phpMyAdmin pages at http://localhost, which is using http port 80. After changing Apache http port from 80 to 8080, Apache and phpMyAdmin can no longer be opened on port 80.<br /><br />In such a case, we can also configure XAMPP to open Apache and phpMyAdmin to open on port 8080 by default when the Admin button on XAMPP Control Panel is clicked.<br /><br /><b>Watch this video how to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default:</b></div><div style="text-align: justify;"><iframe allow="autoplay; encrypted-media" allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/ZKoku6AGxbA" width="560"></iframe></div><br /><b><span style="font-size: large;">Steps to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default</span></b><br /><ul style="text-align: left;"><li> Stop services from XAMPP Control Panel</li><li>Click on CONFIG on the XAMPP Control Panel</li><li>Click on SERVICE AND PORT SETTINGS</li><li>On the Apache tab, change the port from 80 to 8080</li><li>Click save</li><li>Click save</li><li>Start Apache</li><li>Start Apache and MySQL Services from XAMPP Control Panel</li><li>Click on Admin button on XAMPP Control Panel corresponsing to Apache and phpMyAdmin</li><li>Apache and phpMyAdmin pages should open automatically using the port 8080</li></ul><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMcr2kakic-tRuGMEYdSQfT7vmyZqHQG46jtObZs1GsIAqaQbYNnh6-ZAZGO0NGdOtlRb2OEw2Y0XtnTt01Sj7dbllJpyntE0YCKWIjCZH7XnHon0XSxxmbBsd6Tn3U6lZaUcE3f-aNhM/s1600/xampp-control-panel-change-apache-port-80-8080-userinterface.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="xampp-control-panel-change-apache-port-80-8080-userinterface" border="0" data-original-height="799" data-original-width="1299" height="392" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMcr2kakic-tRuGMEYdSQfT7vmyZqHQG46jtObZs1GsIAqaQbYNnh6-ZAZGO0NGdOtlRb2OEw2Y0XtnTt01Sj7dbllJpyntE0YCKWIjCZH7XnHon0XSxxmbBsd6Tn3U6lZaUcE3f-aNhM/s640/xampp-control-panel-change-apache-port-80-8080-userinterface.png" title="xampp-control-panel-change-apache-port-80-8080-userinterface" width="640" /></a></div><br /><b><span style="font-size: large;">Alternative: to configure XAMPP to open Apache and phpMyAdmin on port 8080 by default</span></b><br /><br />You can configure XAMPP to open Apache and phpMyAdmin on port 8080 by default from XAMPP from the XAMPP userinterface itself as described in the video. Or you can also edit the settings in xampp-control.ini file as described below. <br /><ul style="text-align: left;"><li>Stop services from XAMPP Control Panel</li><li>Navigate to C:\xampp</li><li>Find the file xampp-control.ini</li><li>Open the file xampp-control.ini in a notepad to edit</li><li>Search for [ServicePorts]</li><li>Under [ServicePorts], change Apache=80 to Apache=8080</li><li>Save the file</li><li>Start Apache and MySQL Services from XAMPP Control Panel</li><li>Click on Admin button on XAMPP Control Panel corresponsing to Apache and phpMyAdmin</li><li>Apache and phpMyAdmin pages should open automatically using the port 8080</li></ul></div>

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? XAMPP Control Panel tries to open th...

Read more »

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

<div dir="ltr" style="text-align: left;" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTNNYgxWI4johgzArqOnTgswhHEoxdDirG5brHgJkoMtK7e1xlFhx7-5pXMmgoKhf0ftbrKqhI9bpGn93Mc5dHmOtj5C1-fPYGsxM3823fNfDXAc6LTG-pdatAjeCVppuTTux2lw08960/s1600/unable-to-login-phpmyadmin-xampp-password-root.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="unable-to-login-phpmyadmin-xampp-password-root" border="0" data-original-height="430" data-original-width="610" height="450" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTNNYgxWI4johgzArqOnTgswhHEoxdDirG5brHgJkoMtK7e1xlFhx7-5pXMmgoKhf0ftbrKqhI9bpGn93Mc5dHmOtj5C1-fPYGsxM3823fNfDXAc6LTG-pdatAjeCVppuTTux2lw08960/s640/unable-to-login-phpmyadmin-xampp-password-root.png" title="unable-to-login-phpmyadmin-xampp-password-root" width="640"></a></div><div style="text-align: justify;"> </div><div style="text-align: justify;"><span style="font-size: large;"><b>Unable to login to XAMPP's phpMyAdmin page : Error #1045 - Access denied for user 'root'@'localhost' (using password: NO). </b></span><br>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.<br><i><b></b></i></div></div><a href="https://techubber.blogspot.com/2017/11/phpmyadmin-access-denied-user-root-no-password-unable-login-phpmyadmin.html#more">Read more »</a>

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: ...

Read more »

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

<div dir="ltr" style="text-align: left;" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDnboG9qZtaeT4Jc9nRZs37dEnt2qpgzYAXp_akYgA68KU59cG34vIggT8LiLPwZ6Wxzd_FQ6NbX-JSTQbCDVBvhBz0wCDviNo7v1tkJE8JAP6Ykc9U39MZ9DvYXJ_bHl4nruDKk8pKCg/s1600/mysql+logo.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="308" data-original-width="500" height="197" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDnboG9qZtaeT4Jc9nRZs37dEnt2qpgzYAXp_akYgA68KU59cG34vIggT8LiLPwZ6Wxzd_FQ6NbX-JSTQbCDVBvhBz0wCDviNo7v1tkJE8JAP6Ykc9U39MZ9DvYXJ_bHl4nruDKk8pKCg/s320/mysql+logo.jpg" width="320"></a></div><br><span style="font-size: large;">S</span>o 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: <br><blockquote class="tr_bq"><i><b>#1273 - Unknown collation: 'utf8mb4_unicode_520_ci'</b></i></blockquote>On some systems, the error could be: <code>Unknown collation: 'utf8mb4_unicode_ci'</code><br></div><a href="https://techubber.blogspot.com/2017/09/issue-importing-wordpress-database-development-live-server-mysql-unknown-collation-uts8mb4.html#more">Read more »</a>

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

S o I was trying to import a MySQL database exported from local development machine to a live server and I got the error thrown by phpMyAdmi...

Read more »

How to reset Drupal admin user password easily from phpMyAdmin?

<div dir="ltr" style="text-align: left;" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJkoK1elTgkRC8IAlldroldLKOy8wJcMf7rUt2QxGK_xJ6qT6fUbK_reOcBPKXH7vTTOzIwQvOyvXWlodCSYmhDI6kqODwtNVEml0nUuLnnQN_6-mWzh4MiPSUX3A2-f0rlci_1Cacv-4/s1600/How+to+reset+dupla+7+admin+user+password+easily.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to reset dupla 7 admin user password easily" border="0" height="265" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJkoK1elTgkRC8IAlldroldLKOy8wJcMf7rUt2QxGK_xJ6qT6fUbK_reOcBPKXH7vTTOzIwQvOyvXWlodCSYmhDI6kqODwtNVEml0nUuLnnQN_6-mWzh4MiPSUX3A2-f0rlci_1Cacv-4/s400/How+to+reset+dupla+7+admin+user+password+easily.jpg" title="How to reset dupla 7 admin user password easily" width="400"></a></div><span style="font-size: large;">How to reset Drupal admin user password easily? </span><br>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.<br><br>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.<br></div><a href="https://techubber.blogspot.com/2016/11/how-to-reset-drupal-admin-user-password-phpmyadmin.html#more">Read more »</a>

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. I...

Read more »