• Home
  • WordPress
  • web Hosting
    • Free hosting
    • Cheap Hosting
    • comparison cloud , vps, shared, wordpress
    • managed wordpress hosting
    • managed cloud hosting
  • page Speed
  • Deals
  • Services
  • About

RAaz Kumar .com

wordpress tutorials seo hosting etc

mysql 8 installation on ubuntu 20.4

 

installing prebuilt mysql package from debian / ubuntu repository

 

sudo apt install mysql-server

installing pre built mysql from mysql server page

https://dev.mysql.com/downloads/repo/apt/
Ubuntu / Debian (Architecture Independent), DEB Package
(mysql-apt-config_0.8.16-1_all.deb)
check mysql latest version here
https://dev.mysql.com/downloads/mysql/
select ubuntu
MySQL Community Server 8.0.22
lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 20.04.1 LTS
Release: 20.04
Codename: focal
Ubuntu Linux 20.04 (x86, 64-bit), DEB Package
on right side click on download
login or signup no thanks to download
https://dev.mysql.com/get/Downloads/MySQL-8.0/libmysqlclient21_8.0.22-1ubuntu20.04_amd64.deb
download mysql package file command line
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/libmysqlclient21_8.0.22-1ubuntu20.04_amd64.deb
or
wget https://dev.mysql.com/get/mysql-apt-config_0.8.16-1_all.deb
(The MySQL APT repository provides a simple and convenient way to install and update MySQL products with the latest software packages using Apt)

Step 2

libmysqlclient21_8.0.22-1ubuntu20.04_amd64.ded

sudo dpkg -i mysql-apt-config_w.x.y-z_all.deb

ex: dpkg -i mysql-apt-config_0.8.12-1_all.deb

dpkg -i mysql-apt-config_0.8.16-1_all.deb

Which MySQL product do you wish to configure? │
│ │
│ MySQL Server & Cluster (Currently selected: mysql-8.0) │
│ MySQL Tools & Connectors (Currently selected: Enabled) │
│ MySQL Preview Packages (Currently selected: Disabled) │
│ Ok │
│ │
│ │
│ <Ok>

Step 3:

sudo apt-get update && sudo apt-get install mysql-server

The following NEW packages will be installed:
libcgi-fast-perl libcgi-pm-perl libencode-locale-perl libevent-core-2.1-7
libevent-pthreads-2.1-7 libfcgi-perl libhtml-parser-perl libhtml-tagset-perl
libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl
liblwp-mediatypes-perl libmecab2 libtimedate-perl liburi-perl mecab-ipadic
mecab-ipadic-utf8 mecab-utils mysql-client-8.0 mysql-client-core-8.0
mysql-common mysql-server mysql-server-8.0 mysql-server-core-8.0
0 upgraded, 25 newly installed, 0 to remove and 0 not upgraded.
Need to get 30.7 MB of archives.
After this operation, 249 MB of additional disk space will be used.
Do you want to continue? [Y/n]

 

Part 2: securing installation

sudo mysql_secure_installation

root@instance-1:~# sudo mysql_secure_installation

Securing the MySQL server deployment.

Connecting to MySQL using a blank password.

VALIDATE PASSWORD COMPONENT 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 component?

Press y|Y for Yes, any other key for No: y

There are three levels of password validation policy:

LOW Length >= 8
MEDIUM Length >= 8, numeric, mixed case, and special characters
STRONG Length >= 8, numeric, mixed case, special characters and dictionary file

Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 1
Please set the password for root here.

New password:

Re-enter new password:

Estimated strength of the password: 100
Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y
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) : 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? (Press y|Y for Yes, any other key for No) : y
Success.

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) : y

 

Next install php -fpm from ubuntu repository

sudo add-apt-repository ppa:ondrej/php
sudo apt-get update
sudo apt-get install -y php7.4-fpm

