Upgrading MySQL 5.5 to 5.7 in Debian

I know, MySQL 5.5 is quite old, let’s get an upgrade then.

First of all, let’s backup the databases:

Download the latest APT package repository

Make sure you download the latest version of the package. Then instal it using dpkg:

you will be prompted with a dialog box, asking which version to install. If MySQL 5.7 isn’t there, press enter then select the version 5.7 from the list, select OK.

Then run the package update:

you will see the MySQL package is on the list:

Next step is to install the MySQL:

This is the most important step you can’t miss, upgrade the existing databases:

Final step, restart the database:

Done!

How To, Linux, , Leave a comment

How To Fix Random Freeze After Update on Windows 10

In last 2 major updates (anniversary update end of 2016 and creator update April 2017), I experienced random freezes, it was completely frozen, even if you look at log viewer the message show “force reboot” without any details.

So I began to look at the current status of my PC’s hardware using speccy, nothing seems wrong, temperature, voltage, etc, looks normal. I also updated all drivers, memory check, etc, but the issue persists.

Continue reading “How To Fix Random Freeze After Update on Windows 10”

Hardware, How To, Windows2 Comments

How to Make Your Xiaomi Phone as USB Modem on PC

Everything bad could happen during your run to your deadline, including your internet connection. I was in that situation couple weeks ago, just a few hours before I should send the document, the connection suddenly went down, and all my data are on the PC no WiFi module available. The first thing I remember was to use my Xiaomi phone to work as Internet Modem. Continue reading “How to Make Your Xiaomi Phone as USB Modem on PC”

Hardware, How To, Windows, , Leave a comment