Apache Friends Support Forum

the question is that phpmyadmin has stopped:

When I type http://localhost/phpmyadmin and hit Enter, the page stays in "connecting..." "waiting localhost..." it remains there... with the content blank,
However the localhost is working fine...

MySQL database DEACTIVATED
PHP ACTIVATED
Perl ACTIVATED
Common Gateway Interface (CGI) ACTIVATED
Server Side Includes (SSI) ACTIVATED
PHP extension »eAccelerator« DEACTIVATED ver FAQ
PHP extension »OCI8/Oracle« DEACTIVATED

If I type 127.0.0.1/phpmyadmin, it ask me the password... I enter it, and it remains there... with the content blank,

any idea?
Ubuntu 11.04 / XAMPP 1.7.7

Just a guess that may help speed up a solution until a Linux guru pops in, find and edit the Linux equivalent of the Windows MySQL configuration file perhaps my.conf (my.ini or my.cnf) and find a similar following line uncomment it.

#bind-address = 127.0.0.1
So it looks like this:
bind-address = 127.0.0.1

Save the file and you may have to restart MySQL.

I don't have a Linux box to test this so please provide feedback if it helps.

This fix was first discovered in the Windows version.

Good luck

hi! thank you for trying... I found the file my.cnf under /opt/lampp/etc
However...
It does NOT has the line you are saying: (#bind-address="127.0.0.1")

any other idea?

[edit]
In the same folder, I found the file php.ini
However...
It neither has that line of code
[edit]

Try adding it at the end of the first section like so

Code: Select all

bind-address = 127.0.0.1
#
# * Fine Tuning
#

You have to get MySQL ACTIVATED or phpMyAdmin won't start.

Is MySQL running?

Done. Xampp restarted, and the same results

Yes, it's running... I have access to all my wordpress sites

my.cnf
# Here follows entries for some specific programs

# The MySQL server
[mysqld]
user = nobody
port = 3306
socket = /opt/lampp/var/mysql/mysql.sock
skip-external-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
bind-address = 127.0.0.1

# Where do all the plugins live


superichy@ubuntu-pc:~$ sudo /opt/lampp/lampp restart
Stopping XAMPP for Linux 1.7.7...
XAMPP: Stopping Apache with SSL...
XAMPP: Stopping MySQL...
XAMPP: Stopping ProFTPD...
XAMPP stopped.
Starting XAMPP for Linux 1.7.7...
XAMPP: Starting Apache with SSL (and PHP5)...
XAMPP: Starting MySQL...
XAMPP: Starting ProFTPD...
XAMPP for Linux started.
superichy@ubuntu-pc:~$

So my guess was not the solution but worth a try.

You may have to wait a while for someone who has a Linux box to try and help you.

Good luck.

in FF it remains connecting... waiting localhost...
in Chrome, it asks me my user and password; when I enter them, it asks me again the same and again and again and again...

In the previous XAMPP version, phpmyadmin was working fine...

ok, thank you anyway...
waiting...

If you used the 'Security script' -

Then LAMPP is first asking for your LAMPP username -- which BTW is lampp -- and the pw from the Security Page setup, THEN you will get the 'regular' phpMyAdmin root login.

Good Luck, confused me too

-hi Jon, with "security script", are you referring (sudo /opt/lampp/lampp security) to?

Yes I used, then I enter to http://localhost with lampp, admin (the password I chose). Finally I don't have access to http://localhost/phpmyadmin...

any other idea?

thank you

if you can't use phpmyadmin anymore first try to change the auth type in your phpmyadmin config.inc.php

search for

Code: Select all

$cfg['Servers'][$i]['auth_type'] = 'config';

change to

Code: Select all

$cfg['Servers'][$i]['auth_type'] = 'cookie';

clear your browser cache and try to connect with phpmyadmin again. You should be asked for username and password now.
try to login with root as user and your password choosen in your xampp security script.

done.
In this line,
$cfg['Servers'][$i]['auth_type'] = 'config';
I had 'http';
I changed to 'cookie';

then I followed the steps you said.... and the same results:
I'm not able to login. It asks the login autentication data once and again. I tried all the possible combinations, however... I have to hit "Cancel", and I have:

¡Autentificación requerida!

El servidor no puede certificar que usted este autorizado para acceder al enlace "/phpmyadmin/". Usted pudo suministrar información errónea accidentalmente (ejem. una contraseña inválida) o, el navegador no sabe como suministrar la información requerida.

En caso de que a usted le este permitido el uso del documento requerido, le solicitamos de la manera más atenta que por favor vuelva a intentar la operación suministrando nuevamente su identificador y su contraseña.

Por favor contacte con el webmaster en caso de que usted crea que existe un error en el servidor.
Error 401
localhost
lun 26 sep 2011 11:09:22 ART
Apache/2.2.21 (Unix) DAV/2 mod_ssl/2.2.21 OpenSSL/1.0.0c PHP/5.3.8 mod_apreq2-20090110/2.7.1 mod_perl/2.0.5 Perl/v5.10.1

Auth type http is okay too. It should be cookie or http. Both work nearly the same (http uses htaccess authentification, cookie serverscript based).

So, if that don't work and you can't login to your mysql root account anymore first try three things:
- clear your Browsercache
- use a different browser
- restart your computer

if this don't bring any success, you have just the chance to reset your mysql root user.
- if there is a resetroot script in your xampp (con't know in the current linux version) use this one.
- if not, use the way which is Described [urlhttp://www.howtoforge.com/reset-forgotten-mysql-root-password]here[/url]

Thank you Altrea, solved:

I think the problem was that I'd never restarted mi PC after updating Xampp to 1.7.7 release.
I did it and now I'm able to login and navigate phpmyadmin normally... I saw it has a new interface, very nice,

thanks everybody for your time and dedication,


Richy