삶은 개발

한국어 카테고리

Installing MariaDB on AWS EC2 Ubuntu

I ultimately failed on AWS Linux 2023.

  • Kubelet standalone failed.

I decided to install MariaDB, and only install WordPress execution as a pod.

  curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash
	sudo apt update
	sudo apt install libmariadb-dev -y
	sudo apt install gcc -y
	sudo apt install mariadb-server -y
	sudo apt install mariadb-client -y
	sudo apt install python3-dev
	sudo mysql_secure_installation
	
	sudo systemctl enable mariadb
SELECT host, user, password FROM mysql.user;

show grants for '아이디'@'%';

Everything is good, but to make it publicly accessible, the configuration in the Ubuntu version of MariaDB needs to be changed.

Filename: /etc/mysql/mariadb.conf.d/50-server.cnf

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
# bind-address            = 127.0.0.1

It seems to check the URL due to the bind-address. It says you can comment out this part. Note it down, otherwise, it’s just a waste of time.

Fin