AWS_mariadb_setting_on_the_EC2

2025-04-08

sudo apt-get update
sudo apt install mariadb-client-core
mysql -u <user> -h <Hostname> -P <Port> -p <db>

‼ Using the ‘%’ character in your password will result in an error.

ERROR 1045 (28000): Access denied for user 'user'@'ip' (using password: YES)

mysql create new user

CREATE database DB;
CREATE USER 'user'@'%' identified by 'pw';
GRANT ALL privileges on DB.* TO 'user'@'%';
FLUSH PRIVILEGES;

remote access

Publicly accessible Yes

Linux, config