Differences

This shows you the differences between two versions of the page.

--- ubuntu_notes [2019/01/26 11:46] – juckins
+++ ubuntu_notes [2019/04/08 14:39] – juckins
@@ Line 1: / Line 1: @@
 ==== Ubuntu Notes ====
-[[http://howtoubuntu.org/how-to-install-lamp-on-ubuntu|LAMP install]]
+[[https://linuxconfig.org/how-to-install-lamp-ubuntu-18-04-bionic-beaver-linux-apache-mysql-php|LAMP on Ubuntu 18.04]]
+[[http://howtoubuntu.org/how-to-install-lamp-on-ubuntu|General LAMP install]]
 [[https://help.ubuntu.com/stable/ubuntu-help/net-firewall-on-off.html|Firewall settings]]
+[[https://askubuntu.com/questions/44418/how-to-enable-root-login|Enabling root]] (or use sudo -i)
 Release info:
@@ Line 24: / Line 28: @@
 </code>
-  * [[https://linuxconfig.org/how-to-install-mate-desktop-on-ubuntu-18-04-bionic-beaver-linux|Install MATE Desktop]]
+  * [[https://linuxconfig.org/how-to-install-mate-desktop-on-ubuntu-18-04-bionic-beaver-linux|Install MATE Desktop link #1]]
+  * [[https://www.hiroom2.com/2018/05/06/ubuntu-1804-mate-en/|Install MATE Desktop link #2]]
   * [[Install UniFi on Ubuntu|Install UniFi on Ubuntu]]
@@ Line 39: / Line 44: @@
 </code>
-Very slow using Ubuntu GUI now - check [[https://thomas.vanhoutte.be/miniblog/guide-speed-up-ubuntu-virtualbox/|Speeding up Ubuntu]]
+Very slow using Ubuntu GUI now:
+  * Basically enable 3D acceleration in VirtualBox settings
+  * Allocate 128MB video RAM
+  * Also see these links:
+    * [[https://thomas.vanhoutte.be/miniblog/guide-speed-up-ubuntu-virtualbox/|Speeding up Ubuntu]]
+    * [[https://www.linuxbabe.com/virtualbox/speed-up-ubuntu-virtualbox]]
+Check that 3D acceleration is supported:
+  sudo apt install nux-tools
+  /usr/lib/nux/unity_support_test -p
+Installing mysql:
+<code>
+sudo apt install mysql-client-core-5.7
+sudo apt install mysql-server
+sudo /usr/bin/mysql_secure_installation
+</code>
+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 fix this locale error upon login:
+<code>
+-bash: warning: setlocale: LC_ALL: cannot change locale (en_US)
+</code>
+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.
 ----