Archiv štítku: apache2

phpMyAdmin, MariaDB, php7.4 na Linux Mint 20.2 Uma

Publikováno 2021-12-10 | Autor: admin

HW: Acer Spin 5 – 13,3T“/ i7-8550U/ 16G/ 512SSD/ W10 šedý + stylus

//
root@portable-Spin-SP513-52N:~# inxi -Fxxxrz
System:    Kernel: 5.4.0-74-generic x86_64 bits: 64 compiler: gcc v: 9.3.0 Desktop: Cinnamon 5.0.7 wm: muffin 5.0.2 
           dm: LightDM 1.30.0 Distro: Linux Mint 20.2 Uma base: Ubuntu 20.04 focal 
Machine:   Type: Convertible System: Acer product: Spin SP513-52N v: V1.15 serial: <filter> 
           Mobo: KBL model: Woody_KL v: V1.15 serial: <filter> UEFI: Insyde v: 1.15 date: 04/18/2019 
Battery:   ID-1: BAT0 charge: 41.3 Wh condition: 41.3/54.2 Wh (76%) volts: 12.4/11.6 model: PANASONIC AP15O5L type: Li-ion 
           serial: <filter> status: Not charging 
           Device-1: hid-0003:04F3:2560.0002-battery model: ELAN Touchscreen serial: N/A charge: N/A status: N/A 
CPU:       Topology: Quad Core model: Intel Core i7-8550U bits: 64 type: MT MCP arch: Kaby Lake rev: A L1 cache: 256 KiB 
           L2 cache: 8192 KiB L3 cache: 8192 KiB 
           flags: avx avx2 lm nx pae sse sse2 sse3 sse4_1 sse4_2 ssse3 vmx bogomips: 31999 
           Speed: 400 MHz min/max: 400/4000 MHz Core speeds (MHz): 1: 400 2: 400 3: 400 4: 400 5: 400 6: 400 7: 399 8: 400 
Graphics:  Device-1: Intel UHD Graphics 620 vendor: Acer Incorporated ALI driver: i915 v: kernel bus ID: 00:02.0 
           chip ID: 8086:5917 
           Display: server: X.Org 1.20.9 driver: modesetting unloaded: fbdev,vesa resolution: 1920x1080~60Hz 
           OpenGL: renderer: Mesa Intel UHD Graphics 620 (KBL GT2) v: 4.6 Mesa 21.0.3 direct render: Yes 
Audio:     Device-1: Intel Sunrise Point-LP HD Audio vendor: Acer Incorporated ALI driver: snd_hda_intel v: kernel 
           bus ID: 00:1f.3 chip ID: 8086:9d71 
           Sound Server: ALSA v: k5.4.0-74-generic 
Network:   Device-1: Qualcomm Atheros QCA6174 802.11ac Wireless Network Adapter vendor: Lite-On driver: ath10k_pci v: kernel 
           port: 3040 bus ID: 01:00.0 chip ID: 168c:003e 
           IF: wlp1s0 state: up mac: <filter> 
Drives:    Local Storage: total: 476.94 GiB used: 7.99 GiB (1.7%) 
           ID-1: /dev/sda vendor: SK Hynix model: HFS512G39TND-N210A size: 476.94 GiB speed: 6.0 Gb/s serial: <filter> 
           rev: 1P10 temp: 28 C scheme: GPT 
Partition: ID-1: / size: 467.02 GiB used: 7.98 GiB (1.7%) fs: ext4 dev: /dev/dm-0 
           ID-2: swap-1 size: 980.0 MiB used: 0 KiB (0.0%) fs: swap dev: /dev/dm-1 
Sensors:   System Temperatures: cpu: 42.0 C mobo: 37.0 C 
           Fan Speeds (RPM): N/A 
Repos:     No active apt repos in: /etc/apt/sources.list 
           Active apt repos in: /etc/apt/sources.list.d/official-package-repositories.list 
           1: deb http://packages.linuxmint.com uma main upstream import backport #id:linuxmint_main
           2: deb http://archive.ubuntu.com/ubuntu focal main restricted universe multiverse
           3: deb http://archive.ubuntu.com/ubuntu focal-updates main restricted universe multiverse
           4: deb http://archive.ubuntu.com/ubuntu focal-backports main restricted universe multiverse
           5: deb http://security.ubuntu.com/ubuntu/ focal-security main restricted universe multiverse
           6: deb http://archive.canonical.com/ubuntu/ focal partner
