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

    Access denied for user 'root' @ ' localhost ' (Using password : NO ) #tried YES

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    5
    24
    15.7k
    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.
    • M
      MagicLink
      last edited by

      Hi,

      @Wayne-Workman @ciranodd we have the same issue too on Debian 8. No Mysql (fresh install), just installed with FOG trunk. If we don’t put a MySQL password (empty password) at the install, there are no problems. If we put a password, the error “Access denied for user ‘root’ @ ’ localhost ’ (Using password : NO ) #tried YES” occurs when we want to install/upgrade database (same on the capture from ciranodd).

      Or else, if password put, we have to change manually rights for root account on mysql.

      Tom ElliottT Wayne WorkmanW 2 Replies Last reply Reply Quote 0
      • Tom ElliottT
        Tom Elliott @MagicLink
        last edited by

        @MagicLink A database password for the root user must be setup by you or the administrator for there to BE a password set in the first place.

        In older times, Ubuntu/Debian would ask you to supply a password, but I removed this requirement because redhat variants never gave this opportunity during the installation process. In trying to commonize the functions, I was able to get mysql to be installed in much the same methodology as Redhat based OS’s under Debian/Ubuntu variants.

        When it asks you for the password, it asks you “Did you set a password for mysql?” It is not the opportunity for you to set one.

        This is to be expected.

        Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

        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

        1 Reply Last reply Reply Quote 1
        • Wayne WorkmanW
          Wayne Workman @MagicLink
          last edited by

          @MagicLink I’ll check this out tomorrow on the RedHat side and see what happens.

          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
          Daily Clean Installation Results:
          https://fogtesting.fogproject.us/
          FOG Reporting:
          https://fog-external-reporting-results.fogproject.us/

          1 Reply Last reply Reply Quote 0
          • C
            ciranodd
            last edited by

            Hi Guys,

            Didn’t wanted to bother anyone again since we solved the problem. But indeed as @MagicLink said when entering a password during fog installation gave me the issue again (I had to prepared a backed server in case this one goes bad), however all i had to do was make sure MYSQL was running correctly (ran into the same problem, but i had a fixed !!!) 0_1459315888568_ERROR 2002 (HY000)-FOG SERVER MYSQL FIX.txt

            Then make sure that the both configuration files match the inf you entered during the installation
            /var/www/html/fog/lib/fog/config.class.php
            /opt/fog/.fogsettings
            and DONE.

            ps,

            Not sure what i did wrong but when i re-ran the install the LOCALHOST in the config file /var/www/html/fog/lib/fog/config.class.php was changed to the IP i gave my server instead of the “localhost”

            Just change changed it to “localhost” and DONE !!!

            Lesson !!!

            Always make sure your config file is setup correctly !!!

            Regards Gents !!!

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

            200

            Online

            12.0k

            Users

            17.3k

            Topics

            155.2k

            Posts
            Copyright © 2012-2024 FOG Project