ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    NextCloud 10 Stable...Failed To Connect To Database

    IT Discussion
    3
    13
    2.0k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • A
      alex.olynyk
      last edited by

      0_1472151019790_Capture.PNG
      I posted this a while back when I had the issue on owncloud 9 but still cant find a solution.
      I can login to the DB using the account I created.
      0_1472151234533_Capture.PNG
      I tried using 127.0.0.1 instead of localhost
      SHOW DATABASES
      0_1472151353705_Capture.PNG
      0_1472151558851_Capture.PNG
      Any idea?

      1 Reply Last reply Reply Quote 0
      • A
        Alex Sage
        last edited by

        How sure are you the password is correct?

        A 1 Reply Last reply Reply Quote 0
        • A
          alex.olynyk @Alex Sage
          last edited by

          @aaronstuder I can login with that user and password in the CLI.

          1 Reply Last reply Reply Quote 0
          • J
            Jstear
            last edited by

            What does Show Grants; show?

            A 1 Reply Last reply Reply Quote 1
            • A
              Alex Sage
              last edited by

              Any firewall?

              A 1 Reply Last reply Reply Quote 0
              • J
                Jstear
                last edited by

                Also, did you ever run "flush privileges;" ?

                1 Reply Last reply Reply Quote 0
                • A
                  alex.olynyk @Jstear
                  last edited by

                  @Jstear 0_1472156935059_Capture.PNG
                  But...when I run
                  create user 'nextclouduser'@'localhost' identified by 'nextcloudpassword';
                  grant all on nextcloud_db.* to 'nextclouduser'@'localhost';
                  flush privileges;
                  quit
                  I get Query OK for all commands run. I reboot and SHOW GRANTS; and I get the same output

                  1 Reply Last reply Reply Quote 0
                  • A
                    alex.olynyk @Alex Sage
                    last edited by

                    @aaronstuder 0_1472157188184_Capture.PNG

                    1 Reply Last reply Reply Quote 0
                    • J
                      Jstear
                      last edited by

                      Alright, so your nextclouduser doesn't have permissions to write to the database.

                      1 Reply Last reply Reply Quote 0
                      • J
                        Jstear
                        last edited by

                        Login using mysql -u nxtuser -p and run show grants;

                        1 Reply Last reply Reply Quote 1
                        • J
                          Jstear
                          last edited by

                          Try changing this:

                          grant all on nextcloud_db.* to 'nextclouduser'@'localhost';

                          To:

                          GRANT ALL PRIVILEGES ON nextcloud_db.* TO 'nxtuser@'localhost' IDENTIFIED BY 'nextcloudpassword' WITH GRANT OPTION;

                          A 1 Reply Last reply Reply Quote 1
                          • A
                            alex.olynyk @Jstear
                            last edited by

                            @Jstear That worked when I added WITH GRANT OPTION. Thank you. Ill add this to my notes.

                            1 Reply Last reply Reply Quote 1
                            • J
                              Jstear
                              last edited by

                              Awesome, glad I could help!

                              1 Reply Last reply Reply Quote 0
                              • 1 / 1
                              • First post
                                Last post