티스토리 뷰

/etc/lsb-release

 

DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=20.04
DISTRIB_CODENAME=focal
DISTRIB_DESCRIPTION="Ubuntu 20.04.2 LTS"

install net-tools

 

sudo apt install net-tools

MariaDB - 10.3

 

sudo apt-get update
sudo apt-get -y install mariadb-server-10.3

MariaDB - 10.4

1) Add MariaDB 10.4 Repository

1) Add MariaDB 10.4 Repository

$ sudo apt install software-properties-common
$ sudo apt-key adv --fetch-keys 'https://mariadb.org/mariadb_release_signing_key.asc'
$ sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://mirror.rackspace.com/mariadb/repo/10.4/ubuntu focal main'

2) Run System Update and Let’s Install MariaDB 10.4

$ sudo apt update
$ sudo apt install mariadb-server

3) Start MariaDB Service and Enable it Automatically From Boot

$ systemctl enable mariadb.service
$ systemctl start mariadb

4) Set Root Password and Securing MariaDB Installation

Since we have not set root password during installation above, we can set a new root password during securing MariaDB installation. Simply run the following command

$ 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
haven't set the root password yet, you should just press enter here.
 
Enter current password for root (enter for none):

Simply Press ENTER to using temporary MariaDB root password. After that, you can change a root password during this process.

Check your MariaDB version

$ mysql -V
mysql Ver 15.1 Distrib 10.4.22-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

 

mysql_secure_installation error occurred

ERROR 1146 (42S02) at line 1: Table 'mysql.global_priv' doesn't exist

 ... Failed!

Cleaning up...

 

10.3설치후 10.4로 업그레이드할 경우 /var/lib/mysql 데이터 업그레이드
aru@ubuntu:~$ sudo mysql_upgrade -u root -p
Enter password:
Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
mysql.column_stats                                 OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.gtid_slave_pos                               OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.index_stats                                  OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.roles_mapping                                OK
mysql.servers                                      OK
mysql.table_stats                                  OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.transaction_registry                         OK
mysql.user                                         OK
Phase 2/7: Installing used storage engines... Skipped
Phase 3/7: Fixing views
Phase 4/7: Running 'mysql_fix_privilege_tables'
Phase 5/7: Fixing table and database names
Phase 6/7: Checking and upgrading tables
Processing databases
ConnecTome
information_schema
performance_schema
Phase 7/7: Running 'FLUSH PRIVILEGES'
OK

JDK 11

 

sudo apt-get update
sudo apt-get install openjdk-11-jdk

Install erlang

 

echo "deb https://packages.erlang-solutions.com/ubuntu focal contrib" | sudo tee /etc/apt/sources.list.d/rabbitmq.list
sudo apt update
sudo apt install erlang

Install RabbitMQ

 

wget https://github.com/rabbitmq/rabbitmq-server/releases/download/v3.7.28/rabbitmq-server_3.8.25-1_all.deb
sudo dpkg -i rabbitmq-server_3.8.25-1_all.deb
sudo rabbitmqctl version
3.8.25
댓글