Xampp server - Joomla mysql cannot connect to localhost

jvnadr

Hello all!

I have a weird issue: I installed xampp server (the latest one , 1.8.2-5). It works fine, all services are up. But, when I restore joomla from an akeeba backup, cannot connect to Mysql via localhost or 127.0.0.1.

I can connect via the ip of my pc (168.192.10.3). Mysql/phpadmin can connect fine to localhost and 127.0.0.1.

The site is also working with localhost / 127.0.0.1. The only thing I cannot connect is Joomla to mysql when I use localhost in the configuration.

The firewall is configured to open the ports, mysql is in default port 3306, my.ini bind section is configured right (bind-address="127.0.0.1" ). Does anybody have an idea about this issue?

Thnks a lot

rds100

Wrong password for the database, or missing database?

Try:

grant all on databasename.* to username@localhost identified by 'password';

flush privileges;

Of course first see the database is there.

jvnadr

@rds100 No, database is working fine. Joomla is working if I set config to hear on my local pc ip (192.168.10.3), but not if I use "localhost" or "127.0.0.1". But phpmyadmin is working with all adresses (my pc ip and localhost). Only Joomla cannot hear to localhost...

rds100

What IP is the mysql server bound to? netstat -an | grep 3306 | grep LISTEN

rds100

Also maybe database access rights were granted only to [email protected] and not to username@localhost. Try granting to username@localhost too.

jvnadr

It is installed on windows. Mysql is bounded to 127.0.0.1 . Myphpadmin is working with localhost and I can configure databases thru this address.

jvnadr

@rds100 No, privileges are granted to localhost

agoldenberg

Try checking your hosts file. Maybe localhost doesn't have an entry for 127.0.0.1