phpadmin - MYSql server not responding

[jmarinac]

I'm plugging away trying to get oscommerce up on a Windows XP Pro Box.

 

I need to create a shell database so that I can coninue with the installation - so, I am trying to install phpadmin to do the dba stuff.

 

I'm trying to use phpMyAdmin-2.6.4-pl2 on a Windows XP Pro box with MySql 4.1.14 and php 4.4.0.

 

Whenever I bring up the index.php page, I get the error - "MySQL error - the server is not responding".

 

I am able to run the MySQL administrator just fine to set usernames/passwords, etc - the MySQL server is responding just fine to this app.

 

I am also able to start running oscommerce, and it indicates that it is connecting to the MySQL server just fine also. However, it is apparently waiting for me to create a database before it can continue.

 

Below is the configuration file that I am using with phpadmin.

 

I use the same username and password in my configuration file as I use to successfully log in to MySQL administrator.

 

One thing that is out of the ordinary - I had to include the statement:

 

old-passwords = 1

 

in my My.ini file because there is an apparent incompatibility between client and server password authentication.

 

Any suggestions would be greatly appreciated.

 

 

Thank you

 

* 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'] = 'JWM-XP'; // MySQL hostname or IP address

$cfg['Servers'][$i]['port'] = '3303'; // 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'] = 'password'; // access to the "mysql/user"

// and "mysql/db" tables).

// The controluser is also

// used for all relational

// features (pmadb)

$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?

$cfg['Servers'][$i]['user'] = 'root'; // MySQL user

$cfg['Servers'][$i]['password'] = 'password'; // MySQL password (only needed

[♥Vger]

You do need to create a blank database for the install to work. Instead of installing individual modules you would have been better off downloading and installing an all-in-one package called XAMPP (http://www.apachefriends.org/en). It has an Apache Web Server, php 4 and 5 (switchable), phpMyAdmin. MySQL, Mercury Mail Server, FileZilla, Open SSL - the works.

 

I'd advise you to uninstall what you have and install XAMPP instead.

 

Vger

[jmarinac]

Thanks for your quick response! That's exactly what I'm going to do. Installing one piece at a time is resulting in fixing this and breaking that trying to figure out what works with what.

 

Thanks again!

 

 

You do need to create a blank database for the install to work. Instead of installing individual modules you would have been better off downloading and installing an all-in-one package called XAMPP (http://www.apachefriends.org/en). It has an Apache Web Server, php 4 and 5 (switchable), phpMyAdmin. MySQL, Mercury Mail Server, FileZilla, Open SSL - the works.

 

I'd advise you to uninstall what you have and install XAMPP instead.

 

Vger