{"id":1986,"date":"2020-07-05T22:00:41","date_gmt":"2020-07-05T22:00:41","guid":{"rendered":"http:\/\/www.theSQLReport.com\/?p=1986"},"modified":"2022-07-04T12:14:53","modified_gmt":"2022-07-04T12:14:53","slug":"bitnami-mariadb-virtual-machine-how-to-enable-port-3306-for-mariadb","status":"publish","type":"post","link":"https:\/\/www.theSQLReport.com\/?p=1986","title":{"rendered":"Bitnami MariaDB Virtual Machine – How To Enable Port 3306 for MariaDB"},"content":{"rendered":"

Bitnami virtual machines are great for quickly enabling an environment for testing or learning.\u00a0 Sometimes they can be a challenge when I want to use other software with them.<\/p>\n

Problem:<\/strong><\/p>\n

I wanted to connect to the MariaDB database located on a Bitnami MariaDB Virtual Machine with the MySQL Workbench on my laptop’s software.<\/p>\n

\"\"<\/a><\/p>\n

Already done to the Bitnami MariaDB Virtual Machine:<\/strong><\/p>\n

1. Using the DHCP address enabled by default on virtual machine (laziness – should set static IP address), my only configuration was enabling the network connection in my VM Workstation.<\/p>\n

2.\u00a0 Enabled the virtual machine for SSH connections for Debian, so I can make putty connections.<\/p>\n

Instructions:\u00a0 Enable or disable the SSH server – Debian<\/a><\/p>\n

3. Out of laziness, I am using the default bitnami OS user account and the root user for the MariaDB, credentials found:<\/p>\n

cat \/home\/bitnami\/bitnami_credentials<\/pre>\n
Resolution:<\/strong><\/p>\n
    \n
  1. \u00a0Check netstat to see if the port is enabled for only the local server.\u00a0 If you see that port 3306 is enabled only for 127.0.0.1, then only connections on that server can be made using that port.<\/li>\n<\/ol>\n
    sudo netstat -ntlup | grep mysql<\/pre>\n
    \"\"<\/a><\/p>\n
    2. To correct the problem above, the my.cnf file will need to be edited:<\/p>\n
    sudo vi \/opt\/bitnami\/mariadb\/conf\/my.cnf<\/pre>\n
    \"\"<\/a><\/p>\n
    The only parameter that need to be changed is the bind_address.\u00a0 Change the “127.0.0.1” to ” :: “, and this will allow any IP address to access the database (don’t do this on your production MariaDB servers, or it will fail any auditor security scans).<\/p>\n
    \"\"<\/a><\/p>\n
    Then save & close the my.cnf configuration file.<\/p>\n
    3.\u00a0 Set the firewall to allow connections on port 3306.<\/p>\n
    sudo ufw allow 3306<\/pre>\n
    \"\"<\/a><\/p>\n
    4.\u00a0 Again out of laziness, I just rebooted to reset the configurations of the database & firewall.<\/p>\n
    sudo reboot<\/pre>\n
    \"\"<\/a><\/p>\n
    5.\u00a0 Great thing about this virtual machine is that it rebooted in less than minute on my old laptop.\u00a0 Then I was able to verify port 3306 was available.<\/p>\n
    sudo netstat -ntlup | grep mysql<\/pre>\n
    \"\"<\/a>Then I tested the connection in the MySQL Workbench successfully.<\/p>\n
    \"\"<\/a><\/p>\n
     <\/p>\n
     <\/p>\n","protected":false},"excerpt":{"rendered":"
    Bitnami virtual machines are great for quickly enabling an environment for testing or learning.\u00a0 Sometimes they can be a challenge when I want to use other software with them. Problem: … Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":1990,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[188,190,189,187],"class_list":["post-1986","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux","tag-bitnami","tag-my-cnf","tag-mysql-workbench","tag-port-3306"],"_links":{"self":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1986"}],"collection":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1986"}],"version-history":[{"count":8,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1986\/revisions"}],"predecessor-version":[{"id":2003,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1986\/revisions\/2003"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/media\/1990"}],"wp:attachment":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1986"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1986"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1986"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}