Christopher Juckins

SysAdmin Tips, Tricks and other Software Tools

User Tools

Site Tools


ubuntu_notes

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
ubuntu_notes [2019/01/26 11:51]
juckins
ubuntu_notes [2019/04/08 14:39] (current)
juckins
Line 1: Line 1:
 ==== Ubuntu Notes ==== ==== 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://​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:  ​ Release info:  ​
Line 24: Line 28:
 </​code>​ </​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]]   * [[Install UniFi on Ubuntu|Install UniFi on Ubuntu]]
  
Line 39: Line 44:
 </​code>​ </​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: Installing mysql:
 +
 <​code>​ <​code>​
 sudo apt install mysql-client-core-5.7 ​   sudo apt install mysql-client-core-5.7 ​  
 sudo apt install mysql-server sudo apt install mysql-server
-</code?+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.
  
 ---- ----
ubuntu_notes.1548521511.txt.gz · Last modified: 2019/01/26 11:51 by juckins