Phpmyadmin is 404 file not found

CSU_Bill · March 8, 2011, 2:07pm

Sorry for the long post, but I want to provide enough detail for any help I get. I have been on a SERIOUS learning event with this project.

I installed Ubuntu 10.10 desktop. Then I installed MySQL, Apache2, PHP5, many PHP5 modules, and everything tested okay (I get the Apache2 index.html, and info.php).

Then I installed PHPMyAdmin. I did this following the instructions at Installing Apache2 With PHP5 And MySQL Support On Ubuntu 10.10 (LAMP) | HowtoForge - Linux Howtos and Tutorials and made the mistake of selecting yes at using dbconfig-common. Getting frustated, I reloaded everything starting with a new load of Ubuntu. (I later learned about “apt-get --purge remove xxxxx”)

This time, I installed PHPMyAdmin following the instructions and still it did not work. I removed it with the apt-get --purge remove phpmtadmin and shutdown my computer. Later, I did another attempt. Each time I try, it appears to install, but attempting to load it does not work at http://192.168.1.102/phpmyadmin/ (I check my router each time to verify the IP address). All I get is a 404 file not found from my browser. I have looked at /var/www/ and all I find is the index.html and info.php files.

What should I do next? I have PHPMyAdmin running on a XAMPP install on another (Windows) machine, and wonder if I could just copy the files from my www folder on that machine? Should I start at the beginning again (I may soon be able to do this without using the help files)?

SpacePhoenix · March 8, 2011, 6:51pm

Have you tried http://localhost/phpmyadmin to access PHPMyAdmin?

CSU_Bill · March 8, 2011, 7:29pm

I thought localhost was a Windows thing. I will give localhost a try when I get home.

However, should there be a phpmyadmin file in my www folder? Currently there is nothing in my www folder other than the Apache2 index.html and info.php.

CSU_Bill · March 10, 2011, 1:43pm

localhost acted exactly as did using my router address.

I did get phpmyadmin login screen to showup by creating a link using

 ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf.d/phpmyadmin.conf

The problem now is that I get an error message of:

#1045 Cannot log in to the MySQL server

Do I need to do something to MySQL to allow phpmyadmin to connect, or do I need to do something to phpmyadmin to get it to login to mysql correctly?

rpkamp · March 10, 2011, 1:44pm

PMA has a config file. You need to fill in the database credentials in there:

config.inc.php - PmaWiki

CSU_Bill · March 12, 2011, 2:05am

I took a look in config.inc.php but did not see anything I recognised as credentials.

I did see a line to allow logging in with no password. Since this is a local set-up that is not being accessed from the Internet, would that fix my problem? Would I be creating a problem for myself doing that?

SpacePhoenix · March 12, 2011, 7:41am

The config file should look something like:

<?php

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'mysql_user'; // <-- MySQL user set here
$cfg['Servers'][$i]['password'] = 'mysql_password'; // <-- MySQL password set here
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* End of servers configuration */

$cfg['DefaultLang'] = 'en-utf-8';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>

You need to give valid values for the MySQL username and password. Don’t forget to reboot if you have made any changes to the file (for the changes to take effect).

rpkamp · March 12, 2011, 10:58am

It’s PHP, you don’t need to reboot. The changes will take effect immediately

CSU_Bill · March 12, 2011, 6:44pm

Getting closer every day.

This is what my config.inc.php reads now:



<?php
/**
 * Debian local configuration file
 *
 * This file overrides the settings made by phpMyAdmin interactive setup
 * utility.
 *
 * For example configuration see /usr/share/doc/phpmyadmin/examples/config.defa$
 *
 * NOTE: do not add security sensitive data to this file (like passwords)
 * unless you really know what you're doing. If you do, any user that can
 * run PHP or CGI on your webserver will be able to read them. If you still
 * want to do this, make sure to properly secure the access to this file
 * (also on the filesystem level).
 */

/**
 * Server(s) configuration
 */
$i = 0;
// The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use $cfg['$
// You can disable a server config entry by setting host to ''.
$i++;

/**
 * Read configuration from dbconfig-common
 * You can regenerate it using: dpkg-reconfigure -plow phpmyadmin
 */
if (is_readable('/etc/phpmyadmin/config-db.php')) {
    require('/etc/phpmyadmin/config-db.php');
}

/* Configure according to dbconfig-common if enabled */
if (!empty($dbname)) {
    /* Authentication type */
    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    /* Server parameters */
    if (empty($dbserver)) $dbserver = 'localhost';
    $cfg['Servers'][$i]['host'] = $dbserver;

    if (!empty($dbport)) {
        $cfg['Servers'][$i]['connect_type'] = 'tcp';
        $cfg['Servers'][$i]['port'] = $dbport;
    }
    //$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'] = $dbuser;
    $cfg['Servers'][$i]['controlpass'] = $dbpass;
    /* Optional: Advanced phpMyAdmin features */
    $cfg['Servers'][$i]['pmadb'] = $dbname;
    $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';
    $cfg['Servers'][$i]['tracking'] = 'pma_tracking';

    /* Uncomment the following to enable logging in to passwordless accounts,
     * after taking note of the associated security risks. */
    /* $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;*/

    /* Advance to next server for rest of config */
    $i++;
}

/* Authentication type */
//$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
    $cfg['Servers'][$i]['controluser'] = $dbuser;
    $cfg['Servers'][$i]['controlpass'] = $dbpass;
    /* Optional: Advanced phpMyAdmin features */
    $cfg['Servers'][$i]['pmadb'] = $dbname;
    $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';
    $cfg['Servers'][$i]['tracking'] = 'pma_tracking';

    /* Uncomment the following to enable logging in to passwordless accounts,
     * after taking note of the associated security risks. */
    /* $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;*/

    /* Advance to next server for rest of config */
    $i++;
}

/* Authentication type */
//$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
    $cfg['Servers'][$i]['controluser'] = $dbuser;
    $cfg['Servers'][$i]['controlpass'] = $dbpass;
    /* Optional: Advanced phpMyAdmin features */
    $cfg['Servers'][$i]['pmadb'] = $dbname;
    $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';
    $cfg['Servers'][$i]['tracking'] = 'pma_tracking';

    /* Uncomment the following to enable logging in to passwordless accounts,
     * after taking note of the associated security risks. */
    /* $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;*/

    /* Advance to next server for rest of config */
    $i++;
}

/* Authentication type */
//$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* 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'] = 'mysql';
/* 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';
/* Uncomment the following to enable logging in to passwordless accounts,
 * after taking note of the associated security risks. */
// $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

/*
 * End of servers configuration
 */

/*
 * Directories for saving/loading files from server
 */
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';


/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['root'] = 'mysql_user'; // <-- MySQL user set here
$cfg['Servers'][$i]['password'] = 'mysql_password'; // <-- MySQL password set here
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* End of servers configuration */
$cfg['DefaultLang'] = 'en-utf-8';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>

I did a copy and past, and changed the user to root and changed the password in the operational file to the MySQL password for the root user.

I am still getting an error, but it has changed. Now the error reads:

#1045 - Access denied for user ‘root’@‘localhost’ (using password: NO)