apt install php php-mbstring php-xml php-mysql apt install mysql-server # ติดตั้งใช้งานครั้งแรก mysql_secure_installation
mysql -u [username] -p
DESC mysql.user: SELECT host, user FROM mysql.user; CREATE USER 'username'@'hostname' IDENTIFIED BY 'password'; -- Hostname % or Localhost DROP USER 'username'@'hostname';
SHOW VARIABLES LIKE 'validate_%'; SET GLOBAL validate_password_policy=LOW;
-- List all DATABASE SHOW DATABASES; -- List database with DEFAULT_CHARACTER_SET_NAME and DEFAULT_COLLATION_NAME SELECT * FROM INFORMATION_SCHEMA.SCHEMATA; -- Create DATABASE and set CHARACTER_SET and COLLATION_NAME CREATE DATABASE db_name [DEFAULT] CHARACTER SET utf8 [DEFAULT] COLLATE utf8_general_ci; -- Change CHARACTER_SET and COLLATION_NAME ALTER DATABASE db_name [DEFAULT] CHARACTER SET utf8 [DEFAULT] COLLATE utf8_general_ci; -- Grant user to database GRANT ALL PRIVILEGES ON *.* TO 'username'@'host'; GRANT ALL PRIVILEGES ON db_name.* TO 'username'@'host'; GRANT ALL|SELECT|INSERT|UPDATE|DELETE ON db_name.* TO 'username'@'host'; FLUSH PRIVILEGES; -- Show user grant; SHOW GRANTS FOR 'username'@'hostname'; -- Revoke REVOKE ALL PRIVILEGES ON *.* TO 'username'@'host'; REVOKE ALL PRIVILEGES ON db_name.* TO 'username'@'host'; REVOKE ALL|SELECT|INSERT|UPDATE|DELETE ON db_name.* TO 'username'@'host';
-- Create table and set CHARACTER_SET and COLLATION_NAME CREATE TABLE tbl_name (column_list) [DEFAULT] CHARACTER SET charset_name COLLATE collation_name; -- Change table and set CHARACTER_SET and COLLATION_NAME ALTER TABLE tbl_name (column_list) [DEFAULT] CHARACTER SET charset_name COLLATE collation_name;
-- Temp SHOW VARIABLES LIKE 'collation%';
QUIT;
dpkg -l cron # cron installed Desired=Unknown/Install/Remove/Purge/Hold | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad) ||/ Name Version Architecture Description +++-===============-====================-===============-============================== ii cron 3.0pl1-128.1ubuntu1 amd64 process scheduling daemon
apt update apt install cron systemctl status cron
{
"projects": {
"default": "angular-travis-ci"
}
}
ตัวอย่างไฟล์ firebase.json ตรง public ใส่ Path ของไฟล์ที่เก็บ Build แล้วของผม Project ชื่อ travis-ci {
"hosting": {
"public": "dist/travis-ci",
"ignore": [
"firebase.json",
"**/.*",
"**/node_modules/**"
],
"rewrites": [
{
"source": "**",
"destination": "/index.html"
}
]
}
}
Welcome to Ubuntu 18.04.4 LTS (GNU/Linux 4.15.0-76-generic x86_64)
* Documentation: https://help.ubuntu.com
* Management: https://landscape.canonical.com
* Support: https://ubuntu.com/advantage
System information as of Mon Feb 3 14:55:06 +07 2020
System load: 0.0 Users logged in: 0
Usage of /: 7.8% of 77.26GB IP address for ens192: 10.1.4.50
Memory usage: 3% IP address for ens224: 192.168.0.115
Swap usage: 0% IP address for lxdbr1: 172.168.0.1
Processes: 202
* Overheard at KubeCon: "microk8s.status just blew my mind".
https://microk8s.io/docs/commands#microk8s.status
* Canonical Livepatch is available for installation.
- Reduce system reboots and improve kernel security. Activate at:
https://ubuntu.com/livepatch
0 packages can be updated.
0 updates are security updates.
Failed to connect to https://changelogs.ubuntu.com/meta-release-lts.
Check your Internet connection or proxy settings
Last login: Mon Feb 3 14:44:48 2020 from 192.168.0.251
sarankon@conf:~$ lxd init
Would you like to use LXD clustering? (yes/no) [default=no]:
Do you want to configure a new storage pool? (yes/no) [default=yes]: no
Would you like to connect to a MAAS server? (yes/no) [default=no]:
Would you like to create a new local network bridge? (yes/no) [default=yes]: no
Would you like to configure LXD to use an existing bridge or host interface? (yes/no) [default=no]: yes
Name of the existing bridge or host interface: lxdbr1
Would you like LXD to be available over the network? (yes/no) [default=no]:
Would you like stale cached images to be updated automatically? (yes/no) [default=yes]
Would you like a YAML "lxd init" preseed to be printed? (yes/no) [default=no]:
sarankon@conf:~$
# สร้างไฟล์ PEM ที่รวมทั้ง Private Key และ Certificate จากไฟล์ PFX openssl pkcs12 -in filename.pfx -out cert.pem -nodes # สร้างไฟล์ Private Key จากไฟล์ PFX openssl pkcs12 -in filename.pfx -nocerts -out key.pem # สร้างไฟล์ Certificate จากไฟล์ PFX openssl pkcs12 -in filename.pfx -clcerts -nokeys -out cert.pem # ลบรหัสผ่านออกจาก Private Key openssl rsa -in key.pem -out server.key
ng build --prod ng build --prod --base-href=/project-name/
import { BrowserModule } from '@angular/platform-browser';
import { NgModule } from '@angular/core';
import { HttpClientModule } from '@angular/common/http';
import { ReactiveFormsModule } from '@angular/forms';
import { AppRoutingModule } from './app-routing.module';
import { AppComponent } from './app.component';
import { RouterModule } from '@angular/router';
import { TopBarComponent } from './top-bar/top-bar.component';
import { ProductListComponent } from './product-list/product-list.component';
import { ProductAlertsComponent } from './product-alerts/product-alerts.component';
import { ProductDetailComponent } from './product-detail/product-detail.component';
import { CartComponent } from './cart/cart.component';
@NgModule({
declarations: [
AppComponent,
TopBarComponent,
ProductListComponent,
ProductAlertsComponent,
ProductDetailComponent,
CartComponent
],
imports: [
BrowserModule,
HttpClientModule,
AppRoutingModule,
ReactiveFormsModule,
RouterModule.forRoot([
{ path: '', component: ProductListComponent },
{ path: 'product/:productId', component: ProductDetailComponent },
{ path: 'cart', component: CartComponent}
]),
],
providers: [],
bootstrap: [AppComponent]
})
export class AppModule { }
[
{
"type": "Overnight",
"price": "25.99"
},{
"type": "2-Day",
"price": "9.99"
},{
"type": "Postal",
"price": "2.99"
}
]
import { Injectable } from '@angular/core';
@Injectable({
providedIn: 'root'
})
export class CartService {
constructor() { }
}
import { Injectable } from '@angular/core';
@Injectable({
providedIn: 'root'
})
export class CartService {
items = [];
addItem(product) {
this.items.push(product);
}
getItems() {
return this.items;
}
clearItems() {
this.items = [];
}
constructor() { }
}