Hey,

I'm setting up a server... and installed Apache 2.2, PHP5 and mySQL 5.0. I know the Apache and PHP parts i got right... by the mySQL portion is where i'm running into trouble.

I tried to install phpMyAdmin 2.8.2.. but i can't seem to connect to mySQL when i get to the step where i run http://localhost/phpMyAdmin-2.8.2/index.php

The error reads as follows:

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
Error

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

It also displays a large amount of php code above that message. I tried to configure config.inc.php .. but obviously did it wrong.

I was editing this portion of the code:

show_config_form(array(
            array('Server hostname', '----', 'Hostname where MySQL server is running'),
            array('Server port', '3306', 'Port on which MySQL server is listening, leave empty if don\'t know'),
            array('Server socket', 'socket', 'Socket on which MySQL server is listening, leave empty if don\'t know'),
            array('Connection type', 'tcp', 'How to connect to server, keep tcp if don\'t know', array('tcp', 'socket')),
            array('PHP extension to use', 'mysql', 'What PHP extension to use, use mysqli if supported', array('mysql', 'mysqli')),
            array('Compress connection', 'compress', 'Whether to compress connection to MySQL server', FALSE),
            array('Authentication type', 'config', 'Authentication method to use', array('cookie', 'http', 'config')),
            array('User for config auth', 'root', 'Leave empty if not using config auth'),
            array('Password for config auth', '----', 'Leave empty if not using config auth', 'rosebud'),
            array('Only database to show', 'only_db', 'Limit listing of databases in left frame to this one'),
            array('Verbose name of this server', 'verbose', 'Name to display in server selection'),
            array('phpMyAdmin control user', 'controluser', 'User which phpMyAdmin can use for various actions'),
            array('phpMyAdmin control user password', 'controlpass', 'Password for user which phpMyAdmin can use for various actions', 'password'),
            array('phpMyAdmin database for advanced features', 'pmadb', 'phpMyAdmin will allow much more when you enable this. Table names are filled in automatically.'),
            ),
            'Configure server',
            ($number === FALSE) ? 'Enter new server connection parameters.' : 'Editing server ' . get_server_name($defaults, $number),
            $defaults, $number === FALSE ? 'Add' : '', 'Servers_');

(the dashed lines were filled in with my server info/user info

Does anyone have any ideas of what i'm doing wrong?

I'm fairly positive mySQL is fine.. because i was able to create a database in there and all that... i just haven't had any success connecting to it (i also tried to install a php search called Sphider).

What do you use to login into mysql from the command or telnet prompt?

You might need to edit your db/table: mysql.user

I actually was able to resolve the issue.

Turns out i was configuring the wrong file.... i somehow got mixed up when creating the default file.

Thanks for your help though.