WebServer - Debian based Linux

MySQL on Debian

Debian does not have MySQL in its repositories... :(

We can solve this!

Check the MySQL download page for current version...

If you're happy with 8.0.27, go ahead, download & install.

• wget https://dev.mysql.com/get/mysql-apt-config_0.8.20-1_all.deb
• sudo apt install ./mysql-apt-config_0.8.20-1_all.deb

It may ask about distro version. On LMDE 4 or SparkyLinux 5, Select "debian buster" (It won't ask on Debian...)

Select "Ok"

Select "Ok"

Some versions will also ask about Configuring mysql-community-server

• Pick a good root password...
• I tend to select Use Legacy Authentication Method because Use Strong Password Encryption is annoying as hell. (Your choice here...)

Update & Upgrade everything now...

• sudo apt update
• sudo apt upgrade

Now you can go ahead & pretend they haven't dropped MySQL from the Debian repos...

VIM (& fixing it on Debian)

(as installed on Debian) has mouse weirdness. Selecting text with the mouse automatically enters visual mode. This prevents useful things like using the mouse to copy/paste while editing in the terminal. (Visual Mode is stupid...)

Solution

Either enter:

• :set mouse-=a

during an editing session, or even better, put it (without the leading colon) in your ~/.vimrc file. (create the .vimrc file if it's not already there...)

• vim ~/.vimrc

set mouse-=a

If you tend to use vim via sudo a lot... (duh... Who doesn't?)

• sudo vim ~root/.vimrc

Sadly, this seems to turn off the colour syntax hilighting.

But!

add

syntax on

to the .vimrc files & it's back.