[Maria DB] Create new user in MariaDB to remote connect.
Create new user of MariaDB to remote connect.
==
//create user
sudo -u root -p
create database testdb;
grant all on testdb.* to ‘testuser’@’%’ identified by ‘password’;
show grants for ‘testuser’;
// network port check for maria DB. by default 3306
sudo ss -ltn
sudo ss -lt
//Allow connection for maria db
sudo firewall-cmd –list-all
sudo firewall-cmd –permanent –add-port=3306/tcp
sudo firewall-cmd –reload
sudo firewall-cmd –list-all
==
Comments are closed.