Cara menginstall mariadb di Ubuntu 22.04

Mengupdate package

sudo apt update

Shell
​x
 
sudo apt update

Contoh hasil output

root@cloud-dev:~# apt update
Hit:1 http://id.archive.ubuntu.com/ubuntu focal InRelease
Get:2 http://id.archive.ubuntu.com/ubuntu focal-updates InRelease [128 kB]
Hit:3 http://id.archive.ubuntu.com/ubuntu focal-backports InRelease
Hit:4 http://id.archive.ubuntu.com/ubuntu focal-security InRelease
Fetched 128 kB in 1s (157 kB/s)
Reading package lists... Done
Building dependency tree
Reading state information... Done
104 packages can be upgraded. Run 'apt list --upgradable' to see them.
root@cloud-dev:~#

Shell
 
root@cloud-dev:~# apt update
Hit:1 http://id.archive.ubuntu.com/ubuntu focal InRelease
Get:2 http://id.archive.ubuntu.com/ubuntu focal-updates InRelease [128 kB]
Hit:3 http://id.archive.ubuntu.com/ubuntu focal-backports InRelease
Hit:4 http://id.archive.ubuntu.com/ubuntu focal-security InRelease
Fetched 128 kB in 1s (157 kB/s)
Reading package lists... Done
Building dependency tree
Reading state information... Done
104 packages can be upgraded. Run 'apt list --upgradable' to see them.
root@cloud-dev:~#

Menginstall mariadb-server

sudo apt install mariadb-server

Shell
 
sudo apt install mariadb-server
​

Contoh hasil output

root@cloud-dev:~# apt install mariadb-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
  galera-3 libcgi-fast-perl libcgi-pm-perl libconfig-inifiles-perl libdbd-mysql-perl libdbi-perl libencode-locale-perl libfcgi-perl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl
  libhttp-date-perl libhttp-message-perl libio-html-perl liblwp-mediatypes-perl libmysqlclient21 libsnappy1v5 libterm-readkey-perl libtimedate-perl liburi-perl mariadb-client-10.3 mariadb-client-core-10.3
  mariadb-common mariadb-server-10.3 mariadb-server-core-10.3 mysql-common socat
Suggested packages:
  libclone-perl libmldbm-perl libnet-daemon-perl libsql-statement-perl libdata-dump-perl libipc-sharedcache-perl libwww-perl mailx mariadb-test tinyca
The following NEW packages will be installed:
  galera-3 libcgi-fast-perl libcgi-pm-perl libconfig-inifiles-perl libdbd-mysql-perl libdbi-perl libencode-locale-perl libfcgi-perl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl
  libhttp-date-perl libhttp-message-perl libio-html-perl liblwp-mediatypes-perl libmysqlclient21 libsnappy1v5 libterm-readkey-perl libtimedate-perl liburi-perl mariadb-client-10.3 mariadb-client-core-10.3
  mariadb-common mariadb-server mariadb-server-10.3 mariadb-server-core-10.3 mysql-common socat
0 upgraded, 28 newly installed, 0 to remove and 104 not upgraded.
Need to get 21.5 MB of archives.
After this operation, 175 MB of additional disk space will be used.
Do you want to continue? [Y/n] Y
Get:1 http://id.archive.ubuntu.com/ubuntu focal/main amd64 mysql-common all 5.8+1.0.5ubuntu2 [7,496 B]
....
....
Processing triggers for man-db (2.9.1-1) ...
Processing triggers for libc-bin (2.31-0ubuntu9.16) ...
root@cloud-dev:~#

Shell
 
root@cloud-dev:~# apt install mariadb-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
  galera-3 libcgi-fast-perl libcgi-pm-perl libconfig-inifiles-perl libdbd-mysql-perl libdbi-perl libencode-locale-perl libfcgi-perl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl
  libhttp-date-perl libhttp-message-perl libio-html-perl liblwp-mediatypes-perl libmysqlclient21 libsnappy1v5 libterm-readkey-perl libtimedate-perl liburi-perl mariadb-client-10.3 mariadb-client-core-10.3
  mariadb-common mariadb-server-10.3 mariadb-server-core-10.3 mysql-common socat
Suggested packages:
  libclone-perl libmldbm-perl libnet-daemon-perl libsql-statement-perl libdata-dump-perl libipc-sharedcache-perl libwww-perl mailx mariadb-test tinyca
The following NEW packages will be installed:
  galera-3 libcgi-fast-perl libcgi-pm-perl libconfig-inifiles-perl libdbd-mysql-perl libdbi-perl libencode-locale-perl libfcgi-perl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl
  libhttp-date-perl libhttp-message-perl libio-html-perl liblwp-mediatypes-perl libmysqlclient21 libsnappy1v5 libterm-readkey-perl libtimedate-perl liburi-perl mariadb-client-10.3 mariadb-client-core-10.3
  mariadb-common mariadb-server mariadb-server-10.3 mariadb-server-core-10.3 mysql-common socat
