VirtualBox running Ubuntu 18 Notes

20 Jul 2020

Updated VirtualBox to 6.1.12 and Ubuntu 18 would not login after MATE authentication screen (just got black screen). Went into /opt/VBoxGuestAdditions-6.1.8 and uninstalled the Guest Additions. Rebooted, logged in correctly. Then installed latest version of GuestAdditions. Rebooted again, logged in and all worked correctly.

If restarting makes the screen go black again, use CTRL-F in VirtualBox 2 times, and that restores it.

Other Notes

TeamViewer installation

LAMP on Ubuntu 18.04

General LAMP install

Firewall settings

Enabling root (or use sudo -i)

Release info:

lsb_release -a

View installed kernels:

# dpkg --list | grep linux-image

Remove old kernels:

Searching for Ubuntu Packages and versions

View installed packages:

# apt list --installed
# dpkg --get-selections | grep -v deinstall |grep unifi

Remove installed package:

# dpkg -r package_name

Ubuntu 18.04 LTS

sudo apt update
sudo apt install build-essential gcc make perl
sudo apt install vim
sudo apt install gnome-software
sudo apt install openssh-server
reboot

12 Sep 2019

Configure Apache HTTPS on Ubuntu 18

26 Jan 2019

Logging into Desktop GUI only gives a blank screen:

Use these commands to update packages, as it allows interactive use to answer questions:

sudo apt update
sudo apt upgrade
sudo apt --with-new-pkgs upgrade

Very slow using Ubuntu GUI now:

Check that 3D acceleration is supported:

sudo apt install nux-tools
/usr/lib/nux/unity_support_test -p

Installing mysql:

sudo apt install mysql-client-core-5.7   
sudo apt install mysql-server
sudo /usr/bin/mysql_secure_installation

Then login like this:

sudo mysql -u root -p

Login with a non-root user like this:

mysql -u username -p

See notes at https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-18-04 for setting up a new user

Other SQL commands/testing:

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password';
CREATE DATABASE dbname;
SET PASSWORD FOR 'username'@'localhost' = PASSWORD('password');

To allow logins to mysql via adminer:

https://serverfault.com/questions/1001274/adminer-denied-acces-for-user

# su -
# mysql -u root -p 
> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YOUR_PASSWORD';
# systemctl restart mysql
# systemctl restart apache2.service

To upgrade MySQL v5.7 to 8.x follow this link

To fix this locale error upon login:

-bash: warning: setlocale: LC_ALL: cannot change locale (en_US)

run the following:

sudo locale-gen en_US
locale -a

and confirm you see en_US now. See https://ubuntuforums.org/showthread.php?t=1675347&page=2 for more info.