I’m trying to install phpMyAdmin on my Ubuntu 10.10 server. I type the following command (I don’t use “sudo” because I’m logged in as root, I know its not safe):
apt-get install phpmyadmin
and go through the installation. I allow the installation to configure the database, and I chose the correct server (Apache2), when it asks for passwords, I use the same password that I use for the rest of the server (i.e. it is the account password for root, sudo, and my account).
Once the installation is complete, I try and access it from a computer on the same network. I type “http://.../phpmyadmin” and I get the message saying the directory isn’t there. I go into Webmin to confirm that the directory isn’t there, and it isn’t.
My questions are (1) Why isn’t the phpmyadmin directory in my Apache Server root? (2) Is it installed with apt-get, if so, where? (3) How do I know what server I selected for it to install to? (4) What do I need to do to get it to install correctly?
I know this is a lot of questions, so I want to give a big THANK YOU in advance.
Fedora linux installs phpMyAdmin restricted to only localhost access. Perhaps Ubuntu does the same? With Fedora the apache configuration for phpMyAdmin is in an apache include .conf file that I have to edit to allow access from other network machines…
It can be located anywhere on your disk as long web server user has read access to those files.
(2) Is it installed with apt-get, if so, where?
The phpmyadmin configuration file is located at: /etc/phpmyadmin folder (usually). All you need to do is include the following line in /etc/apache2/apache2.conf
Include /etc/phpmyadmin/apache.conf
(3) How do I know what server I selected for it to install to? (4) What do I need to do to get it to install correctly?
After that restart apache and here it is.
It would be nice to read what’s inside /etc/phpmyadmin/apache.conf. You can change this file to set up your needs.
On RH based distros, locations are not like those above but you can always search for location with #whereis phpmyadmin. Also, RH based distros has a very nice feature to keep all apache config files inside /etc/httpd/conf.d/ and those files will be loaded automatically. It is enough to copy cfg files inside this dir and restart apache with # service httpd restart. This is good idea because main config file (httpd.conf) will be short and clean.
Will this Server be a Developmental machine, or a Public Facing Server? If it is a development server, I would go with XAMPP, as it will automatically install PHPMyAdmin, along with PHP, MySQL, and Apache.