How to Install Mariadb Server in Ubuntu 24.04 LTS
Mariadb is a drop-in replacement for MySQL, as they say. This video shows you how to install Mariadb server on a VPS running Ubuntu 24.04 LTS.
00:00 Intro
00:30 System update & upgrade
00:55 Installing mariadb-server
01:25 Starting and enabling mariadb with systemd
01:53 Strengthening security
04:25 Logging in as root user - mysql command
04:33 Listing databases - SHOW DATABASES
05:03 Listing mariadb users - SELECT command
05:34 Switching root user to unix_socket auth - ALTER USER command
06:10 Creating new database - CREATE DATABASE command
06:29 Creating new User with password auth - CREATE USER command
07:16 Granting Privileges to the new user - GRANT command
07:59 Exiting root user and logging in as new user
08:16 Exploring the difference between unix_socket auth and password auth
11:24 Using DBeaver to connect to the database from desktop
11:54 Setting up an SSH tunnel from desktop DBeaver
12:42 SSH tunnel is working
13:21 Successfully connected to the database from DBeaver
14:04 Creating a new table from DBeaver
14:55 Table showing up on remote console
14:58 About remote connections to mariadb
15:13 Using netstat to view active internet connections
16:12 Trying to connect directly from DBeaver (without SSH tunnel)
16:42 Direct remote connection refused - OK
16:51 Checking the bind-address IP address in /etc/mysql/
Website: https://www.coralnodes.com
---------------------------------------
Server provider:
DigitalOcean: https://www.coralnodes.com/go/digital...
-------------------------------------------------------------
Disclaimer:
This video is based on my personal experiences and knowledge. There is no guarantee that the information shared is 100% accurate.
Disclosure:
This video and its description may contain affiliate links, which can earn us commission if someone purchases products using those links.
Смотрите видео How to Install Mariadb Server in Ubuntu 24.04 LTS онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь CoralNodes 18 Май 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 970 раз и оно понравилось 8 людям.