Join the community today
Register Now

Install phpmyadmin installation. Can't access with root user

Discussion in 'Install & Upgrades or Pre-Install Questions' started by elargento, Nov 21, 2016.

  1. elargento

    elargento Member

    293
    16
    18
    Jan 4, 2016
    Ratings:
    +39
    Local Time:
    9:40 AM
    10
    Hi,

    I've just installed phpmyadmin and was able to access to the login screen after entered .htaccess username and password. However I'm not able to log in since I'm getting the following error:
    Code:
    mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)
    Any ideas why I can't log in as root?
     
  2. Sunka

    Sunka Active Member

    932
    243
    43
    Oct 31, 2015
    Rijeka, Croatia
    Ratings:
    +394
    Local Time:
    1:40 PM
    Nginx 1.13.3
    MariaDB 10.1.24
    Second password is database password, is it same as in config?
    What about your screenshots?
     
  3. eva2000

    eva2000 Administrator Staff Member

    31,025
    6,927
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,433
    Local Time:
    10:40 PM
    Nginx 1.13.x
    MariaDB 5.5
    yeah screenshots ?

    make sure you enter the mysql root user password not the linux root user password
     
  4. elargento

    elargento Member

    293
    16
    18
    Jan 4, 2016
    Ratings:
    +39
    Local Time:
    9:40 AM
    10
    lol, I accidentally pasted the screenshots, removed them in the editor but they remained attached.

    Which is the log I should look for in order to see which are the log in details?
     
  5. eva2000

    eva2000 Administrator Staff Member

    31,025
    6,927
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,433
    Local Time:
    10:40 PM
    Nginx 1.13.x
    MariaDB 5.5
    you can find existing mysql root pass in /root/.my.cnf
     
  6. elargento

    elargento Member

    293
    16
    18
    Jan 4, 2016
    Ratings:
    +39
    Local Time:
    9:40 AM
    10
    Don't see that file in root folder. Just the following:
    upload_2016-11-21_22-58-28.png
     
  7. Sunka

    Sunka Active Member

    932
    243
    43
    Oct 31, 2015
    Rijeka, Croatia
    Ratings:
    +394
    Local Time:
    1:40 PM
    Nginx 1.13.3
    MariaDB 10.1.24
    ls -la
     
    • Agree Agree x 1
  8. eva2000

    eva2000 Administrator Staff Member

    31,025
    6,927
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,433
    Local Time:
    10:40 PM
    Nginx 1.13.x
    MariaDB 5.5
    use command ls -lah to show dot files

    or just
    Code (Text):
    cat /root/.my.cnf
     
    • Agree Agree x 1
  9. Sunka

    Sunka Active Member

    932
    243
    43
    Oct 31, 2015
    Rijeka, Croatia
    Ratings:
    +394
    Local Time:
    1:40 PM
    Nginx 1.13.3
    MariaDB 10.1.24
    just type
    Code:
    cat /root/.my.cnf
     
  10. Sunka

    Sunka Active Member

    932
    243
    43
    Oct 31, 2015
    Rijeka, Croatia
    Ratings:
    +394
    Local Time:
    1:40 PM
    Nginx 1.13.3
    MariaDB 10.1.24
    ;)
     
    • Like Like x 1
  11. elargento

    elargento Member

    293
    16
    18
    Jan 4, 2016
    Ratings:
    +39
    Local Time:
    9:40 AM
    10
    Thank you guys, sorry for having many questions!. I don't remember which is the URL provided by centminmod when I installed phpmyadmin. Where can I find it?
     
  12. eva2000

    eva2000 Administrator Staff Member

    31,025
    6,927
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,433
    Local Time:
    10:40 PM
    Nginx 1.13.x
    MariaDB 5.5
    /root/centminlogs should have a log
     
  13. elargento

    elargento Member

    293
    16
    18
    Jan 4, 2016
    Ratings:
    +39
    Local Time:
    9:40 AM
    10
    I've already tried to find it there but in phpmyadmin install log there is no url, just htaccess username and password:
    upload_2016-11-21_23-42-49.png
     
  14. Sunka

    Sunka Active Member

    932
    243
    43
    Oct 31, 2015
    Rijeka, Croatia
    Ratings:
    +394
    Local Time:
    1:40 PM
    Nginx 1.13.3
    MariaDB 10.1.24
    Can you just see it in your browser history?

    Maybe try some of this:

    Code:
    https://yourhostname/17938_mysqladmin24649
    
    OR
    
    https://serverIP/17938_mysqladmin24649
     
    • Useful Useful x 1
  15. elargento

    elargento Member

    293
    16
    18
    Jan 4, 2016
    Ratings:
    +39
    Local Time:
    9:40 AM
    10
    I've tried both an none of them work and unfortunately I removed browser history few hours ago :/
     
  16. Sunka

    Sunka Active Member

    932
    243
    43
    Oct 31, 2015
    Rijeka, Croatia
    Ratings:
    +394
    Local Time:
    1:40 PM
    Nginx 1.13.3
    MariaDB 10.1.24
    Then just uninstall phpmyadmin and install it again, and then copy what it wrote in output so you will have it if you forget it.

    To uninstall
    Code:
    /root/tools/phpmyadmin_uninstall.sh
     
    • Like Like x 1
  17. elargento

    elargento Member

    293
    16
    18
    Jan 4, 2016
    Ratings:
    +39
    Local Time:
    9:40 AM
    10
    Really? Can't believe it isn't saved in the logs :/
     
  18. elargento

    elargento Member

    293
    16
    18
    Jan 4, 2016
    Ratings:
    +39
    Local Time:
    9:40 AM
    10
    sorry! didn't see "hostname". I entered the domain instead of it. It works now :) Thanks!
     
    • Like Like x 1
  19. eva2000

    eva2000 Administrator Staff Member

    31,025
    6,927
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,433
    Local Time:
    10:40 PM
    Nginx 1.13.x
    MariaDB 5.5
    It is saved see the cloning into line
     
    • Like Like x 2
  20. eva2000

    eva2000 Administrator Staff Member

    31,025
    6,927
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,433
    Local Time:
    10:40 PM
    Nginx 1.13.x
    MariaDB 5.5
    Yes it's off main hostname
     
    • Like Like x 1
    • Agree Agree x 1