Welcome to Centmin Mod Community
Register Now

phpmyadmin issue

Discussion in 'Add Ons' started by Matt Williams, Oct 1, 2015.

  1. Matt Williams

    Matt Williams WordPress Fanatic

    468
    90
    28
    Nov 22, 2014
    Virginia, USA
    Ratings:
    +135
    Local Time:
    10:38 AM
    latest
    10
    I'm using the latest beta code and I installed phpmyadmin with no errors. looked in /usr/local/nginx/html/ and the folder is there but accessing it via https://<serverIP>/2508_mysqladmin14846 it gives me a 404 Not Found after I go through the SSL warning page...

    Anyone know how to fix?
     
  2. eva2000

    eva2000 Administrator Staff Member

    31,001
    6,920
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,426
    Local Time:
    1:38 AM
    Nginx 1.13.x
    MariaDB 5.5
    Latest phpmyadmin.sh addon's ssl vhost setup only allows access via server_name defined main hostname in virtual.conf and not via ip access
     
  3. Matt Williams

    Matt Williams WordPress Fanatic

    468
    90
    28
    Nov 22, 2014
    Virginia, USA
    Ratings:
    +135
    Local Time:
    10:38 AM
    latest
    10
    How can I change it to use the IP address?
     
  4. eva2000

    eva2000 Administrator Staff Member

    31,001
    6,920
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,426
    Local Time:
    1:38 AM
    Nginx 1.13.x
    MariaDB 5.5
    for some reason you can't anymore

    just use a hostname and if you want it private just setup a local pc edited hosts file edit
     
  5. Matt Williams

    Matt Williams WordPress Fanatic

    468
    90
    28
    Nov 22, 2014
    Virginia, USA
    Ratings:
    +135
    Local Time:
    10:38 AM
    latest
    10
    When I create a VPS at VULTR - it creates the hostname as vultr.guest and when I change it to anything.server.com I still can't access it because the domain name is not pointing to the VPS yet. Most of the time I import the database, upload the WP files THEN change the A Record to point to the VPS.

    I accessed the https://<server ip> so I can log in and import the WP database. I guess I can do this through SSH though. Am I still able to move the whole phpmyadmin folder from /usr/local/nginx/html to /home/nginx/domains/xxxxxx.com/public ??
     
  6. eva2000

    eva2000 Administrator Staff Member

    31,001
    6,920
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,426
    Local Time:
    1:38 AM
    Nginx 1.13.x
    MariaDB 5.5
    you can move phpmyadmin folder but you'd have to adjust that php related vhost settings for the change in location - i assume you do that. But there's a reason phpmyadmin folder is setup on main hostname as it's https protected and fully locked down automatically for security via auto set nginx vhost rules. If you're just moving the phpmyadmin folder and setting up basic rules, you may not have it locked down tightly ?

    It's so much easier and faster to upload databases via SSH than via phpmyadmin.

    Example below using my SecureCRT SSH client which has built in sftp client as well so I do not even need to leave my SSH client to upload a backup-database.sql file from my local computer to my server and import the backup-database.sql into a newly created database named newdbname.

    securecrt-sftp-upload-mysqldump-00.gif

    or combine it with mysqladmin_shell.sh mysqladmin_shell.sh Shell based Addon | Centmin Mod Community and you never have to leave SSH for initial database setup at least.
     
    Last edited: Oct 2, 2015
    • Informative Informative x 1