/ Register

Learn about Centmin Mod LEMP Stack 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.

Previous Thread Next Thread
Loading...
  1. Nov 21, 2016 #1
    elargento

    elargento Member

    353
    18
    18
    Jan 4, 2016
    Ratings:
    +45
    Local Time:
    12:52 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. Nov 22, 2016 #2
    Sunka

    Sunka Well-Known Member

    1,150
    325
    83
    Oct 31, 2015
    Pula, Croatia
    Ratings:
    +525
    Local Time:
    5:52 AM
    Nginx 1.17.9
    MariaDB 10.3.22
    Second password is database password, is it same as in config?
    What about your screenshots?
     
  3. Nov 22, 2016 #3
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    1:52 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    yeah screenshots ?

    make sure you enter the mysql root user password not the linux root user password
     
  4. Nov 22, 2016 #4
    elargento

    elargento Member

    353
    18
    18
    Jan 4, 2016
    Ratings:
    +45
    Local Time:
    12:52 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. Nov 22, 2016 #5
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    1:52 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    you can find existing mysql root pass in /root/.my.cnf
     
  6. Nov 22, 2016 #6
    elargento

    elargento Member

    353
    18
    18
    Jan 4, 2016
    Ratings:
    +45
    Local Time:
    12:52 AM
    10
    Don't see that file in root folder. Just the following:
    upload_2016-11-21_22-58-28.png
     
  7. Nov 22, 2016 #7
    Sunka

    Sunka Well-Known Member

    1,150
    325
    83
    Oct 31, 2015
    Pula, Croatia
    Ratings:
    +525
    Local Time:
    5:52 AM
    Nginx 1.17.9
    MariaDB 10.3.22
    ls -la
     
  8. Nov 22, 2016 #8
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    1:52 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    use command ls -lah to show dot files

    or just
    Code (Text):
    cat /root/.my.cnf
     
  9. Nov 22, 2016 #9
    Sunka

    Sunka Well-Known Member

    1,150
    325
    83
    Oct 31, 2015
    Pula, Croatia
    Ratings:
    +525
    Local Time:
    5:52 AM
    Nginx 1.17.9
    MariaDB 10.3.22
    just type
    Code:
    cat /root/.my.cnf
     
  10. Nov 22, 2016 #10
    Sunka

    Sunka Well-Known Member

    1,150
    325
    83
    Oct 31, 2015
    Pula, Croatia
    Ratings:
    +525
    Local Time:
    5:52 AM
    Nginx 1.17.9
    MariaDB 10.3.22
    ;)
     
  11. Nov 22, 2016 #11
    elargento

    elargento Member

    353
    18
    18
    Jan 4, 2016
    Ratings:
    +45
    Local Time:
    12:52 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. Nov 22, 2016 #12
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    1:52 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    /root/centminlogs should have a log
     
  13. Nov 22, 2016 #13
    elargento

    elargento Member

    353
    18
    18
    Jan 4, 2016
    Ratings:
    +45
    Local Time:
    12:52 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. Nov 22, 2016 #14
    Sunka

    Sunka Well-Known Member

    1,150
    325
    83
    Oct 31, 2015
    Pula, Croatia
    Ratings:
    +525
    Local Time:
    5:52 AM
    Nginx 1.17.9
    MariaDB 10.3.22
    Can you just see it in your browser history?

    Maybe try some of this:

    Code:
    https://yourhostname/17938_mysqladmin24649

OR

https://serverIP/17938_mysqladmin24649
     
  15. Nov 22, 2016 #15
    elargento

    elargento Member

    353
    18
    18
    Jan 4, 2016
    Ratings:
    +45
    Local Time:
    12:52 AM
    10
    I've tried both an none of them work and unfortunately I removed browser history few hours ago :/
     
  16. Nov 22, 2016 #16
    Sunka

    Sunka Well-Known Member

    1,150
    325
    83
    Oct 31, 2015
    Pula, Croatia
    Ratings:
    +525
    Local Time:
    5:52 AM
    Nginx 1.17.9
    MariaDB 10.3.22
    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
     
  17. Nov 22, 2016 #17
    elargento

    elargento Member

    353
    18
    18
    Jan 4, 2016
    Ratings:
    +45
    Local Time:
    12:52 AM
    10
    Really? Can't believe it isn't saved in the logs :/
     
  18. Nov 22, 2016 #18
    elargento

    elargento Member

    353
    18
    18
    Jan 4, 2016
    Ratings:
    +45
    Local Time:
    12:52 AM
    10
    sorry! didn't see "hostname". I entered the domain instead of it. It works now :) Thanks!
     
  19. Nov 22, 2016 #19
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    1:52 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    It is saved see the cloning into line
     
  20. Nov 22, 2016 #20
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    1:52 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    Yes it's off main hostname
     
Previous Thread Next Thread
Loading...

.