• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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

C

cesar@

Guest
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.
 
please reply..

i really need to know an answer to this post. Please somebody give any sugestions.
 
the phpmyadmin that Plesk installs is only accessable through the controlpanel. But you can install phpmyadmin yourself in /httpdocs/ without much problem.
 
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?
 
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
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'YOUR_user'; // MySQL user
$cfg['Servers'][$i]['password'] = 'YOUR_password`; // MySQL password (only neede
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
 
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.
 
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.
 
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.
 
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
 
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)
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

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.
 
Originally posted by cesar
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.

wow.
 
wow is understandable... but now its here for all to learn. thanks for all the help.
 
Back
Top