• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    After imaging the OS, an error came in saying cannot access database

    Scheduled Pinned Locked Moved Solved
    Linux Problems
    2
    5
    448
    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.
    • W
      weidongyan
      last edited by

      After fixing the network PXE booting problem, I came into another issue here. While installing the fog server to my ubuntu 18, I did not enter any password when asking me about the password for mysql. So right now I cannot access mysql and it gave me the error that ‘Access denied for user ‘root@localhost’ (using password:NO)’ So after finishing the image, an error came in saying something wrong because of the denied database. Is there any solution for this? Right now when I enter mysql command, I came to a MariaDB instead of mysql.

      1 Reply Last reply Reply Quote 0
      • S
        Sebastian Roth Moderator
        last edited by

        @weidongyan MariaDB is kind of the successor of MySQL. But still you see the old name around even if you actually have MariaDB installed - e.g. the command line tools.

        So when you try connecting on the command line: mysql -u root -p and then just hit ENTER for empty password. What happens?

        Please read the following topic: https://forums.fogproject.org/topic/10006/ubuntu-is-fog-s-enemy

        Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

        Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

        W 1 Reply Last reply Reply Quote 0
        • W
          weidongyan @Sebastian Roth
          last edited by

          @Sebastian-Roth Hi Sebastian, when I enter the command, I directly went to the MariaDB instead of MySQL

          1 Reply Last reply Reply Quote 0
          • S
            Sebastian Roth Moderator
            last edited by

            @weidongyan So you can login to the database with just hitting ENTER? (empty password)

            Don’t worry about the naming. Earlier versions were called MySQL and now it’s MariaDB but it’s essentially the same.

            Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

            Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

            W 1 Reply Last reply Reply Quote 0
            • W
              weidongyan @Sebastian Roth
              last edited by

              @Sebastian-Roth Hi Sebastian, I reboot the system and now when I enter the command, it prompted ‘Enter password’, I just click enter and now the error came
              'ERRO 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO). Because last time I entered some command I found in the internet, I did not want that to influence our process so I reboot. Last time, I restarted MySQL and entered ’ sudo mysqld_safe -skip-grant-tables’

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

              222

              Online

              12.0k

              Users

              17.3k

              Topics

              155.2k

              Posts
              Copyright © 2012-2024 FOG Project