How to Install the MySQL ODBC Driver on Ubuntu 16.04 or Linux Mint 18.x

Source: https://www.datasunrise.com/blog/

# Download the ODBC driver:

Download ODBC driver for Ubuntu 16.04

wget https://dev.mysql.com/get/Downloads/Connector-ODBC/5.3/mysql-connector-odbc-5.3.10-linux-ubuntu16.04-x86-64bit.tar.gz

# Extract:

tar -xvf mysql-connector-odbc-5.3.10-linux-ubuntu16.04-x86-64bit.tar.gz

# Copy the driver to the ODBC folder:

sudo cp mysql-connector-odbc-5.3.10-linux-ubuntu16.04-x86-64bit/lib/libmyodbc5* /usr/lib/x86_64-linux-gnu/odbc/

# Install:

sudo mysql-connector-odbc-5.3.10-linux-ubuntu16.04-x86-64bit/bin/myodbc-installer -d -a -n "MySQL" -t "DRIVER=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc5w.so;"

# Check:

sudo mysql-connector-odbc-5.3.10-linux-ubuntu16.04-x86-64bit/bin/myodbc-installer -s -a -c2 -n "test" -t "DRIVER=MySQL;SERVER=127.0.0.1;DATABASE=mysql;UID=root;PWD=password"

[Result should be “Success”]

# Download the 32-bit ODBC driver:

Download 32-bit ODBC driver for Ubuntu 16.04

wget https://dev.mysql.com/get/Downloads/Connector-ODBC/5.3/mysql-connector-odbc-5.3.10-linux-ubuntu16.04-x86-32bit.tar.gz

# Extract:

tar -xvf mysql-connector-odbc-5.3.10-linux-ubuntu16.04-x86-32bit.tar.gz

# Copy the driver to the ODBC folder:

sudo cp mysql-connector-odbc-5.3.10-linux-ubuntu16.04-x86-32bit/lib/libmyodbc5* /usr/lib/i386-linux-gnu/odbc/

# Install:

sudo mysql-connector-odbc-5.3.10-linux-ubuntu16.04-x86-32bit/bin/myodbc-installer -d -a -n "MySQL" -t "DRIVER=/usr/lib/i386-linux-gnu/odbc/libmyodbc5w.so;"

# Check:

sudo mysql-connector-odbc-5.3.10-linux-ubuntu16.04-x86-32bit/bin/myodbc-installer -s -a -c2 -n "test" -t "DRIVER=MySQL;SERVER=127.0.0.1;DATABASE=mysql;UID=root;PWD=password"

[Result should be “Success”]

GRUB shows Windows 7 instead of Windows 10

source: link

author: david6

After installing Windows 10, every time I get a kernel update or I run the update-grub2 it always shows Windows 7 instead of Windows 10. How do I fix this permanently?

The reason why it still shows Windows 7 instead of Windows 10 is that the file /usr/lib/os-probes/mounted/20microsoft does not contain the label for Windows 10, so during the os-prober detection of the OS it falls back to Windows 7.

To correct this, you need to make the following changes to the /usr/lib/os-probes/mounted/20microsoft file:

NOTE: Always make a backup of the file before modifying it!

if item_in_dir -q bootmgr "$2"; then
        # there might be different boot directories in different case as:
        # boot Boot BOOT
        for boot in $(item_in_dir boot "$2"); do
                bcd=$(item_in_dir bcd "$2/$boot")
                if [ -n "$bcd" ]; then
                        if grep -qs "W.i.n.d.o.w.s. .1.0" "$2/$boot/$bcd"; then
                                long="Windows 10 (loader)"
                        elif grep -qs "W.i.n.d.o.w.s. .8" "$2/$boot/$bcd"; then
                                long="Windows 8 (loader)"
                        elif grep -qs "W.i.n.d.o.w.s. .7" "$2/$boot/$bcd"; then
                                long="Windows 7 (loader)"

