mysqldump “Access denied” error on ubuntu with mariadb (login informations are correct) ...

Single author papers against my advisor's will?

Slither Like a Snake

Area of a 2D convex hull

Array/tabular for long multiplication

What do you call a plan that's an alternative plan in case your initial plan fails?

Classification of bundles, Postnikov towers, obstruction theory, local coefficients

Why is "Captain Marvel" translated as male in Portugal?

Passing functions in C++

Strange behaviour of Check

How do I automatically answer y in bash script?

Why use gamma over alpha radiation?

Geometric mean and geometric standard deviation

Simulating Exploding Dice

Antler Helmet: Can it work?

When communicating altitude with a '9' in it, should it be pronounced "nine hundred" or "niner hundred"?

Notation for two qubit composite product state

Autumning in love

How to rotate it perfectly?

How to market an anarchic city as a tourism spot to people living in civilized areas?

Is there folklore associating late breastfeeding with low intelligence and/or gullibility?

Replacing HDD with SSD; what about non-APFS/APFS?

Two different pronunciation of "понял"

Why is there no army of Iron-Mans in the MCU?

Fishing simulator



mysqldump “Access denied” error on ubuntu with mariadb (login informations are correct)



Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)How do I set up Mysql Cluster?How can I get mysqldump to use the credentials from mysql_config_editor in a crontab-executed script?Why are MariaDB versions different with same configurations?MySQL Login ErrorUnable to access remotely (LAMP issue)Mariadb not working just after install on Ubuntu 16.04Cannot log into MySQLmysql restore from dump backup of all databases with user privilegesWith Adminer.php I get a Access denied for user 'root'@'localhost' error. Ubuntu 18.04mysqldump in 18.04 LTS





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







0















I use Ubuntu with a mariadb database.



I want to make a mysqldump of my sql databases, but i get allways the following error:



mysqldump: Got error: 1045; "Access denied for user 'db_user-backups'@'localhosts' (using password: YES)" when trying to connect


The command that throws this error is following:



sudo mysqldump --defaults-file=/etc/mysql/my.cnf lom


I have allready added the username and passwort to /etc/mysql/my.cnf and made shure the cnf file has the right permissions:



[mysqldump]
user=db_user_backups
password=MyS3cretP4ssw0rD!


The username and password is correct, I can login with my sql client.



Does anyone have an idea whats im doing wrong?



