[php] Phpmyadmin wil niet werken

[AtlonXP1800]

Ik heb net een server geinstalleerd met apache 2.2, php5 en mysql.
Om de mysql database te beheren wil ik phpmyadmin gebruiken. Op verschillende servers heb ik phpmyadmin al goed werken, en ik dacht dan ook makkelijk de config daarvan over te kunnen nemen.

Helaas wil dat niet werken, wat ik ook probeer, phpmyadmin blijft dit melden:

Welkom op phpMyAdmin

Probably reason of this is that you did not create configuration file. You might want to use setup script to create one.
Fout

MySQL retourneerde: Documentatie
#1045 - Access denied for user 'root'@'localhost' (using password: NO)

Mijn config file ziet er als volgt uit:

code:

<?php
/* $Id: config.inc.php,v 2.53 2005/06/07 16:44:39 lem9 Exp $ */
// vim: expandtab sw=4 ts=4 sts=4:

/**
 * phpMyAdmin Configuration File
 *
 * All directives are explained in Documentation.html
 */


/**
 * Sets the php error reporting - Please do not change this line!
 */
if (!isset($old_error_reporting)) {
    error_reporting(E_ALL);
    @ini_set('display_errors', '1');
}


/**
 * Your phpMyAdmin url
 *
 * Complete the variable below with the full url ie
 *    http://www.your_web.net/path_to_your_phpMyAdmin_directory/
 *
 * It must contain characters that are valid for a URL, and the path is
 * case sensitive on some Web servers, for example Unix-based servers.
 *
 * In most cases you can leave this variable empty, as the correct value
 * will be detected automatically. However, we recommend that you do
 * test to see that the auto-detection code works in your system. A good
 * test is to browse a table, then edit a row and save it.  There will be
 * an error message if phpMyAdmin cannot auto-detect the correct value.
 *
 * If the auto-detection code does work properly, you can set to TRUE the
 * $cfg['PmaAbsoluteUri_DisableWarning'] variable below.
 */
$cfg['PmaAbsoluteUri'] = 'http://192.168.0.121/phpmyadmin/';


/**
 * Disable the default warning about $cfg['PmaAbsoluteUri'] not being set
 * You should use this if and ONLY if the PmaAbsoluteUri auto-detection
 * works perfectly.
 */
$cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;

/**
 * Disable the default warning that is displayed on the DB Details Structure page if
 * any of the required Tables for the relationfeatures could not be found
 */
$cfg['PmaNoRelation_DisableWarning']  = TRUE;

/**
 * The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
 * at least one server configuration uses 'cookie' auth_type, enter here a
 * passphrase that will be used by blowfish. The maximum length seems to be 46
 * characters.
 */
$cfg['blowfish_secret'] = 'b916828234e557webe542b340efd53459';

/**
 * Server(s) configuration
 */
$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++;
$cfg['Servers'][$i]['host']          = '192.168.0.121'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port']          = '3306';          // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension']     = 'mysql';     // The php MySQL extension to use ('mysql' or 'mysqli')
$cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
                                                    // (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser']   = 'root';          // MySQL control user settings
                                                    // (this user must have read-only
$cfg['Servers'][$i]['controlpass']   = 'pass';          // access to the "mysql/user"
                                                    // and "mysql/db" tables).
                                                    // The controluser is also
                                                    // used for all relational
                                                    // features (pmadb)
$cfg['Servers'][$i]['auth_type']     = 'http';    // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user']          = 'root';      // MySQL user
$cfg['Servers'][$i]['password']      = 'pass';          // MySQL password (only needed
                                                    // with 'config' auth_type)
$cfg['Servers'][$i]['only_db']       = '';          // If set to a db-name, only
                                                    // this db is displayed in left frame
                                                    // It may also be an array of db-names, where sorting order is relevant.
$cfg['Servers'][$i]['verbose']       = '';          // Verbose name for this host - leave blank to show the hostname

$cfg['Servers'][$i]['pmadb']         = '';          // Database used for Relation, Bookmark and PDF Features
                                                    // (see scripts/create_tables.sql)
                                                    //   - leave blank for no support
                                                    //     DEFAULT: 'phpmyadmin'
$cfg['Servers'][$i]['bookmarktable'] = '';          // Bookmark table
                                                    //   - leave blank for no bookmark support
                                                    //     DEFAULT: 'pma_bookmark'
