Main Menu

search

You are here

mySQL on Dell tower Linux dual-boot

[last updated: 2019-11-06]
go to: Linux
go to: mySQL
go to: Dell tower
-----

  • This procedure executed on Dell tower Linux dual-boot partition on 2019-11-05.
    Currently running: Linux Mint 19.2 Tina
    python default: 2.7.15+
  • First, as always recommended before doing any changes:
    $ sudo apt update (about 2 min)
    $ sudo apt upgrade (unknown, but > 30min)
  • (link to:) Starting from this tutorial:
  • Instructions are given to add mySQL APT Repository. However when I go to Menu > Software Manager, and enter mysql in search box, I see that mysql-server and workbench are already there, so I'll skip that part of the tutorial procedure.
  • Installing MySQL with APT:
    • $ sudo apt-get install mysql-server (not used)
      However due to things I've read, instead I used:
      $ sudo apt install mysql-server (about 2 min)
      [contrary to tutorial, I was not asked for a password...]
  • to confirm mysql is running:
    $ sudo service mysql status
    (type 'q' to exit service function and get a prompt back)
    to stop:
    $ sudo service mysql stop
    to restart:
    $ sudo service mysql start
  • to install workbench, the GUI:
    $ sudo apt-get install mysql-workbench (about 3 min)
  • The tutorial had other instructions that I didn't do
    for upgrading release/version and installing other packages.
    I did not, but wondered if I should have installed the "shared client libraries."
  • for backing up the database and recovery to a saved backup:
    (link to:) go here
  • (link to:) another tutorial:
    • Installation:
      • 3 methods described:
        * pre-built packages (link to:) from: mysql.com
        * Linux Software Manager - the method I started above
        * using a LAMP package (recommended in this tutorial)
          However the (link to:) XAMPP site for downloading says that since XAMPP 5.5 it includes MariaDB, Not mySQL

.

.

.

eof