How to change MySQL’s root to use mysql_native_password in Ubuntu

How to change MySQL’s root to use mysql_native_password in Ubuntu

In some MySQL installation in Ubuntu. You cannot login as root because it is not configured to use mysql_native_password. In this post, I will teach you how to enable mysql_native_password. Log in to MySQL via terminal with sudo mysql -u root Once inside MySQL, we will need to change the default plugin authentication to mysql_native_password and set a password for root. mysql> ALTER USER root@localhost IDENTIFIED BY 'password'; mysql> exit You can now login in MySQL as root using the password you set....

October 8, 2020 · John Pili
create-android-studio-shortcut-on-ubuntu.webp

Create Android Studio Shortcut on Ubuntu 18.04

You can easily create an Android Studio shortcut by creating an desktop entry using the following the steps below. In this guide, my Android Studio is installed in /opt/android-studio folder. Your folder location may differ. Open terminal and type cd ~/.local/share/applications Create a .desktop file using your favorite text editor nano android-studio.desktop My .desktop file looks like this [Desktop Entry] Version=1.0 Type=Application Name=Android Studio Icon=/opt/android-studio/bin/studio.png Exec="/opt/android-studio/bin/studio.sh" %f Categories=Development;IDE; Terminal=false StartupWMClass=jetbrains-android-studio As a template for desktop entry you can use this snippet...

April 14, 2020 · John Pili
How-to-change-full-disk-encryption-LUKS-on-Ubuntu-18.04.webp

How to change Full Disk Encryption (LUKS) password on Ubuntu 18.04

Did you enabled the full disk encryption (LUKS) on Ubuntu 18.04? I would like to share how you can change the LUKS password. LUKS stands for Linux Unified Key Setup developed in 2004 by Clemens Fruhwirth. Similarly, Apple’s macOS have FileVault and BitLocker for Microsoft Windows operating system. In the terminal you can check the drives or partition with LUKS by using this command lsblk My result looks like this. Your result might differ slightly....

April 12, 2020 · John Pili
make-your-old-laptop-usable-again-with-linux.webp

Make your old laptop usable again with Linux

Revive your old laptop back in service using Lubuntu a light-weight version of Ubuntu. I bought this Lenovo IdeaPad S10-3 in 2012 when I was working in Muscat, Oman. This netbook has a blazing Intel Atom processor 1.66GHz, a 2GB DDR3 RAM, and 10″ LCD screen. I was initially thinking of giving it away because when I installed Ubuntu or CentOS it is sluggish and keeps on lagging. Then I stumble upon Lubuntu when I was researching about smallest Linux distribution....

March 29, 2020 · John Pili
access-windows-shared-folder-from-ubuntu-linux.webp

Connect to Windows Shared Folder on Ubuntu 18.04 LTS

In this post I will show you how to access Windows Shared folders from Ubuntu Linux. Install Samba sudo apt install samba In Nautilus file browser, Click Other Locations from the left panel and then enter the url of the windows share or IP address. Enter user credential if required. In common windows share settings putting WORKGROUP in the domain field will be enough Once you’ve successfully connected to the Windows Shared folder....

February 2, 2020 · John Pili
screen-recording-in-ubuntu-18-04-using-kazam.webp

Screen recording in Ubuntu 18.04 using Kazam

Part of my work is to screen record (screencast): software demos and programming tutorial. I am also a MacOS user and in Mac I used ScreenFlow for screencasting. Since using Ubuntu as my primary operating system at work. I wanted continue my screencasting work. I once used Kazam in mid 2019 and it can handle the basic screen recording requirement we will need, mostly. It is open-source and available from Ubuntu apt repository....

January 11, 2020 · John Pili
how-to-connect-to-a-cisco-vpn-in-ubuntu-18-04-lts.webp

How to connect to a Cisco VPN in Ubuntu 18.04 LTS

Here’s the simple steps for you to connect to a Cisco VPN in Ubuntu 18.04 LTS. Cisco, an American company is the leading provider and manufacturer of enterprise network devices, telecommunication hardware, networking security and networking software. According to smartprofile.io as of April 2018, Cisco holds a 73.9% market which makes it the undisputed leader in its industry. Without further ado here are the steps. Install vpnc and network-manager-vpnc-gnome sudo apt install vpnc network-manager-vpnc-gnome Enter your password Confirm installation After successfully installing the required software it is time to configure it....

October 16, 2018 · John Pili