Question

Do I need my key to login to mariadb?

Posted May 3, 2017 2.4k views
CentOS MySQL MariaDB

I am trying to make an application that connects remotely to my mariadb server. I cannot connect via mysql-workbench or my app that I am making. I tried this tutorial and it did not work for me.

https://mariadb.com/kb/en/mariadb/configuring-mariadb-for-remote-client-access/

Add a comment
sfxworks
By:
sfxworks
Add a comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

2 answers
hansen May 3, 2017

Hi @sfxworks

You need to open your firewall, since that’s activated by default on CentOS:
https://www.digitalocean.com/community/tutorials/how-to-set-up-a-firewall-using-firewalld-on-centos-7

If you already did that, then make sure you restarted MariaDB and then have a look at which services are listening on the interfaces:

sudo lsof -iTCP -sTCP:LISTEN -P
How To Set Up a Firewall Using FirewallD on CentOS 7
by Justin Ellingwood
Firewalld is a complete firewall solution available by default on CentOS and Fedora servers. In this guide, we will cover how to set up a basic firewall for your server and show you the basics of managing the firewall with firewall-cmd, its command-line administrative...
Reply Report
  • sfxworks May 3, 2017 
    
Complete!
[root@centos-512mb-nyc3-01 etc]# cd
[root@centos-512mb-nyc3-01 ~]# sudo lsof -iTCP -sTCP:LISTEN -P
COMMAND   PID   USER   FD   TYPE   DEVICE SIZE/OFF NODE NAME
sshd      760   root    3u  IPv4    13477      0t0  TCP *:22 (LISTEN)
sshd      760   root    4u  IPv6    13486      0t0  TCP *:22 (LISTEN)
master   1957   root   13u  IPv4    15076      0t0  TCP centos-512mb-nyc3-01:25 (LISTEN)
master   1957   root   14u  IPv6    15077      0t0  TCP centos-512mb-nyc3-01:25 (LISTEN)
python  23223   root    3u  IPv6 47958110      0t0  TCP *:843 (LISTEN)
httpd   28106 apache    4u  IPv6 33492356      0t0  TCP *:80 (LISTEN)
httpd   28107 apache    4u  IPv6 33492356      0t0  TCP *:80 (LISTEN)
httpd   28108 apache    4u  IPv6 33492356      0t0  TCP *:80 (LISTEN)
httpd   28109 apache    4u  IPv6 33492356      0t0  TCP *:80 (LISTEN)
httpd   28110 apache    4u  IPv6 33492356      0t0  TCP *:80 (LISTEN)
httpd   30704   root    4u  IPv6 33492356      0t0  TCP *:80 (LISTEN)
httpd   30898 apache    4u  IPv6 33492356      0t0  TCP *:80 (LISTEN)
httpd   32668 apache    4u  IPv6 33492356      0t0  TCP *:80 (LISTEN)
[root@centos-512mb-nyc3-01 ~]# firewall-cmd --state
not running
[root@centos-512mb-nyc3-01 ~]# clear
[root@centos-512mb-nyc3-01 ~]# firewall-cmd --state
not running
[root@centos-512mb-nyc3-01 ~]# sudo lsof -iTCP -sTCP:LISTEN -P
COMMAND   PID   USER   FD   TYPE   DEVICE SIZE/OFF NODE NAME
sshd      760   root    3u  IPv4    13477      0t0  TCP *:22 (LISTEN)
sshd      760   root    4u  IPv6    13486      0t0  TCP *:22 (LISTEN)
master   1957   root   13u  IPv4    15076      0t0  TCP centos-512mb-nyc3-01:25 (LISTEN)
master   1957   root   14u  IPv6    15077      0t0  TCP centos-512mb-nyc3-01:25 (LISTEN)
python  23223   root    3u  IPv6 47958110      0t0  TCP *:843 (LISTEN)
httpd   28106 apache    4u  IPv6 33492356      0t0  TCP *:80 (LISTEN)
httpd   28107 apache    4u  IPv6 33492356      0t0  TCP *:80 (LISTEN)
httpd   28108 apache    4u  IPv6 33492356      0t0  TCP *:80 (LISTEN)
httpd   28109 apache    4u  IPv6 33492356      0t0  TCP *:80 (LISTEN)
httpd   28110 apache    4u  IPv6 33492356      0t0  TCP *:80 (LISTEN)
httpd   30704   root    4u  IPv6 33492356      0t0  TCP *:80 (LISTEN)
httpd   30898 apache    4u  IPv6 33492356      0t0  TCP *:80 (LISTEN)
httpd   32668 apache    4u  IPv6 33492356      0t0  TCP *:80 (LISTEN)
[root@centos-512mb-nyc3-01 ~]#

    It says that my firewall isn’t running my default (centos 7 x64) but mariadb isn’t listening on a port. How do I get it to listen?

    Reply Report
    • hansen May 15, 2017

      @sfxworks
      Correct, MariaDB isn’t listening. My guess would be that MariaDB is crashing because it’s running out of RAM. You can check by showing the last 30 lines of it’s error log:

      sudo tail -30 /var/log/mysql/error.log

      Or check if it’s even running:

      sudo systemctl status mysqld
      Reply Report
  • sfxworks May 3, 2017
    [deleted]
    Reply Report
  • sfxworks May 3, 2017

    It says that my firewall isn’t running by default (centos 7 x64) but mariadb isn’t listening on a port. How do I get it to listen?

    Reply Report
sfxworks May 3, 2017
[deleted]
Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help