Info:      Processes: 261 Uptime: 2h 41m Memory: 15.55 GiB used: 2.38 GiB (15.3%) Init: systemd v: 245 runlevel: 5 Compilers: 
           gcc: 9.3.0 alt: 9 Shell: bash (sudo) v: 5.0.17 running in: gnome-terminal inxi: 3.0.38 
root@portable-Spin-SP513-52N:~#

root@portable-Spin-SP513-52N:~# inxi -Fxxxrz

System: Kernel: 5.4.0-74-generic x86_64 bits: 64 compiler: gcc v: 9.3.0 Desktop: Cinnamon 5.0.7 wm: muffin 5.0.2

dm: LightDM 1.30.0 Distro: Linux Mint 20.2 Uma base: Ubuntu 20.04 focal

Machine: Type: Convertible System: Acer product: Spin SP513-52N v: V1.15 serial: <filter>

Mobo: KBL model: Woody_KL v: V1.15 serial: <filter> UEFI: Insyde v: 1.15 date: 04/18/2019

Battery: ID-1: BAT0 charge: 41.3 Wh condition: 41.3/54.2 Wh (76%) volts: 12.4/11.6 model: PANASONIC AP15O5L type: Li-ion

serial: <filter> status: Not charging

Device-1: hid-0003:04F3:2560.0002-battery model: ELAN Touchscreen serial: N/A charge: N/A status: N/A

CPU: Topology: Quad Core model: Intel Core i7-8550U bits: 64 type: MT MCP arch: Kaby Lake rev: A L1 cache: 256 KiB

L2 cache: 8192 KiB L3 cache: 8192 KiB

flags: avx avx2 lm nx pae sse sse2 sse3 sse4_1 sse4_2 ssse3 vmx bogomips: 31999

Speed: 400 MHz min/max: 400/4000 MHz Core speeds (MHz): 1: 400 2: 400 3: 400 4: 400 5: 400 6: 400 7: 399 8: 400

Graphics: Device-1: Intel UHD Graphics 620 vendor: Acer Incorporated ALI driver: i915 v: kernel bus ID: 00:02.0

chip ID: 8086:5917

Display: server: X.Org 1.20.9 driver: modesetting unloaded: fbdev,vesa resolution: 1920x1080~60Hz

OpenGL: renderer: Mesa Intel UHD Graphics 620 (KBL GT2) v: 4.6 Mesa 21.0.3 direct render: Yes

Audio: Device-1: Intel Sunrise Point-LP HD Audio vendor: Acer Incorporated ALI driver: snd_hda_intel v: kernel

bus ID: 00:1f.3 chip ID: 8086:9d71

Sound Server: ALSA v: k5.4.0-74-generic

Network: Device-1: Qualcomm Atheros QCA6174 802.11ac Wireless Network Adapter vendor: Lite-On driver: ath10k_pci v: kernel

port: 3040 bus ID: 01:00.0 chip ID: 168c:003e

IF: wlp1s0 state: up mac: <filter>

Drives: Local Storage: total: 476.94 GiB used: 7.99 GiB (1.7%)

ID-1: /dev/sda vendor: SK Hynix model: HFS512G39TND-N210A size: 476.94 GiB speed: 6.0 Gb/s serial: <filter>

rev: 1P10 temp: 28 C scheme: GPT

Partition: ID-1: / size: 467.02 GiB used: 7.98 GiB (1.7%) fs: ext4 dev: /dev/dm-0

ID-2: swap-1 size: 980.0 MiB used: 0 KiB (0.0%) fs: swap dev: /dev/dm-1

Sensors: System Temperatures: cpu: 42.0 C mobo: 37.0 C

Fan Speeds (RPM): N/A

Repos: No active apt repos in: /etc/apt/sources.list

Active apt repos in: /etc/apt/sources.list.d/official-package-repositories.list

1: deb http://packages.linuxmint.com uma main upstream import backport #id:linuxmint_main

2: deb http://archive.ubuntu.com/ubuntu focal main restricted universe multiverse

3: deb http://archive.ubuntu.com/ubuntu focal-updates main restricted universe multiverse

4: deb http://archive.ubuntu.com/ubuntu focal-backports main restricted universe multiverse

5: deb http://security.ubuntu.com/ubuntu/ focal-security main restricted universe multiverse

6: deb http://archive.canonical.com/ubuntu/ focal partner

Info: Processes: 261 Uptime: 2h 41m Memory: 15.55 GiB used: 2.38 GiB (15.3%) Init: systemd v: 245 runlevel: 5 Compilers:

gcc: 9.3.0 alt: 9 Shell: bash (sudo) v: 5.0.17 running in: gnome-terminal inxi: 3.0.38

