mackay6

Okay, so I have set up PHP along with Apache and now MySQL but when I am trying to go in via MySQLAdmin I get this error message that appears. I am looking for a little advice and help, I've done some research into it but cannot find anything else useful so I'll have a bash here hopefully.

Thanks.

P.S. I am new to the forum, so Hello all.

Pizentios

do you have a user named SYSTEM? if so, does he/she need a password to login (most likely yes). if the answer is yes to needing a password, you simply need to make sure your MySQLAdmin is sending a password.

__________________
Profanity is the one language that all programmers understand.

Check out my Blog <---updated Nov 30 2007!

mackay6

Nope, I have no user named System. I actually believe that is supposed to be root@localhost. Why it says System, I am not sure. I am using the config authentication system therefore what files do I need to change to get root to be accepted... if any

mackay6

Perhaps I have to change something in config.inc.php?

Pizentios

yes, probably. this is my config.inc.php

[PHP]
/*
* Generated configuration file
* Generated by: phpMyAdmin 2.8.1 setup script by Michal Ä~LihaÅ~Y <michal@cihar.com>
* Version: $Id: setup.php,v 1.23.2.8.2.2 2006/05/15 07:57:09 nijel Exp $
* Date: Mon, 05 Jun 2006 21:48:14 GMT
*/

/* Servers configuration */
$i = 0;

/* Server localhost (config:root) [1] */
$i++;
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['connect_type'] = 'socket';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'mysql';
$cfg['Servers'][$i]['password'] = 'SomePassword';

/* End of servers configuration */
[/PHP]

__________________
Profanity is the one language that all programmers understand.

Check out my Blog <---updated Nov 30 2007!

Infinite Recursion

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'rootsPW';

at the command line type:

mysql -u root -p

then enter root's password

you should have something like: mysql>

__________________
http://jasonpowers.net

"There are a thousand hacking at the branches of evil to one who is striking at the root."

jsilver608

it looks like the underlying functions that actually connect to your mysql database are not seeing the username and password from your config file. You might want to check path info.

__________________
High Performance PHP
http://www.whenpenguinsattack.com