Why is /etc/mysql/my.cnf EMPTY?mysql version 8.0.11 and Symfony 4 error “MySQL server has gone away”Can't...

What reasons are there for a Capitalist to oppose a 100% inheritance tax?

Infinite Abelian subgroup of infinite non Abelian group example

What killed these X2 caps?

How can I make my BBEG immortal short of making them a Lich or Vampire?

Why does Arabsat 6A need a Falcon Heavy to launch

Neighboring nodes in the network

How badly should I try to prevent a user from XSSing themselves?

Why doesn't H₄O²⁺ exist?

Will google still index a page if I use a $_SESSION variable?

Emailing HOD to enhance faculty application

Can I ask the recruiters in my resume to put the reason why I am rejected?

How do I write bicross product symbols in latex?

Should I tell management that I intend to leave due to bad software development practices?

Can a virus destroy the BIOS of a modern computer?

Twin primes whose sum is a cube

Western buddy movie with a supernatural twist where a woman turns into an eagle at the end

Brothers & sisters

Is it possible to download Internet Explorer on my Mac running OS X El Capitan?

AES: Why is it a good practice to use only the first 16bytes of a hash for encryption?

Does casting Light, or a similar spell, have any effect when the caster is swallowed by a monster?

Famous Pre Reformation Christian Pastors (Non Catholic and Non Orthodox)

How to say in German "enjoying home comforts"

Is "remove commented out code" correct English?

Facing a paradox: Earnshaw's theorem in one dimension



Why is /etc/mysql/my.cnf EMPTY?


mysql version 8.0.11 and Symfony 4 error “MySQL server has gone away”Can't start MySQL server if the .sock file is changed in /etc/mysql/my.cnfMysql 5.5 reinstallation 12.04mysql server admin error from workbenchMySql not running; Ubuntu 16.04Where is the configuration data actually stored for Mysql 5.7.13 in Ubuntu 16.04 and what are best practices for managing it?Can't connect to local MySQL server through socket '/var/run/mysqld.sock' (2)Problem accessing MySQLWhy is /etc/mysql/my.cnf showing permission deniedUnable to update nor remove MySQL after updating UbuntuMySQL ignores any my.cnf configurations






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}







12















I am trying to edit the my.cnf file to allow remote access and ultimately using software from my Windows Server to configure scheduled backup for MySQL Server.



I was following these instructions.
However, the /etc/mysql/my.cnf file on my Ubuntu has only:



#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/


It doesn't contain any configuration that I can edit. Why is it like that?