root@portable-Spin-SP513-52N:~#

Kontrola verze OS:

portable@portable-Spin-SP513-52N:~$ cat /etc/os-release
NAME="Linux Mint"
VERSION="20.2 (Uma)"
ID=linuxmint
ID_LIKE=ubuntu
PRETTY_NAME="Linux Mint 20.2"
VERSION_ID="20.2"
HOME_URL="https://www.linuxmint.com/"
SUPPORT_URL="https://forums.linuxmint.com/"
BUG_REPORT_URL="http://linuxmint-troubleshooting-guide.readthedocs.io/en/latest/"
PRIVACY_POLICY_URL="https://www.linuxmint.com/"
VERSION_CODENAME=uma
UBUNTU_CODENAME=focal
portable@portable-Spin-SP513-52N:~$

portable@portable-Spin-SP513-52N:~$ cat /etc/os-release

NAME="Linux Mint"

VERSION="20.2 (Uma)"

ID=linuxmint

ID_LIKE=ubuntu

PRETTY_NAME="Linux Mint 20.2"

VERSION_ID="20.2"

HOME_URL="https://www.linuxmint.com/"

SUPPORT_URL="https://forums.linuxmint.com/"

BUG_REPORT_URL="http://linuxmint-troubleshooting-guide.readthedocs.io/en/latest/"

PRIVACY_POLICY_URL="https://www.linuxmint.com/"

VERSION_CODENAME=uma

UBUNTU_CODENAME=focal

portable@portable-Spin-SP513-52N:~$

xxx

//
portable@portable-Spin-SP513-52N:~$ sudo apt install -y apache2 mariadb-server mariadb-client php libapache2-mod-php
sudo systemctl enable apache2
sudo systemctl enable mariadb
sudo systemctl start apache2
sudo systemctl start mariadb
sudo mysql -v
portable@portable-Spin-SP513-52N:~$

portable@portable-Spin-SP513-52N:~$ sudo apt install -y apache2 mariadb-server mariadb-client php libapache2-mod-php

sudo systemctl enable apache2

sudo systemctl enable mariadb

sudo systemctl start apache2

sudo systemctl start mariadb

sudo mysql -v

portable@portable-Spin-SP513-52N:~$

xxx

//
portable@portable-Spin-SP513-52N:~$ sudo mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user.  If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none): 
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.

You already have a root password set, so you can safely answer 'n'.

Change the root password? [Y/n] Y
New password: 
Re-enter new password: 
Password updated successfully!
Reloading privilege tables..
 ... Success!


By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB 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? [Y/n] Y
 ... Success!

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? [Y/n] n
 ... skipping.

By default, MariaDB 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? [Y/n] Y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] Y
 ... Success!

Cleaning up...

All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!
portable@portable-Spin-SP513-52N:~$

portable@portable-Spin-SP513-52N:~$ sudo mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB

SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current

password for the root user. If you've just installed MariaDB, and

you haven't set the root password yet, the password will be blank,

so you should just press enter here.

Enter current password for root (enter for none):

OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MariaDB

root user without the proper authorisation.

You already have a root password set, so you can safely answer 'n'.

Change the root password? [Y/n] Y

New password:

Re-enter new password:

Password updated successfully!

Reloading privilege tables..

... Success!

By default, a MariaDB installation has an anonymous user, allowing anyone

to log into MariaDB 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? [Y/n] Y

... Success!

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? [Y/n] n

... skipping.

By default, MariaDB 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? [Y/n] Y

- Dropping test database...

... Success!

- Removing privileges on test database...

... Success!

Reloading the privilege tables will ensure that all changes made so far

will take effect immediately.

Reload privilege tables now? [Y/n] Y

... Success!

Cleaning up...

All done! If you've completed all of the above steps, your MariaDB

installation should now be secure.

Thanks for using MariaDB!

portable@portable-Spin-SP513-52N:~$

XXX

// 
portable@portable-Spin-SP513-52N:~$ 
sudo apt install -y phpmyadmin

portable@portable-Spin-SP513-52N:~$

sudo apt install -y phpmyadmin

xxx Aplikace phpmyadmin jako spustitelná ikona v sekci Programování: phpmyadmin po spuštění: root password: Konečné řešení … Celý příspěvek →

Rubriky: Linux, LinuxMint, NET, Notebook, PHP, Python, TESTY | Štítky: Acer Spin (ISP513-52N-874P), apache2, Linux Mint 20.3, Maria DB, php7.4, phpMyAdmin | Napsat komentář

MySQL 8 on Linux Mint 20.2 Uma