(btw: please forgive me im a linux beginner ^^')










share|improve this question





























    0















    I use Ubuntu with a mariadb database.



    I want to make a mysqldump of my sql databases, but i get allways the following error:



    mysqldump: Got error: 1045; "Access denied for user 'db_user-backups'@'localhosts' (using password: YES)" when trying to connect


    The command that throws this error is following:



    sudo mysqldump --defaults-file=/etc/mysql/my.cnf lom


    I have allready added the username and passwort to /etc/mysql/my.cnf and made shure the cnf file has the right permissions:



    [mysqldump]
    user=db_user_backups
    password=MyS3cretP4ssw0rD!


    The username and password is correct, I can login with my sql client.



    Does anyone have an idea whats im doing wrong?



    (btw: please forgive me im a linux beginner ^^')










    share|improve this question

























      0












      0








      0








      I use Ubuntu with a mariadb database.



      I want to make a mysqldump of my sql databases, but i get allways the following error:



      mysqldump: Got error: 1045; "Access denied for user 'db_user-backups'@'localhosts' (using password: YES)" when trying to connect


      The command that throws this error is following:



      sudo mysqldump --defaults-file=/etc/mysql/my.cnf lom


      I have allready added the username and passwort to /etc/mysql/my.cnf and made shure the cnf file has the right permissions:



      [mysqldump]
      user=db_user_backups
      password=MyS3cretP4ssw0rD!


      The username and password is correct, I can login with my sql client.



      Does anyone have an idea whats im doing wrong?



      (btw: please forgive me im a linux beginner ^^')










      share|improve this question














      I use Ubuntu with a mariadb database.



      I want to make a mysqldump of my sql databases, but i get allways the following error:



      mysqldump: Got error: 1045; "Access denied for user 'db_user-backups'@'localhosts' (using password: YES)" when trying to connect


      The command that throws this error is following:



      sudo mysqldump --defaults-file=/etc/mysql/my.cnf lom


      I have allready added the username and passwort to /etc/mysql/my.cnf and made shure the cnf file has the right permissions:



      [mysqldump]
      user=db_user_backups
      password=MyS3cretP4ssw0rD!


      The username and password is correct, I can login with my sql client.



      Does anyone have an idea whats im doing wrong?



      (btw: please forgive me im a linux beginner ^^')







      server mysql mariadb






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Apr 12 '18 at 19:39









      GoniosGonios

      11




      11






















          2 Answers
          2






          active

          oldest

          votes


















          0














          With error "Access denied for user 'db_user-backups'@'localhosts'. You can connect to db and grant permission for user 'db_user-backups' with command example:



          Connect to Mysql: mysql -u root -p:



          GRANT ALL PRIVILEGES ON *.* TO db_user-backups@'localhosts' IDENTIFIED BY 'password' with grant option;

          flush privileges;


          After you can reconnect with mysqldump.






          share|improve this answer































            0














            Try specifying the port. I'm using MySQL 8.0 on Windows but similar issues apply on Ubuntu. Without a port argument I got the same error:



            C:Usersuser>mysqldump -u root -p airlines_test > C:...testairlines_test_dump.sql
            Enter password: ******************
            mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect


            I fixed this by specifying the port to use: -P 3306:



            C:Usersuser>mysqldump -u root -p -P 3306 airlines_test > C:...testairlines_test_dump.sql
            Enter password: ******************





            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%2f1024456%2fmysqldump-access-denied-error-on-ubuntu-with-mariadb-login-informations-are-c%23new-answer', 'question_page');
              }
              );

              Post as a guest















              Required, but never shown

























              2 Answers
              2






              active

              oldest

              votes








              2 Answers
              2






              active

              oldest

              votes









              active

              oldest

              votes






              active

              oldest

              votes









              0














              With error "Access denied for user 'db_user-backups'@'localhosts'. You can connect to db and grant permission for user 'db_user-backups' with command example:



              Connect to Mysql: mysql -u root -p:



              GRANT ALL PRIVILEGES ON *.* TO db_user-backups@'localhosts' IDENTIFIED BY 'password' with grant option;

              flush privileges;


              After you can reconnect with mysqldump.






              share|improve this answer




























                0














                With error "Access denied for user 'db_user-backups'@'localhosts'. You can connect to db and grant permission for user 'db_user-backups' with command example:



                Connect to Mysql: mysql -u root -p:



                GRANT ALL PRIVILEGES ON *.* TO db_user-backups@'localhosts' IDENTIFIED BY 'password' with grant option;

                flush privileges;


                After you can reconnect with mysqldump.






                share|improve this answer


























                  0












                  0








                  0







                  With error "Access denied for user 'db_user-backups'@'localhosts'. You can connect to db and grant permission for user 'db_user-backups' with command example:



                  Connect to Mysql: mysql -u root -p:



                  GRANT ALL PRIVILEGES ON *.* TO db_user-backups@'localhosts' IDENTIFIED BY 'password' with grant option;

                  flush privileges;


                  After you can reconnect with mysqldump.






                  share|improve this answer













                  With error "Access denied for user 'db_user-backups'@'localhosts'. You can connect to db and grant permission for user 'db_user-backups' with command example:



                  Connect to Mysql: mysql -u root -p:



                  GRANT ALL PRIVILEGES ON *.* TO db_user-backups@'localhosts' IDENTIFIED BY 'password' with grant option;

                  flush privileges;


                  After you can reconnect with mysqldump.







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered Apr 19 '18 at 4:18









                  TannettoTannetto

                  40137




                  40137

























                      0














                      Try specifying the port. I'm using MySQL 8.0 on Windows but similar issues apply on Ubuntu. Without a port argument I got the same error:



                      C:Usersuser>mysqldump -u root -p airlines_test > C:...testairlines_test_dump.sql
                      Enter password: ******************
                      mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect


                      I fixed this by specifying the port to use: -P 3306:



                      C:Usersuser>mysqldump -u root -p -P 3306 airlines_test > C:...testairlines_test_dump.sql
                      Enter password: ******************





                      share|improve this answer




























                        0














                        Try specifying the port. I'm using MySQL 8.0 on Windows but similar issues apply on Ubuntu. Without a port argument I got the same error:



                        C:Usersuser>mysqldump -u root -p airlines_test > C:...testairlines_test_dump.sql
                        Enter password: ******************
                        mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect


                        I fixed this by specifying the port to use: -P 3306:



                        C:Usersuser>mysqldump -u root -p -P 3306 airlines_test > C:...testairlines_test_dump.sql
                        Enter password: ******************





                        share|improve this answer


























                          0












                          0








                          0







                          Try specifying the port. I'm using MySQL 8.0 on Windows but similar issues apply on Ubuntu. Without a port argument I got the same error:



                          C:Usersuser>mysqldump -u root -p airlines_test > C:...testairlines_test_dump.sql
                          Enter password: ******************
                          mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect


                          I fixed this by specifying the port to use: -P 3306:



                          C:Usersuser>mysqldump -u root -p -P 3306 airlines_test > C:...testairlines_test_dump.sql
                          Enter password: ******************





                          share|improve this answer













                          Try specifying the port. I'm using MySQL 8.0 on Windows but similar issues apply on Ubuntu. Without a port argument I got the same error:



                          C:Usersuser>mysqldump -u root -p airlines_test > C:...testairlines_test_dump.sql
                          Enter password: ******************
                          mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect


                          I fixed this by specifying the port to use: -P 3306:



                          C:Usersuser>mysqldump -u root -p -P 3306 airlines_test > C:...testairlines_test_dump.sql
                          Enter password: ******************






                          share|improve this answer












                          share|improve this answer



                          share|improve this answer










                          answered 14 mins ago









                          Karl BakerKarl Baker

                          1115




                          1115






























                              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%2f1024456%2fmysqldump-access-denied-error-on-ubuntu-with-mariadb-login-informations-are-c%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...