Sunday, December 19, 2021

How To Set Up Mariadb For Remote Access on Ubuntu 18.04 LTS

 By default, remote access to the mariadb database server is disabled for security reasons. However, sometimes you need to provide remote access to database server from home or a web server.
MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL
__________________________________________________________________________________________________________________________
Our Server Specification:-
Os : Ubuntu 18.04.1 LTS Bionic Beaver 64Bit     || Hostname: www.yourdomain.com         || IP Address of Server:
__________________________________________________________________________________________________________________________
lsb_release -cd  ; getconf LONG_BIT ; hostname ; hostname -I
apt-get update ; apt-get upgrade -y
apt install net-tools build-essential software-properties-common curl wget git mariadb-server mariadb-client -y
mysql_secure_installation                                                              
systemctl restart mariadb ; systemctl enable mariadb
gedit /etc/mysql/mariadb.conf.d/50-server.cnf &>/dev/null

mysql -u root -p
create database dbname;
grant all privileges on dbname.* to 'dbuser'@'%' identified by'dbpassword' with grant option;
flush privileges;
exit
systemctl restart mariadb ; systemctl status mariadb
__________________________________________________________________________________________________________________________
192.168.153.234

Client Side:
lsb_release -cd  ; getconf LONG_BIT ; hostname ; hostname -I
apt-get update ; apt-get upgrade -y
apt install net-tools build-essential software-properties-common curl wget git mariadb-server mariadb-client -y
mysql_secure_installation
systemctl restart mariadb ; systemctl enable mariadb
mysql -h 192.168.153.234 -u dbuser -p

No comments:

Post a Comment