# Install MySQL Server sudo apt update sudo apt install mysql-server # Check MySQL Status sudo systemctl status mysql
# Initial Server sudo mysql_secure_installation Securing the MySQL server deployment. Connecting to MySQL using a blank password. VALIDATE PASSWORD PLUGIN can be used to test passwords and improve security. It checks the strength of password and allows the users to set only those passwords which are secure enough. Would you like to setup VALIDATE PASSWORD plugin? Press y|Y for Yes, any other key for No: Please set the password for root here. New password: Re-enter new password: By default, a MySQL installation has an anonymous user, allowing anyone to log into MySQL without having to have a user account created for them. This is intended only for testing, and to make the installation go a bit smoother. You should remove them before moving into a production environment. Remove anonymous users? (Press y|Y for Yes, any other key for No) : ... skipping. Normally, root should only be allowed to connect from 'localhost'. This ensures that someone cannot guess at the root password from the network. Disallow root login remotely? (Press y|Y for Yes, any other key for No) : ... skipping. By default, MySQL comes with a database named 'test' that anyone can access. This is also intended only for testing, and should be removed before moving into a production environment. Remove test database and access to it? (Press y|Y for Yes, any other key for No) : ... skipping. Reloading the privilege tables will ensure that all changes made so far will take effect immediately. Reload privilege tables now? (Press y|Y for Yes, any other key for No) : ... skipping. All done!
# Install PostgreSQL sudo apt update sudo apt install wget gnupg2
deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
# Import repository signing key, then update package lists wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - sudo apt update # Install PostgreSQL, ถ้าไม่ทำตามขั้นตอนข้างบนจะติดตั้งตาม Version ที่มากับ Repository ของ Linux sudo apt install postgresql postgresql-contrib # Check PostgreSQL Status sudo systemctl status postgresql
# Connect to PostgreSQL sudo su - postgres psql
-- Show your connection information \connifo -- You are connected to database "postgres" as user "postgres" -- via socket in "/var/run/postgresql" at port "5432". -- Show help \? -- Quit \q
Dialect: Oracle Read Only: Read Only Type: JDBC URL: jdbc:oracle:thin:@//host:port/servicename Username: username Password: password Driver: oracle.jdbc.driver.OracleDriver
Dialect: PostgreSQL Read Only: Read Only Type: JDBC URL: jdbc:postgresql://host:port/databasename Username: username Password: password Driver: org.postgresql.Driver
Dialect: MySQL/MariaDB Read Only: Read Only Type: JDBC URL: jdbc:mysql://host:port/databasename Username: username Password: password Driver: com.mysql.jdbc.Driver
sudo apt install software-properties-common sudo add-apt-repository ppa:webupd8team/java sudo apt update sudo apt install oracle-java8-installer sudo apt install oracle-java8-set-default # Setup JAVA_HOME export JAVA_HOME=/usr/lib/jvm/java-8-oracle export PATH=$JAVA_HOME/bin:$PATH # Verify JDK is Installed java -version # java version "1.8.0_201" # Java(TM) SE Runtime Environment (build 1.8.0_201-b09) # Java HotSpot(TM) 64-Bit Server VM (build 25.201-b09, mixed mode)Reference: Command [add-apt-repository] Missing | Install Java 8 | Setup System Variables
Usage: lxc [command] Available Commands: delete Delete containers and snapshots info Show container or server information remote Manage the list of remote servers rename Rename containers and snapshots restore Restore containers from snapshots snapshot Create container snapshots
sarankon@ubuntu:~$ lxc network
Description:
Manage and attach containers to networks
Usage:
lxc network [command]
Available Commands:
attach Attach network interfaces to containers
attach-profile Attach network interfaces to profiles
create Create new networks
delete Delete networks
detach Detach network interfaces from containers
detach-profile Detach network interfaces from profiles
edit Edit network configurations as YAML
get Get values for network configuration keys
list List available networks
list-leases List DHCP leases
rename Rename networks
set Set network configuration keys
show Show network configurations
unset Unset network configuration keys
Global Flags:
--debug Show all debug messages
--force-local Force using the local unix socket
-h, --help Print help
-v, --verbose Show all information messages
--version Print version number
Use "lxc network [command] --help" for more information about a command.
from django.db import models
# Create your models here.
class Topic(models.Model):
top_name = models.CharField(max_length=264, unique=True)
def __str__(self):
return self.top_name
class Webpage(models.Model):
topic = models.ForeignKey(Topic)
name = models.CharField(max_length=264, unique=True)
url = models.URLField(unique=True)
def __str__(self):
return self.name
class AccessRecord(models.Model):
name = models.ForeignKey(Webpage)
date = models.DateField()
def __str__(self):
return str(self.date)
# return value on admin interface
pip install django==1.10
# django-admin startproject [project-name] django-admin startproject first_project
sudo apt install xfce4 xfce4-goodies xfonts-thai sudo apt install vnc4server
vncpasswd vncserver vncserver -kill :1 nano ~/.vnc/xstartup
#!/bin/bash startxfce4 &
vncserver ss -ltn
sudo apt install python3 python3-venv
python3 -m venv [enviroment-name]
source (venv)/bin/activate decactivate