the changes above are changing the line if grep -qs "W.i.n.d.o.w.s. .8" "$2/$boot/$bcd"; then to elif grep -qs "W.i.n.d.o.w.s. .8" "$2/$boot/$bcd"; then, and adding if grep -qs "W.i.n.d.o.w.s. .1.0" "$2/$boot/$bcd"; then and long="Windows 10 (loader)" above that line and saving it.

Once saved, then running os-prober now looks like this:

terrance@terrance-ubuntu:~$ sudo os-prober
[sudo] password for terrance: 
/dev/sdf1:Windows 10 (loader):Windows:chain

then running update-grub2 it will now make the updates to your /boot/grub/grub.cfgpermanent anytime you get a kernel update so it will show the correct version of Windows now (example below):

terrance@terrance-ubuntu:~$ sudo update-grub
Generating grub configuration file ...
Found linux image: /boot/vmlinuz-3.19.0-26-generic
Found initrd image: /boot/initrd.img-3.19.0-26-generic
Found linux image: /boot/vmlinuz-3.13.0-58-generic
Found initrd image: /boot/initrd.img-3.13.0-58-generic
Found linux image: /boot/vmlinuz-3.13.0-57-generic
Found initrd image: /boot/initrd.img-3.13.0-57-generic
Found memtest86+ image: /boot/memtest86+.elf
Found memtest86+ image: /boot/memtest86+.bin
Found Windows 10 (loader) on /dev/sdf1
done

Hope this helps!

Install Xfce 4.12 in Ubuntu using a PPA

Source: http://www.omgubuntu.co.uk/2015/03/xfce-4-12-released-after-almost-three-years, by SAM TRAN

Although probably not recommended just yet (early doors and all that) the Xubuntu Development PPA contains pre-release builds of Xfce 4.12 for Ubuntu 14.04 LTS and 14.10 users to install from at their own risk.

Add the Xubuntu Dev PPA to Ubuntu’s Software Sources using a Terminal and the following commands (assuming the Xfce desktop is already installed):

sudo add-apt-repository ppa:xubuntu-dev/xfce-4.12

sudo apt-get update && sudo apt-get dist-upgrade

To remove the PPA and downgrade to the version of PPA in the main Ubuntu repos/other installed PPAs the ‘ppa-purge’ utility should be installed and used:

sudo apt-get install ppa-purge

sudo ppa-purge ppa:xubuntu-dev/xfce-4.12

How to: Install Adobe Photoshop CS6 in Ubuntu Linux Machine

by Stanley @http://stanleytips.com

Today we will make a strong tutorial on How to install adobe CS5, CS6 or CC (Creative Cloud) within a Linux Machine (Ubuntu, Kubuntu and more). You will have to be carefull with our explanations because if you will miss a step then you can install in a wrong way and bugs will appear. So let’s start.

Note: In this tutorial you will learn how to download Adobe Photoshop CS6 free, download photoshop cs5 for free and the newest version from Adobe, CC (download photoshop CC for free). This use this tutorials as a lesson. We strongly recommend to buy a Adobe Photoshop licence from Creative Cloud. With a subscription at Adobe Creative Cloud you can use any tool from Adobe.

STEP 1: First of all you will need a ubuntu machine and a internet connection:);
STEP 2: On ubuntu, go at Ubunte Software Center and search for Wine 1.2 or later;
STEP 3: After finishing the wine install from Ubuntu Center, you will have to download a Adobe PS for Ubuntu;
STEP 4: Download links:

• Download link for Adobe Photoshop CS5 from HERE.
• Download link for Adobe Photoshop CS6 from HERE.

Note that these installers can be used for Linux and Windows.

STEP 5: After downloading the desired Photoshop version you need to UnZip the archive within a folder anywhere you want. But its recommended to unzip the files on your desktop (For a easy use );
STEP 6: Go on your Adobe PS extracted folder and search for the .EXE file -> Right click on the .EXE and select Open with wine windows program loader.