(use listing port ip instead of socket

Related topics:

  1. install lemp Linux, Nginx 1.15.12, MySQL 8, PHP fpm 8 on Ubuntu 20.04 #wordpress #digital ocean
  2. Lamp stack install on Ubuntu 20.4 LTS apache, mysql, php 7.4(Debian 9 & Ubuntu 18.04 lts)
  3. ubuntu tutorials installation download issues etc
  4. Redis / memcached installation on ubuntu 20.04 with wordpress mysql configuration
  5. nginx installation on ubuntu 20.04 LTS

 

PUBG Mobile Tips & Tricks

free fire how to play (a-z guide) guns, tips &#038; tricks etc

Windows 10 tips & tricks

Pagespeed optimization

Pc building tips & tricks

nginx server tutorials

apache server tutorials

linux sysadmin tutorials

mysql Commands list pdf

Android studio tutorials

Gaming/ streaming tips

Airtel dth channel list

 

tutorials

  • Android Studio tutorials syllabus Topics Course details #AndroidApplicationDevelopment
  • xampp tutorials 2021 installation errors fix wordpress phpmyadmin mysql apache
  • Devops course Syllabus topics PDF AWS, Azure, cisco, redhat
  • CCNA Syllabus pdf (CCNA / CCNP vs devops vs mcsa /MCSE)
  • how to create a website free of cost on google
  • what is vpn vs proxy vs tor, http vs https, http2, tcp vs udp, kali linux sql source code injection
  • nginx server tutorials (installation, configuration, performance tuning, security)
  • Vivek Bindra Videos Transcription (business strategy)
  • AUdio Editing Background Noise removal (Audacity, Adobe Premiere Addition, Camtasia Filmora Windows Obs)
  • MySQL Tutorial (create,connect database, update tables, export etc) Documentation & TIPS
    • mysqldump import /export mysql database command line, phpmyadmin, Cpanel, mysql workbench, xamp
    • mysql commands
    • phpmyadmin install / configure on nginx ubuntu 20.04 apache2 debian 10
    • improve mysql performance wordpress my.cnf file configuration
    • How measure & adjust mysql buffer pool size by pages, read requests etc
    • mysql workbench tutorials (Sql Development , modelling, server admin export & import)
    • mysql errors
    • Innodb vs myisam (table engines row lock vs table lock)
    • mysql max connections how to decide
    • MySQL innodb memory allocation & usage calculation
    • MySQL query cache vs redis vs memcached buffer pool database cache
    • mysql 8 installation on ubuntu 20.4
    • mysql configuration file location linux , windows , mac
  • [INTRO] Ethical hacking / cyber Security / Penetration testing Tutorial -{updates frequently}
  • ubuntu tutorials installation download issues etc
  • Php tutorials
  • HTML & CSS Tutorials
  • Core Java Tutorial Free online
  • Linux sysadmin tutorials linux system administrator
  • apache server tutorial (install,config, performance tuning, security, error handling)

wordpress

 

Top 5  WP Google Analytics Plugins

WP Backup Plugins

Wp Comment Plugins

Top wordpress Security Plugins

WP Seo Plugins

WP Caching Plugins

Best Adsense Plugins for WordPress

Wp social Sharing Plugins

autoshare social media plugins

WP speed Optimization Plugins

Speedup WordPress google Score

More Wp tuts

Server Admin Cloud

 

Installing Nginx LEMP On ubuntu

Installing apache Lamp ubuntu

nginx fastcgi cache enable

php – fpm install  & Configuration

Opcache install & Configure

php -fpm pool manager explained

Mysql Install & Configuration

Redis Object cache install & configure

 

Nginx as Reverse Proxy and Load balancer

Load Balance / auto scaling in google cloud

Linux Commands PDF

Mysql Commands Pdf

Letsencrypt tutorial

mysqldump export & import 

Pagespeed Module install & configure

nginx.conf best file

mysql.conf best file

upgrade ubuntu

© 2021 - All Rights Reserved Disclaimer & Privacy Policy