PHPMyAdmin problem

daisukey

I'm getting "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" error when i try to connect to its index.php then I cannot find the "config.inc.php' in the same directory...

Any help appreciated. _b

[edit]
version of phpmyadmin: phpMyAdmin-2.7.0-pl2.zip

bradgrafelman

Well, that's not very good. Maybe that's the problem? 😉

Do you see any files that have the word "config" in them out in the rood of your PHPMyAdmin installation?

daisukey

hi bradgrafelman again, i solved my first problem i think..
I downloaded "phpMyAdmin 2.2.7-pl1"
@ http://www.phpmyadmin.net/home_page/downloads.php#2.2.7-pl1 the archive contained the "config.ini.php" file so i edited the file.

Then I came across another problem "cannot load MySQL extension..." so I uncommented ";extension=php_mysql.dll" to "extension=php_mysql.dll".

Now i'm having this error "The $cfgPmaAbsoluteUri directive MUST be set in your configuration file!".

daisukey

in config.ini.php file, is this correct?
$cfgPmaAbsoluteUri = 'http://localhost/phpMyAdmin/';

now having this error :/
Error

MySQL said:

Access denied for user 'admin'@'localhost' (using password: YES)

bradgrafelman

What is the first value of $cfg['Servers'][$i]['auth_type'] ? (Towards the top... possibly near line 85, not sure)

daisukey

around line 40

$cfgServers[$i]['auth_type']     = 'config';    // Authentication method (config, http or cookie based)?
$cfgServers[$i]['user']          = 'admin';      // MySQL user
$cfgServers[$i]['password']      = 'admin';

bradgrafelman

So there's where the problem is. It's saying that it's forcing PHPMyAdmin to login to MySQL using that user/pass combo.

My suggestion would be to change the 'auth_type' to 'cookie', and look for $cfg['blowfish_secret']. You can read the commenting above it, but basically, all you need to do is hardcode a secret passphrase to be used for encryption purposes.

daisukey

thanks but can't seem to find "blowfish_secret" command... but anyway i see a login page so i typed in my user/pass n clicked on 'login' button. but nothing happens.

[edit]
anyway i added a line for blowfish command.

// You can disable a server config entry by setting host to ''.
$i++;
$cfg['blowfish_secret'] = 'test;

$cfgServers[$i]['host']          = 'localhost'; // MySQL hostname
$cfgServers[$i]['port']          = '';          // MySQL port - leave blank for default port
$cfgServers[$i]['socket']        = '';

is this okay? still login page not working..

bradgrafelman

May I ask why you're using this version? Do you not meet the criteria for PHP/MySQL requirements?

EDIT: Is it possible that we could have a link to see the login page? If you don't feel comfortable sharing it with the world, you can PM it to me instead.

EDIT2: Forgot to mention.. you can remove the blowfish line. Apparently, this early version of PMA didn't use blowfish in the cookies...

daisukey

i got the latest php/mysql ... n the Latest stable version "phpMyAdmin 2.7.0-pl2" didn't have config.ini.php so i decided to use the Latest version phpMyAdmin 2.2.7-pl1 which has been tested with PHP < 4.1.0 and MySQL < 3.23.32.

bradgrafelman

Eh, let's get the latest build, 2.7.0 and I'll help you set it up.

I'm downloading it at the moment to take a look at it, will let you know soon.

EDIT: Completely delete the old version, and unzip 2.7.0 again. Rename the file "config.default.php" to "config.inc.php" and set some things up.

You should just need to edit these three things for starters:

$cfg['PmaAbsoluteUri'], $cfg['blowfish_secret'], and $cfg['Servers'][$i]['auth_type']

daisukey

thank you!!! im following the instruction...

got this error,
[edit]
Warning: include(./config.default.php) [function.include]: failed to open stream: No such file or directory in c:\webs\test\phpMyAdmin\libraries\common.lib.php on line 84

Warning: include() [function.include]: Failed opening './config.default.php' for inclusion (include_path='.;C:\php5\pear') in c:\webs\test\phpMyAdmin\libraries\common.lib.php on line 84

bradgrafelman

Woopsie! Try copying the file to that name, so you have 2 identical files? config.default.php and config.inc.php .

daisukey

got 2 copies,

now i see a login page.

"Welcome to phpMyAdmin 2.7.0-pl2
Language:
Error
#1045 - Access denied for user 'admin'@'localhost' (using password: YES)"

bradgrafelman

Did it as you to login via a login form?

daisukey

yep, isee a login page where i put in user/pass.

thanks for you support once again.

bradgrafelman

So did it work now?

daisukey

nup comes up with this error "Error
#1045 - Access denied for user 'admin'@'localhost' (using password: YES)".

(ps)we need a chat room 😉

bradgrafelman

Have you ever configured MySQL before? If not, MySQL, by default, has a "master" username of 'root' (and probably no password).

daisukey

when i installed mysql i put my user/pass during the installation.

i also was able to create DBs via SQlite.