share|improve this question































    12















    I am trying to edit the my.cnf file to allow remote access and ultimately using software from my Windows Server to configure scheduled backup for MySQL Server.



    I was following these instructions.
    However, the /etc/mysql/my.cnf file on my Ubuntu has only:



    #
    # The MySQL database server configuration file.
    #
    # You can copy this to one of:
    # - "/etc/mysql/my.cnf" to set global options,
    # - "~/.my.cnf" to set user-specific options.
    #
    # One can use all long options that the program supports.
    # Run program with --help to get a list of available options and with
    # --print-defaults to see which it would actually understand and use.
    #
    # For explanations see
    # http://dev.mysql.com/doc/mysql/en/server-system-variables.html

    #
    # * IMPORTANT: Additional settings that can override those from this file!
    # The files must end with '.cnf', otherwise they'll be ignored.
    #

    !includedir /etc/mysql/conf.d/
    !includedir /etc/mysql/mysql.conf.d/


    It doesn't contain any configuration that I can edit. Why is it like that?










    share|improve this question



























      12












      12








      12


      6






      I am trying to edit the my.cnf file to allow remote access and ultimately using software from my Windows Server to configure scheduled backup for MySQL Server.



      I was following these instructions.
      However, the /etc/mysql/my.cnf file on my Ubuntu has only:



      #
      # The MySQL database server configuration file.
      #
      # You can copy this to one of:
      # - "/etc/mysql/my.cnf" to set global options,
      # - "~/.my.cnf" to set user-specific options.
      #
      # One can use all long options that the program supports.
      # Run program with --help to get a list of available options and with
      # --print-defaults to see which it would actually understand and use.
      #
      # For explanations see
      # http://dev.mysql.com/doc/mysql/en/server-system-variables.html

      #
      # * IMPORTANT: Additional settings that can override those from this file!
      # The files must end with '.cnf', otherwise they'll be ignored.
      #

      !includedir /etc/mysql/conf.d/
      !includedir /etc/mysql/mysql.conf.d/


      It doesn't contain any configuration that I can edit. Why is it like that?










      share|improve this question
















      I am trying to edit the my.cnf file to allow remote access and ultimately using software from my Windows Server to configure scheduled backup for MySQL Server.



      I was following these instructions.
      However, the /etc/mysql/my.cnf file on my Ubuntu has only:



      #
      # The MySQL database server configuration file.
      #
      # You can copy this to one of:
      # - "/etc/mysql/my.cnf" to set global options,
      # - "~/.my.cnf" to set user-specific options.
      #
      # One can use all long options that the program supports.
      # Run program with --help to get a list of available options and with
      # --print-defaults to see which it would actually understand and use.
      #
      # For explanations see
      # http://dev.mysql.com/doc/mysql/en/server-system-variables.html

      #
      # * IMPORTANT: Additional settings that can override those from this file!
      # The files must end with '.cnf', otherwise they'll be ignored.
      #

      !includedir /etc/mysql/conf.d/
      !includedir /etc/mysql/mysql.conf.d/


      It doesn't contain any configuration that I can edit. Why is it like that?







      server mysql






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited May 5 '17 at 18:18









      Zanna

      51.2k13139243




      51.2k13139243










      asked Nov 19 '15 at 6:21









      MercedezMercedez

      61113




      61113






















          4 Answers
          4






          active

          oldest

          votes


















          24














          Firstly, as A.B. rightly points out, the file is not empty. It has two rather important directives, namely



          !includedir /etc/mysql/conf.d/
          !includedir /etc/mysql/mysql.conf.d/


          Those lines are saying that additional configuration files (.cnf in this case) can be found in the directories listed:



          /etc/mysql/conf.d/
          /etc/mysql/mysql.conf.d/


          The latter of the two directories should contain mysqld.cnf. In other words, the appropriate configuration file should be:



          /etc/mysql/mysql.conf.d/mysqld.cnf





          share|improve this answer



















          • 1





            somethings not right either way. when I edit the halfway-empty my.conf file and e.g. set wait_timeout = 600, the service mysql cannot be started anymore..

            – Blauhirn
            Aug 4 '16 at 12:20











          • This is exact answer for the question.

            – ambarox
            Mar 14 '17 at 7:55











          • Wish I could find it 6 hours earlier!

            – neophyte
            Aug 3 '17 at 4:38



















          3














          The file isn't empty. It contains comments, the lines wit a leading #, and import statements, the lines with a leading !. A import statement means, other configurations will be used, too.



          And editing a configuration also means, add new configuration lines.






          share|improve this answer

































            2














            My file is the same. You need to add the correct group above the command you're trying to put in otherwise the service wont start.



            To add bind-address you will need to add [mysqld] above it.



            If you need to check what the groups are for the other commands, there's an example my.cnf file here.



            If you want to enable remote connections from all interfaces (i.e 0.0.0.0), your file would look something like below, however be sure you set up your firewall correctly if you do.



            #
            # The MySQL database server configuration file.
            #
            # You can copy this to one of:
            # - "/etc/mysql/my.cnf" to set global options,
            # - "~/.my.cnf" to set user-specific options.
            #
            # One can use all long options that the program supports.
            # Run program with --help to get a list of available options and with
            # --print-defaults to see which it would actually understand and use.
            #
            # For explanations see
            # http://dev.mysql.com/doc/mysql/en/server-system-variables.html

            #
            # * IMPORTANT: Additional settings that can override those from this file!
            # The files must end with '.cnf', otherwise they'll be ignored.
            #

            !includedir /etc/mysql/conf.d/
            !includedir /etc/mysql/mysql.conf.d/

            [mysqld]
            bind-address = 0.0.0.0


            Note the [mysqld] group.






            share|improve this answer


























            • This is such pain in a**. Have been trying to make remote connections work for almost two days now. Remote connections should be enabled out of the box.

              – Mark Alexa
              Sep 7 '17 at 14:48











            • Why would you expose every database server to the internet out of the box? Aren't there enough unsecured systems out there?

              – A. Scherbaum
              Oct 10 '17 at 11:52











            • If you wish to access it from more than one, but less than all the interfaces, you should bind to 0.0.0.0 and firewall off the interfaces you don't want to be accessed through.

              – Rob
              Apr 9 '18 at 13:32



















            0














            In that case, that file is not the main where all the information about bind-adress, binlogs and etc include. But there is another file, where they include. Try this:



            nano /etc/mysql/mysql.conf.d/mysqld.cnf


            It helped me, and It should help you.






            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',
              autoActivateHeartbeat: false,
              convertImagesToLinks: true,
              noModals: true,
              showLowRepImageUploadWarning: true,
              reputationToPostImages: 10,
              bindNavPrevention: true,
              postfix: "",
              imageUploader: {
              brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
              contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
              allowUrls: true
              },
              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%2f699903%2fwhy-is-etc-mysql-my-cnf-empty%23new-answer', 'question_page');
              }
              );

              Post as a guest















              Required, but never shown

























              4 Answers
              4






              active

              oldest

              votes








              4 Answers
              4






              active

              oldest

              votes









              active

              oldest

              votes






              active

              oldest

              votes









              24














              Firstly, as A.B. rightly points out, the file is not empty. It has two rather important directives, namely



              !includedir /etc/mysql/conf.d/
              !includedir /etc/mysql/mysql.conf.d/


              Those lines are saying that additional configuration files (.cnf in this case) can be found in the directories listed:



              /etc/mysql/conf.d/
              /etc/mysql/mysql.conf.d/


              The latter of the two directories should contain mysqld.cnf. In other words, the appropriate configuration file should be:



              /etc/mysql/mysql.conf.d/mysqld.cnf





              share|improve this answer



















              • 1





                somethings not right either way. when I edit the halfway-empty my.conf file and e.g. set wait_timeout = 600, the service mysql cannot be started anymore..

                – Blauhirn
                Aug 4 '16 at 12:20











              • This is exact answer for the question.

                – ambarox
                Mar 14 '17 at 7:55











              • Wish I could find it 6 hours earlier!

                – neophyte
                Aug 3 '17 at 4:38
















              24














              Firstly, as A.B. rightly points out, the file is not empty. It has two rather important directives, namely



              !includedir /etc/mysql/conf.d/
              !includedir /etc/mysql/mysql.conf.d/


              Those lines are saying that additional configuration files (.cnf in this case) can be found in the directories listed:



              /etc/mysql/conf.d/
              /etc/mysql/mysql.conf.d/


              The latter of the two directories should contain mysqld.cnf. In other words, the appropriate configuration file should be:



              /etc/mysql/mysql.conf.d/mysqld.cnf





              share|improve this answer



















              • 1





                somethings not right either way. when I edit the halfway-empty my.conf file and e.g. set wait_timeout = 600, the service mysql cannot be started anymore..

                – Blauhirn
                Aug 4 '16 at 12:20











              • This is exact answer for the question.

                – ambarox
                Mar 14 '17 at 7:55











              • Wish I could find it 6 hours earlier!

                – neophyte
                Aug 3 '17 at 4:38














              24












              24








              24







              Firstly, as A.B. rightly points out, the file is not empty. It has two rather important directives, namely



              !includedir /etc/mysql/conf.d/
              !includedir /etc/mysql/mysql.conf.d/


              Those lines are saying that additional configuration files (.cnf in this case) can be found in the directories listed:



              /etc/mysql/conf.d/
              /etc/mysql/mysql.conf.d/


              The latter of the two directories should contain mysqld.cnf. In other words, the appropriate configuration file should be:



              /etc/mysql/mysql.conf.d/mysqld.cnf





              share|improve this answer













              Firstly, as A.B. rightly points out, the file is not empty. It has two rather important directives, namely



              !includedir /etc/mysql/conf.d/
              !includedir /etc/mysql/mysql.conf.d/


              Those lines are saying that additional configuration files (.cnf in this case) can be found in the directories listed:



              /etc/mysql/conf.d/
              /etc/mysql/mysql.conf.d/


              The latter of the two directories should contain mysqld.cnf. In other words, the appropriate configuration file should be:



              /etc/mysql/mysql.conf.d/mysqld.cnf






              share|improve this answer












              share|improve this answer



              share|improve this answer










              answered Nov 19 '15 at 6:49









              TechedemicTechedemic

              37615




              37615








              • 1





                somethings not right either way. when I edit the halfway-empty my.conf file and e.g. set wait_timeout = 600, the service mysql cannot be started anymore..

                – Blauhirn
                Aug 4 '16 at 12:20











              • This is exact answer for the question.

                – ambarox
                Mar 14 '17 at 7:55











              • Wish I could find it 6 hours earlier!

                – neophyte
                Aug 3 '17 at 4:38














              • 1





                somethings not right either way. when I edit the halfway-empty my.conf file and e.g. set wait_timeout = 600, the service mysql cannot be started anymore..

                – Blauhirn
                Aug 4 '16 at 12:20











              • This is exact answer for the question.

                – ambarox
                Mar 14 '17 at 7:55











              • Wish I could find it 6 hours earlier!

                – neophyte
                Aug 3 '17 at 4:38








              1




              1





              somethings not right either way. when I edit the halfway-empty my.conf file and e.g. set wait_timeout = 600, the service mysql cannot be started anymore..

              – Blauhirn
              Aug 4 '16 at 12:20





              somethings not right either way. when I edit the halfway-empty my.conf file and e.g. set wait_timeout = 600, the service mysql cannot be started anymore..

              – Blauhirn
              Aug 4 '16 at 12:20













              This is exact answer for the question.

              – ambarox
              Mar 14 '17 at 7:55





              This is exact answer for the question.

              – ambarox
              Mar 14 '17 at 7:55













              Wish I could find it 6 hours earlier!

              – neophyte
              Aug 3 '17 at 4:38





              Wish I could find it 6 hours earlier!

              – neophyte
              Aug 3 '17 at 4:38













              3














              The file isn't empty. It contains comments, the lines wit a leading #, and import statements, the lines with a leading !. A import statement means, other configurations will be used, too.



              And editing a configuration also means, add new configuration lines.






              share|improve this answer






























                3














                The file isn't empty. It contains comments, the lines wit a leading #, and import statements, the lines with a leading !. A import statement means, other configurations will be used, too.



                And editing a configuration also means, add new configuration lines.






                share|improve this answer




























                  3












                  3








                  3







                  The file isn't empty. It contains comments, the lines wit a leading #, and import statements, the lines with a leading !. A import statement means, other configurations will be used, too.



                  And editing a configuration also means, add new configuration lines.






                  share|improve this answer















                  The file isn't empty. It contains comments, the lines wit a leading #, and import statements, the lines with a leading !. A import statement means, other configurations will be used, too.



                  And editing a configuration also means, add new configuration lines.







                  share|improve this answer














                  share|improve this answer



                  share|improve this answer








                  edited Nov 19 '15 at 6:37

























                  answered Nov 19 '15 at 6:24









                  A.B.A.B.

                  69.7k12172266




                  69.7k12172266























                      2














                      My file is the same. You need to add the correct group above the command you're trying to put in otherwise the service wont start.



                      To add bind-address you will need to add [mysqld] above it.



                      If you need to check what the groups are for the other commands, there's an example my.cnf file here.



                      If you want to enable remote connections from all interfaces (i.e 0.0.0.0), your file would look something like below, however be sure you set up your firewall correctly if you do.



                      #
                      # The MySQL database server configuration file.
                      #
                      # You can copy this to one of:
                      # - "/etc/mysql/my.cnf" to set global options,
                      # - "~/.my.cnf" to set user-specific options.
                      #
                      # One can use all long options that the program supports.
                      # Run program with --help to get a list of available options and with
                      # --print-defaults to see which it would actually understand and use.
                      #
                      # For explanations see
                      # http://dev.mysql.com/doc/mysql/en/server-system-variables.html

                      #
                      # * IMPORTANT: Additional settings that can override those from this file!
                      # The files must end with '.cnf', otherwise they'll be ignored.
                      #

                      !includedir /etc/mysql/conf.d/
                      !includedir /etc/mysql/mysql.conf.d/

                      [mysqld]
                      bind-address = 0.0.0.0


                      Note the [mysqld] group.






                      share|improve this answer


























                      • This is such pain in a**. Have been trying to make remote connections work for almost two days now. Remote connections should be enabled out of the box.

                        – Mark Alexa
                        Sep 7 '17 at 14:48











                      • Why would you expose every database server to the internet out of the box? Aren't there enough unsecured systems out there?

                        – A. Scherbaum
                        Oct 10 '17 at 11:52











                      • If you wish to access it from more than one, but less than all the interfaces, you should bind to 0.0.0.0 and firewall off the interfaces you don't want to be accessed through.

                        – Rob
                        Apr 9 '18 at 13:32
















                      2














                      My file is the same. You need to add the correct group above the command you're trying to put in otherwise the service wont start.



                      To add bind-address you will need to add [mysqld] above it.



                      If you need to check what the groups are for the other commands, there's an example my.cnf file here.



                      If you want to enable remote connections from all interfaces (i.e 0.0.0.0), your file would look something like below, however be sure you set up your firewall correctly if you do.



                      #
                      # The MySQL database server configuration file.
                      #
                      # You can copy this to one of:
                      # - "/etc/mysql/my.cnf" to set global options,
                      # - "~/.my.cnf" to set user-specific options.
                      #
                      # One can use all long options that the program supports.
                      # Run program with --help to get a list of available options and with
                      # --print-defaults to see which it would actually understand and use.
                      #
                      # For explanations see
                      # http://dev.mysql.com/doc/mysql/en/server-system-variables.html

                      #
                      # * IMPORTANT: Additional settings that can override those from this file!
                      # The files must end with '.cnf', otherwise they'll be ignored.
                      #

                      !includedir /etc/mysql/conf.d/
                      !includedir /etc/mysql/mysql.conf.d/

                      [mysqld]
                      bind-address = 0.0.0.0


                      Note the [mysqld] group.






                      share|improve this answer


























                      • This is such pain in a**. Have been trying to make remote connections work for almost two days now. Remote connections should be enabled out of the box.

                        – Mark Alexa
                        Sep 7 '17 at 14:48











                      • Why would you expose every database server to the internet out of the box? Aren't there enough unsecured systems out there?

                        – A. Scherbaum
                        Oct 10 '17 at 11:52











                      • If you wish to access it from more than one, but less than all the interfaces, you should bind to 0.0.0.0 and firewall off the interfaces you don't want to be accessed through.

                        – Rob
                        Apr 9 '18 at 13:32














                      2












                      2








                      2







                      My file is the same. You need to add the correct group above the command you're trying to put in otherwise the service wont start.



                      To add bind-address you will need to add [mysqld] above it.



                      If you need to check what the groups are for the other commands, there's an example my.cnf file here.



                      If you want to enable remote connections from all interfaces (i.e 0.0.0.0), your file would look something like below, however be sure you set up your firewall correctly if you do.



                      #
                      # The MySQL database server configuration file.
                      #
                      # You can copy this to one of:
                      # - "/etc/mysql/my.cnf" to set global options,
                      # - "~/.my.cnf" to set user-specific options.
                      #
                      # One can use all long options that the program supports.
                      # Run program with --help to get a list of available options and with
                      # --print-defaults to see which it would actually understand and use.
                      #
                      # For explanations see
                      # http://dev.mysql.com/doc/mysql/en/server-system-variables.html

                      #
                      # * IMPORTANT: Additional settings that can override those from this file!
                      # The files must end with '.cnf', otherwise they'll be ignored.
                      #

                      !includedir /etc/mysql/conf.d/
                      !includedir /etc/mysql/mysql.conf.d/

                      [mysqld]
                      bind-address = 0.0.0.0


                      Note the [mysqld] group.






                      share|improve this answer















                      My file is the same. You need to add the correct group above the command you're trying to put in otherwise the service wont start.



                      To add bind-address you will need to add [mysqld] above it.



                      If you need to check what the groups are for the other commands, there's an example my.cnf file here.



                      If you want to enable remote connections from all interfaces (i.e 0.0.0.0), your file would look something like below, however be sure you set up your firewall correctly if you do.



                      #
                      # The MySQL database server configuration file.
                      #
                      # You can copy this to one of:
                      # - "/etc/mysql/my.cnf" to set global options,
                      # - "~/.my.cnf" to set user-specific options.
                      #
                      # One can use all long options that the program supports.
                      # Run program with --help to get a list of available options and with
                      # --print-defaults to see which it would actually understand and use.
                      #
                      # For explanations see
                      # http://dev.mysql.com/doc/mysql/en/server-system-variables.html

                      #
                      # * IMPORTANT: Additional settings that can override those from this file!
                      # The files must end with '.cnf', otherwise they'll be ignored.
                      #

                      !includedir /etc/mysql/conf.d/
                      !includedir /etc/mysql/mysql.conf.d/

                      [mysqld]
                      bind-address = 0.0.0.0


                      Note the [mysqld] group.







                      share|improve this answer














                      share|improve this answer



                      share|improve this answer








                      edited 2 mins ago

























                      answered Aug 10 '17 at 14:13









                      RobRob

                      214




                      214













                      • This is such pain in a**. Have been trying to make remote connections work for almost two days now. Remote connections should be enabled out of the box.

                        – Mark Alexa
                        Sep 7 '17 at 14:48











                      • Why would you expose every database server to the internet out of the box? Aren't there enough unsecured systems out there?

                        – A. Scherbaum
                        Oct 10 '17 at 11:52











                      • If you wish to access it from more than one, but less than all the interfaces, you should bind to 0.0.0.0 and firewall off the interfaces you don't want to be accessed through.

                        – Rob
                        Apr 9 '18 at 13:32



















                      • This is such pain in a**. Have been trying to make remote connections work for almost two days now. Remote connections should be enabled out of the box.

                        – Mark Alexa
                        Sep 7 '17 at 14:48











                      • Why would you expose every database server to the internet out of the box? Aren't there enough unsecured systems out there?

                        – A. Scherbaum
                        Oct 10 '17 at 11:52











                      • If you wish to access it from more than one, but less than all the interfaces, you should bind to 0.0.0.0 and firewall off the interfaces you don't want to be accessed through.

                        – Rob
                        Apr 9 '18 at 13:32

















                      This is such pain in a**. Have been trying to make remote connections work for almost two days now. Remote connections should be enabled out of the box.

                      – Mark Alexa
                      Sep 7 '17 at 14:48





                      This is such pain in a**. Have been trying to make remote connections work for almost two days now. Remote connections should be enabled out of the box.

                      – Mark Alexa
                      Sep 7 '17 at 14:48













                      Why would you expose every database server to the internet out of the box? Aren't there enough unsecured systems out there?

                      – A. Scherbaum
                      Oct 10 '17 at 11:52





                      Why would you expose every database server to the internet out of the box? Aren't there enough unsecured systems out there?

                      – A. Scherbaum
                      Oct 10 '17 at 11:52













                      If you wish to access it from more than one, but less than all the interfaces, you should bind to 0.0.0.0 and firewall off the interfaces you don't want to be accessed through.

                      – Rob
                      Apr 9 '18 at 13:32





                      If you wish to access it from more than one, but less than all the interfaces, you should bind to 0.0.0.0 and firewall off the interfaces you don't want to be accessed through.

                      – Rob
                      Apr 9 '18 at 13:32











                      0














                      In that case, that file is not the main where all the information about bind-adress, binlogs and etc include. But there is another file, where they include. Try this:



                      nano /etc/mysql/mysql.conf.d/mysqld.cnf


                      It helped me, and It should help you.






                      share|improve this answer




























                        0














                        In that case, that file is not the main where all the information about bind-adress, binlogs and etc include. But there is another file, where they include. Try this:



                        nano /etc/mysql/mysql.conf.d/mysqld.cnf


                        It helped me, and It should help you.






                        share|improve this answer


























                          0












                          0








                          0







                          In that case, that file is not the main where all the information about bind-adress, binlogs and etc include. But there is another file, where they include. Try this:



                          nano /etc/mysql/mysql.conf.d/mysqld.cnf


                          It helped me, and It should help you.






                          share|improve this answer













                          In that case, that file is not the main where all the information about bind-adress, binlogs and etc include. But there is another file, where they include. Try this:



                          nano /etc/mysql/mysql.conf.d/mysqld.cnf


                          It helped me, and It should help you.







                          share|improve this answer












                          share|improve this answer



                          share|improve this answer










                          answered Sep 29 '18 at 7:15









                          Guu MeeGuu Mee

                          1




                          1






























                              draft saved

                              draft discarded




















































                              Thanks for contributing an answer to Ask Ubuntu!


                              • Please be sure to answer the question. Provide details and share your research!

                              But avoid



                              • Asking for help, clarification, or responding to other answers.

                              • Making statements based on opinion; back them up with references or personal experience.


                              To learn more, see our tips on writing great answers.




                              draft saved


                              draft discarded














                              StackExchange.ready(
                              function () {
                              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f699903%2fwhy-is-etc-mysql-my-cnf-empty%23new-answer', 'question_page');
                              }
                              );

                              Post as a guest















                              Required, but never shown





















































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown

































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown







                              Popular posts from this blog

                              Why do type traits not work with types in namespace scope?What are POD types in C++?Why can templates only be...

                              Will tsunami waves travel forever if there was no land?Why do tsunami waves begin with the water flowing away...

                              Simple Scan not detecting my scanner (Brother DCP-7055W)Brother MFC-L2700DW printer can print, can't...