[Maria DB] Create new user in MariaDB to remote connect.



[Maria DB] Create new user in MariaDB to remote connect.

[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.