MariaDB 10.0.33 Configuring MariaDB for Remote Client Access

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP








up vote
0
down vote

favorite












I just keep verbatim the instructions in MariaDB docs but it does not work at all, and I wast a great ammount of time.



MariaDB docs does not take into account this version in its documentation.



Following the instructions i modified the file my.cnf that in my case it was /etc/mysql/my.cnf



I comment this out as the example, but in my case I had to add it manually.



 [mysqld]
...
#skip-networking
...
#bind-address = <some ip-address>
...


And as I already have an account with remote permissions, I just restarted the mysql service but nothing happened.



Check if por is open



sudo nmap -PN -p 3306 -sV server_ip


The port wasn't listening from remote ips.










share|improve this question

























    up vote
    0
    down vote

    favorite












    I just keep verbatim the instructions in MariaDB docs but it does not work at all, and I wast a great ammount of time.



    MariaDB docs does not take into account this version in its documentation.



    Following the instructions i modified the file my.cnf that in my case it was /etc/mysql/my.cnf



    I comment this out as the example, but in my case I had to add it manually.



     [mysqld]
    ...
    #skip-networking
    ...
    #bind-address = <some ip-address>
    ...


    And as I already have an account with remote permissions, I just restarted the mysql service but nothing happened.



    Check if por is open



    sudo nmap -PN -p 3306 -sV server_ip


    The port wasn't listening from remote ips.










    share|improve this question























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      I just keep verbatim the instructions in MariaDB docs but it does not work at all, and I wast a great ammount of time.



      MariaDB docs does not take into account this version in its documentation.



      Following the instructions i modified the file my.cnf that in my case it was /etc/mysql/my.cnf



      I comment this out as the example, but in my case I had to add it manually.



       [mysqld]
      ...
      #skip-networking
      ...
      #bind-address = <some ip-address>
      ...


      And as I already have an account with remote permissions, I just restarted the mysql service but nothing happened.



      Check if por is open



      sudo nmap -PN -p 3306 -sV server_ip


      The port wasn't listening from remote ips.










      share|improve this question













      I just keep verbatim the instructions in MariaDB docs but it does not work at all, and I wast a great ammount of time.



      MariaDB docs does not take into account this version in its documentation.



      Following the instructions i modified the file my.cnf that in my case it was /etc/mysql/my.cnf



      I comment this out as the example, but in my case I had to add it manually.



       [mysqld]
      ...
      #skip-networking
      ...
      #bind-address = <some ip-address>
      ...


      And as I already have an account with remote permissions, I just restarted the mysql service but nothing happened.



      Check if por is open



      sudo nmap -PN -p 3306 -sV server_ip


      The port wasn't listening from remote ips.







      16.04 remote-access mariadb






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Feb 23 at 22:36









      Joe

      71431124




      71431124




















          1 Answer
          1






          active

          oldest

          votes

















          up vote
          0
          down vote



          accepted










          English
          The answer was already in the file my.cnf where it explains the configuration order so that the last file is the one that applies.
          The problem I got is that the MariaDB docs recommends to comment out the lines skip-networking and bind-address.
          In my case, to comment out lines does nothing, it doesn't override the previous configuration, because it only applies if it defines something new, so I had to go to the source where it was defined that keywords to comment that out in the first place.



          I had to comment out this file /etc/mysql/mariadb.conf.d/50-server.cnf where it was firstly defined skip-networking and bind-address.



          /etc/mysql/my.cnf



          # The MariaDB configuration file
          #
          # The MariaDB/MySQL tools read configuration files in the following order:
          # 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
          # 2. "/etc/mysql/conf.d/*.cnf" to set global options.
          # 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
          # 4. "~/.my.cnf" to set user-specific options.
          #
          # If the same option is defined multiple times, the last one will apply.
          ...


          I hope this could save time to someone else.






          share|improve this answer






















            Your Answer







            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "89"
            ;
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function()
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled)
            StackExchange.using("snippets", function()
            createEditor();
            );

            else
            createEditor();

            );

            function createEditor()
            StackExchange.prepareEditor(
            heartbeatType: 'answer',
            convertImagesToLinks: true,
            noModals: false,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            );



            );













             

            draft saved


            draft discarded


















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1009175%2fmariadb-10-0-33-configuring-mariadb-for-remote-client-access%23new-answer', 'question_page');

            );

            Post as a guest






























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes








            up vote
            0
            down vote



            accepted










            English
            The answer was already in the file my.cnf where it explains the configuration order so that the last file is the one that applies.
            The problem I got is that the MariaDB docs recommends to comment out the lines skip-networking and bind-address.
            In my case, to comment out lines does nothing, it doesn't override the previous configuration, because it only applies if it defines something new, so I had to go to the source where it was defined that keywords to comment that out in the first place.



            I had to comment out this file /etc/mysql/mariadb.conf.d/50-server.cnf where it was firstly defined skip-networking and bind-address.



            /etc/mysql/my.cnf



            # The MariaDB configuration file
            #
            # The MariaDB/MySQL tools read configuration files in the following order:
            # 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
            # 2. "/etc/mysql/conf.d/*.cnf" to set global options.
            # 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
            # 4. "~/.my.cnf" to set user-specific options.
            #
            # If the same option is defined multiple times, the last one will apply.
            ...


            I hope this could save time to someone else.






            share|improve this answer


























              up vote
              0
              down vote



              accepted










              English
              The answer was already in the file my.cnf where it explains the configuration order so that the last file is the one that applies.
              The problem I got is that the MariaDB docs recommends to comment out the lines skip-networking and bind-address.
              In my case, to comment out lines does nothing, it doesn't override the previous configuration, because it only applies if it defines something new, so I had to go to the source where it was defined that keywords to comment that out in the first place.



              I had to comment out this file /etc/mysql/mariadb.conf.d/50-server.cnf where it was firstly defined skip-networking and bind-address.



              /etc/mysql/my.cnf



              # The MariaDB configuration file
              #
              # The MariaDB/MySQL tools read configuration files in the following order:
              # 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
              # 2. "/etc/mysql/conf.d/*.cnf" to set global options.
              # 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
              # 4. "~/.my.cnf" to set user-specific options.
              #
              # If the same option is defined multiple times, the last one will apply.
              ...


              I hope this could save time to someone else.






              share|improve this answer
























                up vote
                0
                down vote



                accepted







                up vote
                0
                down vote



                accepted






                English
                The answer was already in the file my.cnf where it explains the configuration order so that the last file is the one that applies.
                The problem I got is that the MariaDB docs recommends to comment out the lines skip-networking and bind-address.
                In my case, to comment out lines does nothing, it doesn't override the previous configuration, because it only applies if it defines something new, so I had to go to the source where it was defined that keywords to comment that out in the first place.



                I had to comment out this file /etc/mysql/mariadb.conf.d/50-server.cnf where it was firstly defined skip-networking and bind-address.



                /etc/mysql/my.cnf



                # The MariaDB configuration file
                #
                # The MariaDB/MySQL tools read configuration files in the following order:
                # 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
                # 2. "/etc/mysql/conf.d/*.cnf" to set global options.
                # 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
                # 4. "~/.my.cnf" to set user-specific options.
                #
                # If the same option is defined multiple times, the last one will apply.
                ...


                I hope this could save time to someone else.






                share|improve this answer














                English
                The answer was already in the file my.cnf where it explains the configuration order so that the last file is the one that applies.
                The problem I got is that the MariaDB docs recommends to comment out the lines skip-networking and bind-address.
                In my case, to comment out lines does nothing, it doesn't override the previous configuration, because it only applies if it defines something new, so I had to go to the source where it was defined that keywords to comment that out in the first place.



                I had to comment out this file /etc/mysql/mariadb.conf.d/50-server.cnf where it was firstly defined skip-networking and bind-address.



                /etc/mysql/my.cnf



                # The MariaDB configuration file
                #
                # The MariaDB/MySQL tools read configuration files in the following order:
                # 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
                # 2. "/etc/mysql/conf.d/*.cnf" to set global options.
                # 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
                # 4. "~/.my.cnf" to set user-specific options.
                #
                # If the same option is defined multiple times, the last one will apply.
                ...


                I hope this could save time to someone else.







                share|improve this answer














                share|improve this answer



                share|improve this answer








                edited Feb 24 at 9:10

























                answered Feb 24 at 9:04









                Joe

                71431124




                71431124



























                     

                    draft saved


                    draft discarded















































                     


                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1009175%2fmariadb-10-0-33-configuring-mariadb-for-remote-client-access%23new-answer', 'question_page');

                    );

                    Post as a guest













































































                    Popular posts from this blog

                    pylint3 and pip3 broken

                    Missing snmpget and snmpwalk

                    How to enroll fingerprints to Ubuntu 17.10 with VFS491