Mengupdate package
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:~#
Menginstall mariadb-server
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:~#
Menyalakan service mariadb
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:~#
Mengamankan instalasi mariadb
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:~#