•  Home
  •  Dashboard
  •  Company
    • About Us
    • Blog
    • Careers
    • Contact Us
    • Data Centers
    • Looking Glass
    • Network
    • Reseller
  •  Hosting Services
    • Backup
    • Content Delivery Network
    • Colocation Hosting
    • Dedicated Hosting
    • DDoS Mitigation
    • IP Transit
    • Private Cloud
    • Wavelength
  •  Solutions
    • Ecommerce
    • Finance
    • Gaming
    • Hosting
    • Management
    • Security
    • System Integrator
  •  Support
    • Community
    • Knowledge Base
    • Open A Ticket
  •  USA & Canada: 800-933-1517
  •  International: 626-549-2801
  •  Email: sales@psychz.net
  • Services
    • Dedicated Servers
    • Colocation
    • Private Cloud
    • DDos Protection
    • IP Transit
    • CDN
    • Backup
  • Solutions
    • Ecommerce
    • Security
    • Gaming
    • Hosting
    • Management
    • Finance
    • System Integrator
  • Dashboard

Accessing mariadb remotely without installing mariadb

  • Home
  • Client
  • Qa Forum
  • Accessing mariadb remotely without installing mariadb

Posted By: Oliver | 1 Replies | Last Reply On: May 08, 2019 06:11:09

How can i access mariadb remotely without installing mariadb on my computer? 

Psychz - Raviteja

Votes: 0Posted On: May 08, 2019 06:11:09
 

You can access MariaDB remotely if your server is connect to the internet but it is highly risky and you must assess all the measure to make it secure and use it wisely before you allow remote access to your database. Opening up your database servers directly to the internet is not recommended.

You may want to read steps to secure MariaDB before you proceed with steps to accessing it remotely here on our knowledgebase article https://www.psychz.net/client/kb/en/installing-mariadb-on-centos-7.html

By default, MySQL or MariaDB only listens for connections from the localhost. All remote access to the server is denied by default.

To enable remote access, run the commands below to open MySQL/MariaDB configuration file.

# nano /etc/mysql/mariadb.conf.d/50-server.cnf

Then make the below change below from:

bind-address                              = 127.0.0.1

To

bind-address                               = 0.0.0.0

After making the changes above, save the file and run the commands below to restart the server.

# systemctl restart mariadb.service

To verify that the changes done are reflecting, run the following command

# netstat -anp | grep 3306

The result should look like the one given below

tcp       0      0 0.0.0.0:3306          0.0.0.0:*        LISTEN         3213/mysqld

 

That’s it! You’ve successfully configured remote access to the MariaDB database server.

Note: Make sure to modify your Linux firewall to allow outside IP addresses to connect to port 3306

Was this reply helpful?

Related topics

  • Installing MariaDB on Centos 7
  • Installation of Lamp Stack on CentOS 7
  • Top SQL Databases
  • MariaDB Cloud hosting
  • How to setup a dedicated server for Counter-Strike: Global offensive
  • SSH without Password
  • Need Dedicated Server In Europe
  • How to install SSL certificate in WHM?
  • DDoS Protected Hosting
  • How to install Node.js on AlmaLinux 8
  • How to setup a dedicated server for Minecraft
  • Top Open Source Cloud Storage Software
  • Why Gaming Companies are Choosing Bare Metal Servers
  • Top Encryption Software For Linux
  • SaaS, PaaS and IaaS: An Overview
Hosting Services
  • Dedicated Hosting
  • Colocation Hosting
  • Backup
  • IP Transit
  • DDoS Mitigation
Support
  • Portal Login
  • Knowledgebase
  • Community
Company
  • About Us
  • Contact Us
  • Network
  • Data Centers
  • Looking Glass
  • Affiliates
  • Reseller
  • Blog
Policies
  • Privacy Policy
  • Acceptable Usage Policy
  • Terms and Conditions
  • Service Level Agreement
Company
  • Psychz Networks,
    A Profuse Solutions Company
    611 Wilshire Blvd #300
    Los Angeles,California 90017
    USA
  • US/Canada: 800-933-1517
  • International: 626-549-2801
Subscribe to Our Mailing List
* indicates required
Copyright © 2023 Psychz Networks, A Profuse Solutions Inc Company