0 upgraded, 28 newly installed, 0 to remove and 104 not upgraded.
Need to get 21.5 MB of archives.
After this operation, 175 MB of additional disk space will be used.
Do you want to continue? [Y/n] Y
Get:1 http://id.archive.ubuntu.com/ubuntu focal/main amd64 mysql-common all 5.8+1.0.5ubuntu2 [7,496 B]
....
....
Processing triggers for man-db (2.9.1-1) ...
Processing triggers for libc-bin (2.31-0ubuntu9.16) ...
root@cloud-dev:~#

Menyalakan service mariadb

sudo systemctl start mariadb
sudo systemctl status mariadb

Shell
 
sudo systemctl start mariadb
sudo systemctl status mariadb

Contoh hasil output

root@cloud-dev:~# systemctl start mariadb
root@cloud-dev:~# systemctl status mariadb
● mariadb.service - MariaDB 10.3.39 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
     Active: active (running) since Wed 2024-07-17 13:46:55 UTC; 2s ago
       Docs: man:mysqld(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 1941123 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
    Process: 1941124 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 1941137 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VA>
    Process: 1941216 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 1941218 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
   Main PID: 1941184 (mysqld)
     Status: "Taking your SQL requests now..."
      Tasks: 31 (limit: 9425)
     Memory: 65.3M
     CGroup: /system.slice/mariadb.service
             └─1941184 /usr/sbin/mysqld

Jul 17 13:46:55 cloud-dev systemd[1]: Starting MariaDB 10.3.39 database server...
Jul 17 13:46:55 cloud-dev systemd[1]: Started MariaDB 10.3.39 database server.
Jul 17 13:46:55 cloud-dev /etc/mysql/debian-start[1941223]: Looking for 'mysql' as: /usr/bin/mysql
Jul 17 13:46:55 cloud-dev /etc/mysql/debian-start[1941223]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Jul 17 13:46:55 cloud-dev /etc/mysql/debian-start[1941223]: This installation of MariaDB is already upgraded to 10.3.39-MariaDB.
Jul 17 13:46:55 cloud-dev /etc/mysql/debian-start[1941223]: There is no need to run mysql_upgrade again for 10.3.39-MariaDB.
Jul 17 13:46:55 cloud-dev /etc/mysql/debian-start[1941223]: You can use --force if you still want to run mysql_upgrade

root@cloud-dev:~#

Shell
 
root@cloud-dev:~# systemctl start mariadb
root@cloud-dev:~# systemctl status mariadb
● mariadb.service - MariaDB 10.3.39 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
     Active: active (running) since Wed 2024-07-17 13:46:55 UTC; 2s ago
       Docs: man:mysqld(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 1941123 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
    Process: 1941124 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 1941137 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VA>
    Process: 1941216 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 1941218 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
   Main PID: 1941184 (mysqld)
     Status: "Taking your SQL requests now..."
      Tasks: 31 (limit: 9425)
     Memory: 65.3M
     CGroup: /system.slice/mariadb.service
             └─1941184 /usr/sbin/mysqld
​
Jul 17 13:46:55 cloud-dev systemd[1]: Starting MariaDB 10.3.39 database server...
Jul 17 13:46:55 cloud-dev systemd[1]: Started MariaDB 10.3.39 database server.
Jul 17 13:46:55 cloud-dev /etc/mysql/debian-start[1941223]: Looking for 'mysql' as: /usr/bin/mysql
Jul 17 13:46:55 cloud-dev /etc/mysql/debian-start[1941223]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Jul 17 13:46:55 cloud-dev /etc/mysql/debian-start[1941223]: This installation of MariaDB is already upgraded to 10.3.39-MariaDB.
Jul 17 13:46:55 cloud-dev /etc/mysql/debian-start[1941223]: There is no need to run mysql_upgrade again for 10.3.39-MariaDB.
Jul 17 13:46:55 cloud-dev /etc/mysql/debian-start[1941223]: You can use --force if you still want to run mysql_upgrade
​
root@cloud-dev:~#
​

Mengamankan instalasi mariadb

sudo mysql_secure_installation

Shell
 
sudo mysql_secure_installation

Contoh hasil output

root@cloud-dev:~# 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.

Set root password? [Y/n]
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] Y
 ... Success!

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!
root@cloud-dev:~#

Shell
 
root@cloud-dev:~# 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.
​
Set root password? [Y/n]
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] Y
 ... Success!
​
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!
root@cloud-dev:~#
​

Cara menginstall mariadb di Ubuntu 22.04

Byadmin web

By admin web

Related Post

Cara menginstall mariadb server di Centos 7

Cara membackup dan merestore database mariadb dengan mysqldump dan xz

Leave a Reply Cancel reply

You missed

Cara setting NTP di server aix

Cara menginstall gitlab dengan registry menggunakan docker

Script update ubuntu 18.04 ke 22.04

Cara mereset password admin Nginx Proxy Manager Mariadb

Catatan Mas Wachid