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
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.