Page 1 of 1
Installing/Using phpMyAdmin [SOLVED]
Posted: Sat May 16, 2009 7:49 pm
by califdon
I just installed phpMyAdmin (as well as a complete LAMP suite) on my Ubuntu 9.04 that I only use for kicks. Everything works, but I can't figure out how to start phpMyAdmin! Sounds stupid, but I can't find any of the php scripts to browse. I've used phpMyAdmin for years on a hosting service, but I never needed to use it on a local server.

Re: Installing/Using phpMyAdmin
Posted: Sun May 17, 2009 12:24 am
by Doug G
Try
http://localhost/phpmyadmin/ and see what happens. In Fedora if you use yum to install phpmyadmin I think the actual files end up in /usr/share/ and an included httpd.conf file sets up the virtual directory.
If you installed phpmyadmin you should be the one who knows where it's files reside

You could always go get the tarball and unpack it to wherever you want.
Re: Installing/Using phpMyAdmin
Posted: Sun May 17, 2009 2:52 am
by Benjamin
In a lot of installs the OS sets up a virtual host for phpMyAdmin. So if apache is running and you visit
http://localhost/phpMyAdmin/ it will pull it up. On my system I changed it to
http://localhost/mysql/
Regardless, phpMyAdmin is nothing more than a regular php application. You can simply copy it into a folder in your webroot and access it from there. This gives you more control over the configuration and version, since sometimes you may want a specific version of phpMyAdmin. Trust me when I say this... I have learned it from experience. Anyhow, once you download it into a folder under your webroot, you'll need to create a config.inc.php file. Here is mine, useful on localhost since you won't have to login every 10 minutes...
Code: Select all
<?php
$i = 0;
// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0].
// You can disable a server config entry by setting host to ''.
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'DBROOTPASSHERE';
/* Server parameters */
//$cfg['Servers'][$i]['host'] = 'localhost';
//$cfg['Servers'][$i]['connect_type'] = 'tcp';
//$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysqli';
/* Optional: User for advanced features */
// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';
/* Optional: Advanced phpMyAdmin features */
// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
// $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
// $cfg['Servers'][$i]['relation'] = 'pma_relation';
// $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
// $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
// $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
// $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
// $cfg['Servers'][$i]['history'] = 'pma_history';
// $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
/*
* End of servers configuration
*/
/*
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
Re: Installing/Using phpMyAdmin
Posted: Sun May 17, 2009 3:22 pm
by califdon
Thanks, guys! Yep, of course that did the trick. I didn't think to check the virtual host config. Some things are SOOO easy when you know the trick! Just proves you're never too old to learn! Thanks again, and I'll look into your suggestions, Astions. That sounds like something I'll want to do, and I do value experience in such matters.
Re: Installing/Using phpMyAdmin [SOLVED]
Posted: Sun May 17, 2009 9:50 pm
by Zoxive
Just a little more info, when you install it on Ubuntu the config files are usually in /etc/phpmyadmin, with the real application located at /usr/share/phpmyadmin.
So you can still change/customize all the stuff that you need to.
Re: Installing/Using phpMyAdmin [SOLVED]
Posted: Mon May 18, 2009 11:13 am
by califdon
Thanks for that, Zoxive, and it's good to see you back with us.