sudo apt update
sudo apt install mariadb-server mariadb-client -y
sudo systemctl start mariadb sudo systemctl enable mariadb sudo systemctl status mariadb
sudo mysql_secure_installation
in case of error mysql_secure_installation:
-- Set root password ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_secure_password'; -- Remove anonymous users DELETE FROM mysql.user WHERE User=''; -- Disallow remote root login DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost'); -- Remove test database DROP DATABASE IF EXISTS test; -- Reload privilege tables FLUSH PRIVILEGES; EXIT;
In /etc/mysql/mariadb.conf.d/50-server.cnf (Ubuntu/Debian) or /etc/my.cnf (CentOS):
[mysqld] bind-address = 0.0.0.0
sudo mysql -u root -p
CREATE DATABASE database_name;
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'host';
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'username'@'host';