Publikováno 2021-12-10 | Autor: admin

Install MySQL 8 on Ubuntu/Linux Mint xxx

//
portable@portable-Spin-SP513-52N:~$ php -v
PHP 7.4.3 (cli) (built: Nov 25 2021 23:16:22) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
    with Zend OPcache v7.4.3, Copyright (c), by Zend Technologies
portable@portable-Spin-SP513-52N:~$

portable@portable-Spin-SP513-52N:~$ php -v

PHP 7.4.3 (cli) (built: Nov 25 2021 23:16:22) ( NTS )

Zend Engine v3.4.0, Copyright (c) Zend Technologies

with Zend OPcache v7.4.3, Copyright (c), by Zend Technologies

portable@portable-Spin-SP513-52N:~$

xxx

//
portable@portable-Spin-SP513-52N:~$ cat /etc/upstream-release/lsb-release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=20.04
portable@portable-Spin-SP513-52N:~$

portable@portable-Spin-SP513-52N:~$ cat /etc/upstream-release/lsb-release

DISTRIB_ID=Ubuntu

DISTRIB_RELEASE=20.04

portable@portable-Spin-SP513-52N:~$

Rubriky: Linux, LinuxMint, NET, Notebook, PHP, Python, TESTY | Štítky: Acer Spin (ISP513-52N-874P), apache2, MySQL 8, php7.4, phpMyAdmin | Napsat komentář

Hledej zde:

Vyhledávání
Aktuálně
Červen 2022

Po Út St Čt Pá So Ne

1 2 3 4 5

6 7 8 9 10 11 12

13 14 15 16 17 18 19

20 21 22 23 24 25 26

27 28 29 30

« Kvě
Nejnovější komentáře
Nejnovější příspěvky
- STRABAK – přechod pro chodce 2022-06-26
- nodejs 2022-06-14
- FritzNAS 2022-06-02
- Drónování nad Olomoucí 2022-05-27
- DJI Mini 3 Pro Recenze: 2022-05-16
- Apeman A79 2022-05-16
- OpenShot – bílé pozadí 2022-05-15
- Mobil Realme 8 5G reset 2022-04-26
- 2022-05-07-Slavonín 2022-04-19
- OpenShot – Vytvářejte dynamické titulky 2022-04-15
- OpenShot – Custom Profile 2022-04-14
- DLS10K10 01T16A DALYELEC.COM 2022-04-11
- TotalCMD – Hromadné přejmenování souborů 2022-04-10
- An Eye on your system – Glances 2022-04-09
- How to Install Docker on Linux Mint 2022-04-09
- Shotcut – video-editor 2022-04-05
- Acer Spin 5 (SP513-52N) Info 2022-04-01
- Microsoft Flatpack 2022-03-29
- Blender 2.80 — classic a OpenShot 2022-03-29
- Pitivi – video-editor 2022-01-31
- TC Commander – Nástroj pro hromadné přejmenování 2022-01-25
- Pinnacle 24 Ultimate 2022-01-25
- USB Ethernet Adapter, Linux Mint 20 2022-01-21
- hp laserjet 1200 series driver win 10 x64 2022-01-17
- Check Disk for Errors Linux Mint 20.3 2022-01-17
- Všeměr 2022-01-17
- Zátěžový test a srovnávání výkonu CPU 2022-01-14
- SAMSUNG QE43Q65A QLED ULTRA HD LCD 2022-01-10
- How To Install Zabbix Server 5.0 on Ubuntu 20.04 2022-01-08
- Windows 10 Pro iso X64/X32 2022-01-07
Archivy
Rubriky
- 4K
- Android
- Apple
- Atom
- Blender — classic
- CAD
- Cestování
- Debian
- docker
- DPMO
- Dron
- DVB_T2
- Electric Bicycle
- Eletrokolo
- FritzNAS
- HBCD_PE_x64
- Linux
- LinuxMint
- Mobil
- NET
- Notebook
- OpenShot
- OpenWRT
- PHP
- Pitivi
- Python
- Raspberry Pi
- SAMBA
- SDR-MALACHIT-DSP
- TESTY
- Uncategorized
- Volby
- Windows
- Wine
Základní informace
Stránky

Červen 2022
Po	Út	St	Čt	Pá	So	Ne
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30

Archiv štítku: apache2

phpMyAdmin, MariaDB, php7.4 na Linux Mint 20.2 Uma

MySQL 8 on Linux Mint 20.2 Uma

Hledej zde:

Aktuálně

Nejnovější komentáře

Nejnovější příspěvky

Archivy

Rubriky

Základní informace

Stránky