Mysql connexion problems with ServerName localhost and all soft included phpmyadmin

Hello,

I use Mysql installed from Easyphp package (with APACHE and Php) since six year without difficulties on windows (I had more at a time on a server for an intra-net IIS and APACHE on another port for on the same computer, a pop and imap server etc...)

I had to install the last version 5.3.2 of easyphp with
windows XP SP3
Easyphp 5.3.2 : Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8k SVN/1.6.6 PHP/5.3.2
Mysql Version du client MySQL: mysqlnd 5.0.7-dev

The problem seams so simple.

Context:
1- Configs
1- for APACHE ServerName localhost ,
2- Mysql (my.ini) host = localhost,
3- Phpmyadmin(config.inc.php) host is localhost ->
$cfg['Servers'][$i]['host'] = 'localhost';

2- my HOSTS file defines : 127.0.0.1 localhost

3- the softs : Joomla, Tikiwiki etc... have a host defined as localhost

4- the mysql/data are in a separate disk from system (data/mysql and data/phpmyadmin are in this special directory. In my.ini datadir="D:/MysqlData_E532/"

The problem is that there is no possibility to open mysql (start ok) from any soft, Phpmyadmin too.
It seem that the resolution of 127.0.0.1=localhost don't occurs in a normal way.

If I change the host of phpmyadmin to 127.0.0.1, I am successful in accessing phpmyadmin (the servername shown is then 127.0.0.1).
As phpmyadmin host is localhost, Easyphp link for phpmyadmin is anyway [127.0.0.1] but if $cfg['Servers'][$i]['host'] = 'localhost';
the connection don't occurs if
$cfg['Servers'][$i]['host'] = '127.0.0.1'; The link is OK.

It is completely excluded and impossible to change any host= "localhost" configuration.

I have been till now for a few day's unable to understand what happens and feel unable to find a solution.

Thank's for your help

trebly

> 2- my HOSTS file defines : 127.0.0.1 localhost

ipconfig /flushdns to flush dns cache

Check ping localhost is resolved to IPv4 loopback addresse (127.0.0.1).

Is IPv6 enabled ??

Hello,

I answer before the quote

Thierry Wrote:

-------------------------------------------------------
YES the lonely ref> > 2- my HOSTS file defines : 127.0.0.1 localhost
>
YES tested > ipconfig /flushdns to flush dns cache
>
YES Ok 0ms for ipv4 and ipv6 > Check ping localhost is resolved to IPv4 loopback
> addresse (127.0.0.1).
>
YES bridge to ipv4 > Is IPv6 enabled ??

Complementary elements, if not yet induced -------------------------------------------------
1- the problem seems to occur only for http (firewall ? is XP SP3 I think well set up, I had to define programs and open various options)

2- the call to "easyphp administration" calls 127.0.0.1/home, this displays the easyphp local home page (if called as localhost/home I get the same page but not same auto-zoom).

3- From easyphp home page the link to phpmyadmin is 127.0.0.1/home/mysql is not solved but if I changes in config.inc.php $cfg['Servers'][$i]['host'] = 'localhost'; by $cfg['Servers'][$i]['host'] = '127.0.0.1'; I reaches immediately phpmyadmin on the right directory (the d:/MysqlData_E532 defined in my.ini)

4- from localhost or 127.0.0.1 which reaches the primary easyphp access with links : Name Last modified Size Description
there are no corresponding accesses to these links ( reopen the same in a new tabler)

I still don't find what happens ?

trebly

Complements added at 23h55, Paris :
sorry for the 40th persons who have red the message since I publish it. reading again all messages on various forum, I found that, since the beginning, I forgot some important facts :

With the same parameters the 3.3.0 functions normally.

I could never make the 3.3.1 neither now the 3.3.2 version to function normally with these parameters (it seems to function since you have not set the password and the privileges attributes, the datadir don't changes anything) but after it's impossible to find a solution with localhost for both phpmyadmin and all others applications (which runs with access password to mysql). Just phpmyadmin if host=127.0.0.1.

i don't understand what can be the relation with the password to mysql and localhost solving !!!

I need to go up to 3.2.2 because of a lot of problem of installations and running of tikiwiki 4.1 and 3.3.0.
I found a lot of problems and ways to define classes (abstract, implement) in the pdo context. At the end tikiwiki have been upgraded to 4.2 while php to 5.3.2. So my developments, test, and translations to French have no more interest and I can't participate for development with tiki team.

Till I have not been successful in the upgrades (tiki 4.2 with php 5.3.2) the test are not of any interest because it is impossible to know if the problems I found remain.



Edited 1 time(s). Last edit at 03/23/2010 11:59PM by Trebly.

Trebly Wrote:
-------------------------------------------------------
> Hello,
>
> I answer before the quote
>
> Thierry Wrote:
>
> --------------------------------------------------
> -----
> YES the lonely ref> > 2- my HOSTS file defines :
> 127.0.0.1 localhost
> >
> YES tested > ipconfig /flushdns to flush dns
> cache
> >
> YES Ok 0ms for ipv4 and ipv6 > Check ping
> localhost is resolved to IPv4 loopback
> > addresse (127.0.0.1).
> >
> YES bridge to ipv4 > Is IPv6 enabled ??
>
> Complementary elements, if not yet induced
> -------------------------------------------------
> 1- the problem seems to occur only for http
> (firewall ? is XP SP3 I think well set up, I had
> to define programs and open various options)
>
> 2- the call to "easyphp administration" calls
> 127.0.0.1/home, this displays the easyphp local
> home page (if called as localhost/home I get the
> same page but not same auto-zoom).
>
> 3- From easyphp home page the link to phpmyadmin
> is 127.0.0.1/home/mysql is not solved but if I
> changes in config.inc.php
> $cfg['Servers'][$i]['host'] = 'localhost'; by
> $cfg['Servers'][$i]['host'] = '127.0.0.1'; I
> reaches immediately phpmyadmin on the right
> directory (the d:/MysqlData_E532 defined in
> my.ini)
>
> 4- from localhost or 127.0.0.1 which reaches the
> primary easyphp access with links : Name Last
> modified Size Description
> there are no corresponding accesses to these links
> ( reopen the same in a new tabler)
>
> I still don't find what happens ?
>
> trebly
>
> Complements added at 23h55, Paris :
> sorry for the 40th persons who have red the
> message since I publish it. reading again all
> messages on various forum, I found that, since the
> beginning, I forgot some important facts :
>
> With the same parameters the 3.3.0 functions
> normally.
>
> I could never make the 3.3.1 neither now the
> 3.3.2 version to function normally with these
> parameters (it seems to function since you have
> not set the password and the privileges
> attributes, the datadir don't changes anything)
> but after it's impossible to find a solution with
> localhost for both phpmyadmin and all others
> applications (which runs with access password to
> mysql). Just phpmyadmin if host=127.0.0.1.
>
> i don't understand what can be the relation with
> the password to mysql and localhost solving !!!
>
> I need to go up to 3.2.2 because of a lot of
> problem of installations and running of tikiwiki
> 4.1 and 3.3.0.
> I found a lot of problems and ways to define
> classes (abstract, implement) in the pdo context.
> At the end tikiwiki have been upgraded to 4.2
> while php to 5.3.2. So my developments, test, and
> translations to French have no more interest and I
> can't participate for development with tiki team.
>
> Till I have not been successful in the upgrades
> (tiki 4.2 with php 5.3.2) the test are not of any
> interest because it is impossible to know if the
> problems I found remain.