1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

How do I link to PhpMyAdmin, besides through Plesk CP?

Discussion in 'Plesk for Linux - 8.x and Older' started by cesar@, Mar 3, 2006.

  1. cesar@

    cesar@ Guest

    0
     
    How do I link to PhpMyAdmin, besides through Plesk CP?

    I would like to give my clients PhpMyAdmin. But i dont want them to go through Plesk. Is there a way to link to it?

    Thanks.
     
  2. cesar@

    cesar@ Guest

    0
     
    please reply..

    i really need to know an answer to this post. Please somebody give any sugestions.
     
  3. eilko

    eilko Regular Pleskian

    28
    73%
    Joined:
    Aug 1, 2001
    Messages:
    468
    Likes Received:
    4
    Location:
    Enschede, Netherlands
    the phpmyadmin that Plesk installs is only accessable through the controlpanel. But you can install phpmyadmin yourself in /httpdocs/ without much problem.
     
  4. cesar@

    cesar@ Guest

    0
     
    thand you for the reply.

    I am a little green to installing on this server. can you give me instuctions or a link to, how to?

    how will this alternate version of phpMyAdmin aaffect the pre installed version?

    will both versions read the same info?
     
  5. eilko

    eilko Regular Pleskian

    28
    73%
    Joined:
    Aug 1, 2001
    Messages:
    468
    Likes Received:
    4
    Location:
    Enschede, Netherlands
    it is quite easy:

    1. get latest stable version from http://www.phpmyadmin.net/
    2. upload it to your server
    3. untar it
    4. edit config.inc.php
    you can use Plesk admin & password for access to all databases or use the dbase user/password you created in Plesk to give access to only one database.

    5. ready
     
  6. cesar@

    cesar@ Guest

    0
     
    i am a php coder gone web hoster and have little experience with "untaring" a file. can you please provide the code i put into putty to get the file to "untar".

    also where is config.inc.php file? thanks.
     
  7. Highland

    Highland Guest

    0
     
    Keep in mind that phpmyadmin is not a software package, it's just a group of PHP scripts. So if you install a copy elsewhere you won't mess up Plesk. It's just a frontend script that accesses MySQL.

    It's actually quite simple to set up. Just edit the config file (it's well commented) and put in these three things
    -the username
    -the password
    -the database you want to connect to

    Then rename the file config.default.php to config.inc.php

    I would suggest you put this in a password protected directory as anyone who goes there could see and edit your database.
     
  8. cesar@

    cesar@ Guest

    0
     
  9. cesar@

    cesar@ Guest

    0
     
    im getting this error after i complete above phpmyadmin setup.

    MySQL said: Documentation
    #1045 - Access denied for user: 'root@localhost' (Using password: NO)

    I have updated config.inc.php file and removed config.default.php script.
     
  10. cesar@

    cesar@ Guest

    0
     
    ok so i have gotten past the previous issue now i have these errors. i have replaced my domain name with "domainname.net'


    Warning: phpMyAdmin-ERROR: can not open themes folder: in /var/www/vhosts/domainname.net/httpdocs/phpmyadmin/libraries/Theme_Manager.class.php on line 194

    Warning: No valid image path for theme found! in /var/www/vhosts/domainname.net/httpdocs/phpmyadmin/libraries/Theme.class.php on line 109

    Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/domainname.net/httpdocs/phpmyadmin/libraries/Theme_Manager.class.php:194) in /var/www/vhosts/domainname.net/httpdocs/phpmyadmin/libraries/common.lib.php on line 2636

    Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/domainname.net/httpdocs/phpmyadmin/libraries/Theme_Manager.class.php:194) in /var/www/vhosts/domainname.net/httpdocs/phpmyadmin/libraries/common.lib.php on line 2636

    Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/domainname.net/httpdocs/phpmyadmin/libraries/Theme_Manager.class.php:194) in /var/www/vhosts/domainname.net/httpdocs/phpmyadmin/libraries/common.lib.php on line 2636

    Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/domainname.net/httpdocs/phpmyadmin/libraries/Theme_Manager.class.php:194) in /var/www/vhosts/domainname.net/httpdocs/phpmyadmin/libraries/common.lib.php on line 2636

    Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/domainname.net/httpdocs/phpmyadmin/libraries/Theme_Manager.class.php:194) in /var/www/vhosts/domainname.net/httpdocs/phpmyadmin/index.php on line 105
     
  11. Highland

    Highland Guest

    0
     
    I missed your previous tar request. To untar a file that is gzipped (.tar.gz or .tgz) use
    Code:
    tar -xvzf filename
    If your file is just a tarball you can drop the z

    You can ignore the following type of error (emphasis mine)
    That type of error just means you've got another error dumping output so a header() function call failed.

    It could be an ownership problem. If you untarred your file then you need to remember to set the owner to the FTP user, not the fake user the tar command uses. To figure out who should own what SSH into the httpdocs directory. Now do ls -l and you'll see what user is owner of the files in that directory.

    [root@host root]# ls -l
    total 196
    -rw-r--r-- 1 root root 1119 Oct 9 2004 anaconda-ks.cfg
    -rw-r--r-- 1 root root 1212 Jul 27 2005 ca.crt
    -rw-r--r-- 1 root root 963 Jul 27 2005 ca.key
    -rw-r--r-- 1 root root 3 Jul 27 2005 ca.srl

    See that left column of "root"? That's the owner. The owner of the files in your httpdocs directory should be your FTP username for that domain. Let's say that username is "domainowner".

    So you'll see something like this in your httpdocs list

    -rw-r--r-- 1 domainowner domainowner 3 Jul 27 2005 index.html
    drwxr-xr-x 2 33 33 4096 Mar 6 13:39 phpmyadmin

    Soo how the owner of your phpmyadmin directory isn't the same? We need to fix that. So we change the owner
    Code:
    chown -R domainowner phpmyadmin
    Now the phpmyadmin directory and everything inside should be owned by domainowner.
     
  12. acidbox

    acidbox Guest

    0
     
    wow.
     
  13. cesar@

    cesar@ Guest

    0
     
    wow is understandable... but now its here for all to learn. thanks for all the help.
     
Loading...