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/AVvXsEghjE1l-_6g_c_ZIV4gVgBLFdHk2JfHEjYHfioCk0j7wF7VpZdjRkkfZfZSTOOAHU4wusj38zbzHXriwBQUC_-ZDY1jiKZ7hRP02ryFj4B5EdiywM0QxWVXq1EaC3wQrHia0kuy9DhBS3Y/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/AVvXsEghjE1l-_6g_c_ZIV4gVgBLFdHk2JfHEjYHfioCk0j7wF7VpZdjRkkfZfZSTOOAHU4wusj38zbzHXriwBQUC_-ZDY1jiKZ7hRP02ryFj4B5EdiywM0QxWVXq1EaC3wQrHia0kuy9DhBS3Y/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/AVvXsEjCB0rkb7yXMDQorfEIXdDhoomdsy_CiZid-INeAwJBjmgltOlMmOb9-OrDfm5jBWS6egveJzH-oD-HfVM7NqaSh3J6fi0NmNmgt2NnEOxXKWSW-rCIgcrVfJAD47uRHV3EMtdZHAZw3UM/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/AVvXsEjCB0rkb7yXMDQorfEIXdDhoomdsy_CiZid-INeAwJBjmgltOlMmOb9-OrDfm5jBWS6egveJzH-oD-HfVM7NqaSh3J6fi0NmNmgt2NnEOxXKWSW-rCIgcrVfJAD47uRHV3EMtdZHAZw3UM/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 »

VB.NET Example Code to backup MySQL Database using mysqldump command in VB using Visual Studio 2015

<div dir="ltr" style="text-align: left;" trbidi="on">In this post, we will see how to create a simple VB.NET application to backup MySQL database using the same mysqldump command by firing command prompt from the VB application. For this example, I am using Visual Studio 2015 Community edition.<br><br>In some examples on the internet, you would also find the use of mysql connectors for Visual Studio. I have also used it and it works. But since in this post, I am directly going to fire the command prompt from the VB application just like we execute mysqldump command directly in command prompt, there is no need to use the mysql connector for backup purposes. It will however be required if your application is going to fetch data display data etc from a MySQL database in the VB application.<br><span style="font-size: large;"><br></span><span style="font-size: large;">The form designed is:</span><br><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQbEnaBgP7kvhiIkH8bCO3EvkJ7dho2y6hpZNlAyZOFTRUdiWm2M5g0JX-uga_noDtJB7rvVU0VDnrlNCN9wl61hX3qREbV_Pod0PPc54SA7LSa7qFJsRFxDTiJ-tLs-7EcPC2vKQ98oE/s1600/VB.NET+Example+Code+How+to+backup+MySQL+Database+using+mysqldump+command+in+VB.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="VB.NET Example Code: How to backup MySQL Database using mysqldump command in VB?" border="0" height="419" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQbEnaBgP7kvhiIkH8bCO3EvkJ7dho2y6hpZNlAyZOFTRUdiWm2M5g0JX-uga_noDtJB7rvVU0VDnrlNCN9wl61hX3qREbV_Pod0PPc54SA7LSa7qFJsRFxDTiJ-tLs-7EcPC2vKQ98oE/s640/VB.NET+Example+Code+How+to+backup+MySQL+Database+using+mysqldump+command+in+VB.jpg" title="VB.NET Example Code: How to backup MySQL Database using mysqldump command in VB?" width="640"></a> </div><br>Ignoring the other labels, the important form elements used in code are: <br></div><a href="https://techubber.blogspot.com/2016/10/vb-net-example-code-to-backup-mysql-database-using-command-prompt-code-visual-studio.html#more">Read more »</a>

VB.NET Example Code to backup MySQL Database using mysqldump command in VB using Visual Studio 2015

In this post, we will see how to create a simple VB.NET application to backup MySQL database using the same mysqldump command by firing comm...

Read more »

Batch File Example Code To Backup MySQL Database To A Particular Folder, Append Date and Time, Delete Backups Older Than X Days

<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/AVvXsEht8ZS6mcEJzJssUkXWf-a-83j0aGFNCjBLfmAzOdU0asw9-etWAh96g7Yair5DMjpzquDh_TisPwgUfXiGHcp1zA2wSqplX8pjnocgorCYszEBmmZECi1TmsX7s1LoVS8fvtVRXt_vDGg/s1600/Batch+File+Example+Code+To+Backup+MySQL+Database+To+A+Particular+Folder%252C+Append+Date+and+Time%252C+Delete+Backups+Older+Than+X+Days.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Batch File Example Code To Backup MySQL Database To A Particular Folder, Append Date and Time, Delete Backups Older Than X Days" border="0" height="242" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEht8ZS6mcEJzJssUkXWf-a-83j0aGFNCjBLfmAzOdU0asw9-etWAh96g7Yair5DMjpzquDh_TisPwgUfXiGHcp1zA2wSqplX8pjnocgorCYszEBmmZECi1TmsX7s1LoVS8fvtVRXt_vDGg/s400/Batch+File+Example+Code+To+Backup+MySQL+Database+To+A+Particular+Folder%252C+Append+Date+and+Time%252C+Delete+Backups+Older+Than+X+Days.jpg" title="Batch File Example Code To Backup MySQL Database To A Particular Folder, Append Date and Time, Delete Backups Older Than X Days" width="400"></a></div>In this post we will see how to make a batch file to take backup of MySQL database (single database) to a particular folder on the same computer. As you may already know, there are various variants of mysqldump command. But for this exercise we will use this command:<br><br><blockquote class="tr_bq"><b>mysqldump --routines -u<username> -p<password> <database name> > <output sql file name></b></blockquote><br><span style="font-size: large;"><b>Simple Batch File to backup MySQL Database:</b></span><br></div><a href="https://techubber.blogspot.com/2016/10/batch-file-example-code-to-backup-mysql-database-append-date-and-time-delete-older-particular-folder.html#more">Read more »</a>

Batch File Example Code To Backup MySQL Database To A Particular Folder, Append Date and Time, Delete Backups Older Than X Days

In this post we will see how to make a batch file to take backup of MySQL database (single database) to a particular folder on the same comp...

Read more »