STEP 7: Continue the installing for the PS as like on a Windows Machine.(Because Wine will open the normal installer on your Ubuntu).
NOTE: Magic Fix will run in background during installation to make run Photoshop properly on Ubuntu without any problem. With this fix you can run Adobe Fireworks CS5, CS6 if you have on Windows Drive. STEP 8: After installing its done a Shotcut will be made on your ubuntu desktop. Now open it and ENJOY it.

source: http://stanleytips.com/how-to-install-adobe-photoshop-cs6-in-ubuntu-linux-machine/

Best Useful Indicators Collection for Ubuntu 13.10/13.04/12.10/12.04/Linux Mint

Indicators Collection for Ubuntu 13.10 Saucy/13.04 Raring/12.10 Quantal/12.04 Precise/11.10 Oneiric/11.04/10.10/10.04/Linux Mint 16/15/14/13/12/11/10/9/other Ubuntu derivatives @ http://www.noobslab.com/

Indicators are very handy to access main features of applications or standalone indicator provide different functionality for this desktop and these indicator can make user experience much better. This I have included many useful indicators for Ubuntu which can help easy access to features. This indicators collection support all current versions of Ubuntu (13.10/13.04/12.10/12.04) some previous versions, related Linux Mint versions, and other related Ubuntu derivatives. I can’t assure you that indicator will work in all desktop environments but works with any problem in Unity, Gnome Classic, Xfce, Mate and some in Gnome Shell/Cinnamon. I didn’t check indicators on Linux Mint, hopefully they shall work with Linux Mint. All indicators are up-to-date.

INSTALL ADB AND FASTBOOT ANDROID TOOLS IN UBUNTU VIA PPA

Written by Andrew @ http://www.webupd8.org

A package called “android-tools”, which comes with “adb” and “fastboot” command line utilities, has been uploaded to the Ubuntu 12.10 Quantal Quetzal repositories recently. I’ve got a request to upload this package in a PPA for older Ubuntu releases, so I’ve backported it to Ubuntu 12.04, 11.10 and 11.04.

INSTALL POWERTOP 2.1 IN UBUNTU 12.04 PRECISE PANGOLIN VIA PPA

Written by ANDREW @ http://www.webupd8.org

PowerTOP is a command line tool that helps diagnose issues with power consumption and provides suggestions on how to improve power usage.

PowerTOP 2.1, released a few days ago, introduces support for Intel GPUs and for cores without P-states, a new manual page along with an option to specify workload to run during measurement and an option to suppress output to the terminal.

A List Of 22 Application Indicators For Unity – Ubuntu 12.04/11.10

@ http://www.upubuntu.com

In this page we will introduce 22 application indicators that you can install under Ubuntu 12.04/11.10 with Unity enabled. An application indicator is a small program that appears on your top panel of Ubuntu. If you have more interesting indicators that are not mentioned in this list, you can include them in the comment form given below.

How To Install Faenza Icons On Ubuntu 12.04

By tinuz @ http://www.n00bsonubuntu.net

The Faenza icon theme for Gnome provides monochromatic icons for panels, toolbars and buttons and colourful squared icons for devices, applications, folder, files and Gnome menu items. Four themes are included to fit with light or dark themes/panels.

Reset password using Grub

Restart your computer, and hold down the Shift during bootup to get into the grub menu.

If you have a dual-boot machine and you choose at boot time which operating system to boot into, the grub menu should appear without the need to hold down the Shift key.

If you are unable to get into the Grub boot menu, and therefore cannot choose to boot into recovery mode, you can use a live CD to reset your user password.

Press the down arrow on your keyboard to highlight the line that ends with the words ‘recovery mode’, then press Enter.

Your computer will now begin the boot process. After a few moments, a Recovery Menu will appear. Use your down arrow key to highlight root and press Enter.