$cfg['Servers'][$i]['relation']      = '';          // table to describe the relation between links (see doc)
                                                    //   - leave blank for no relation-links support
                                                    //     DEFAULT: 'pma_relation'
$cfg['Servers'][$i]['table_info']    = '';          // table to describe the display fields
                                                    //   - leave blank for no display fields support
                                                    //     DEFAULT: 'pma_table_info'
$cfg['Servers'][$i]['table_coords']  = '';          // table to describe the tables position for the PDF schema
                                                    //   - leave blank for no PDF schema support
                                                    //     DEFAULT: 'pma_table_coords'
$cfg['Servers'][$i]['pdf_pages']     = '';          // table to describe pages of relationpdf
                                                    //   - leave blank if you don't want to use this
                                                    //     DEFAULT: 'pma_pdf_pages'
$cfg['Servers'][$i]['column_info']   = '';          // table to store column information
                                                    //   - leave blank for no column comments/mime types
                                                    //     DEFAULT: 'pma_column_info'
$cfg['Servers'][$i]['history']       = '';          // table to store SQL history
                                                    //   - leave blank for no SQL query history
                                                    //     DEFAULT: 'pma_history'
$cfg['Servers'][$i]['verbose_check'] = TRUE;        // set to FALSE if you know that your pma_* tables
                                                    // are up to date. This prevents compatibility
                                                    // checks and thereby increases performance.
$cfg['Servers'][$i]['AllowRoot']     = TRUE;        // whether to allow root login
$cfg['Servers'][$i]['AllowDeny']['order']           // Host authentication order, leave blank to not use
                                     = '';
$cfg['Servers'][$i]['AllowDeny']['rules']           // Host authentication rules, leave blank for defaults
                                     = array();




$cfg['Servers'][$i]['AllowDeny']['order']
                                       = '';
$cfg['Servers'][$i]['AllowDeny']['rules']
                                       = array();

Ongetwijfeld is het iets heel simpels waar ik gewoon overheen kijk... Iemand enig idee waar de fout zit?

[Onbekend]

Heb je wel de benodigde toegangsrechten voor de mappen op de server ingesteld?

[Verwijderd]

Het password is gedefinieerd in de config als 'pass' en in je OP stond dit:

code:

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

Misschien het eens mét password proberen?

[r0b]

Maak verbinding met 'localhost' ipv 192.168.0.121?

_{Misschien ben ik gek hoor, maar ik zie wel localhost terugkomen in je foutmelding en niet in je config}

Verwijderd schreef op zondag 02 november 2008 @ 14:30:
Het password is gedefinieerd in de config als 'pass' en in je OP stond dit:

code:

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

Misschien het eens mét password proberen?

Oh, en zet authentication type eens op 'config' ipv 'http'?

[ Voor 54% gewijzigd door r0b op 02-11-2008 14:32 ]

[AtlonXP1800]

Verwijderd schreef op zondag 02 november 2008 @ 14:30:
Het password is gedefinieerd in de config als 'pass' en in je OP stond dit:

code:

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

Misschien het eens mét password proberen?

Daar lijkt mij ook het probleem te zitten, kennelijk probeert phpmyadmin te connecten zonder het password te gebruiken (die wel in de config file zit)

[AtlonXP1800]

Onbekend schreef op zondag 02 november 2008 @ 14:27:
Heb je wel de benodigde toegangsrechten voor de mappen op de server ingesteld?

ja, die staan goed

r0b schreef op zondag 02 november 2008 @ 14:31:
Maak verbinding met 'localhost' ipv 192.168.0.121?

_{Misschien ben ik gek hoor, maar ik zie wel localhost terugkomen in je foutmelding en niet in je config}


[...]

Oh, en zet authentication type eens op 'config' ipv 'http'?

Ik had er eerst localhost in staan, dat gaf dezelfde melding
Ook veranderen van het authentication type had geen effect.

Ik kan trouwens met andere tools, zoals mysql administrator prima connecten naar de database server

[ Voor 6% gewijzigd door AtlonXP1800 op 02-11-2008 14:39 ]

[Borizz]

AtlonXP1800 schreef op zondag 02 november 2008 @ 14:24:

Helaas wil dat niet werken, wat ik ook probeer, phpmyadmin blijft dit melden:

[...]

Wat heb je dan zoal geprobeerd dan? Weet je bijvoorbeeld al zeker dat de config file wel wordt ingelezen?