Joomla! Forum - community, help and support

Howdy,

J!1.6 Stable/Win 7 Home Premium/Local

Error:
Could not connect to the database. Connector returned number: Unable to connect to the Database: Could not connect to MySQL.

This is as far as I can get with my trusty XAMPP 1.7.3 within which I have successfully installed and run literally hundreds of J! (among others) sites, including J!1.6RC1.

Tried creating the database first (didn't have to with J!1.6RC1), used 127.0.0.1 instead of localhost, tried MySQL instead of MySQLi (default choice). All the connection items are as they should be. Tried another install of J!1.6RC1 and it went just fine; no issues. Any ideas?

Cheers!
Lyle

Im also facing the same problem. I have put it the right host (localhost), username and password and MySQL but no matter how I try- it still wont connect.

infact when I access the site with the domain url ie www.domain.com or www.domain.com/installation, I get the message:

This website is temporarily unavailable, please try again later.

but when I use the IP address alternative, it does take me through the installation till I get to the database section where it says it cannot connect

The permissions are all set correctly. Infact Iv installed and configured almost 400 joomla sites before- just that this is my first 1.6 installation unless if there is a different way of doing it.

I m using wampserver, there was not errors, so probably will be problem somewhere in setting in xampp search where :d

Try remove your "root" password and click next

The problem does not seem to be a matter of XAMP. I have the same on a normal server, where i have installed Joomla's many times. No connection with base. I cannot understand it. There must be some new conditions for the database to connect now in Joomla 1.6. I do not believe that I have made any trivial mistake as I have installed Joomla hudreds of times before. Please help anyone who knows what's the matter.

The problem does not seem to be a matter of XAMP. I have the same on a normal server, where i have installed Joomla's many times. No connection with base. I cannot understand it. There must be some new conditions for the database to connect now in Joomla 1.6. I do not believe that I have made any trivial mistake as I have installed Joomla hudreds of times before. Please help anyone who knows what's the matter.

Same here. Its not about root user or XAMP. Im doing this on a live site and have normal non-root username setup and still same "could not connect error"

Further testing revealed:

1) Hostgator shared Linux account - connection error. I have successfully installed J! 1.6 RC1 on this account using the "normal" (for this account) database connection method; same method generates connection error with J! 1.6 Stable. Numerous J! 1.5.xx, WordPress 3.x.x, Drupal 6.x. and 7.0 successfully install.

2) GoDaddy shared Linux account - no connection error; J! 1.6 Stable installed with no errors.

3) XAMPP 1.7.3 - connection error when using "root" as the database password as is normal for this XAMPP installation and which also worked successfully with J! 1.6 RC1. However, when leaving the password empty (blank) as suggested in a post above, the install successfully completed. This is 180 degrees from what should work. This XAMPP installation has literally hundreds of Joomla, WordPress and Drupal installations, including J! 1.6 RC1 which ALL REQUIRED the "root" password.

I have not yet tried The Uniform Server nor WAMPServer but there is something definitely NOT the same from J! 1.6 RC1 to the 1.6 Stable.

I am sure there must be a real problem with the base. I had problems both with Joomla 1.6 RC1 and Stable. And I remember the first Joomla. 1.5.0 . It was full of bugs. Maybe up to some 1.5.8 - 1.5.9 there were some issues. Now Joomla 1.5 is excellent and super stable.
And as I managed to try J1.6 demo, the new Joomla 1.6 will be excellent. Multilevel article categories and user groups and rights. This was, up till now, obtainable with the use of some extra extensions, but when it is "native" now, it will be very stable.
I think we must wait for some J1.6.6 to be able to think to use it on a "live" site.

I'm still having this problem.

Any fixes, I've tried the following:

create a database through the host, tried using "host" as username, tried leaving password blank, i've tried changing "localhost" to 127.0.0.1, tried mySQLi, and mySQL,

Joomla 1.5.2 installed fine.


Any other ideas?

Since 1.5.2 installs fine, going to try to install it again and install the plugin that helps upgrade to 1.6 and see if that works.

I'll let you know what I find out.

I used jUpgrade and that seem to fix all the problems.

2ninerniner2 wrote:Howdy,

J!1.6 Stable/Win 7 Home Premium/Local

Error:
Could not connect to the database. Connector returned number: Unable to connect to the Database: Could not connect to MySQL.

This is as far as I can get with my trusty XAMPP 1.7.3 within which I have successfully installed and run literally hundreds of J! (among others) sites, including J!1.6RC1.

Tried creating the database first (didn't have to with J!1.6RC1), used 127.0.0.1 instead of localhost, tried MySQL instead of MySQLi (default choice). All the connection items are as they should be. Tried another install of J!1.6RC1 and it went just fine; no issues. Any ideas?

Cheers!
Lyle

I had the same problem with WAMP Server 2.1 and J! 1.6 Stable. What worked for me was, in step 4, using "joomla" as the DB name, "root" as the username, and no password.

I was getting the same error installed on cPanel\WHM host.

It seems that the installer was defaulting to "MySQLi" and when I changed the database type to "MySQL" (in the dropdown) then the installer carried on fine. All installed perfect.

Can someone else with this problem confirm this was their issue too.

markjonesmel wrote:I was getting the same error installed on cPanel\WHM host.
It seems that the installer was defaulting to "MySQLi" and when I changed the database type to "MySQL" (in the dropdown) then the installer carried on fine. All installed perfect.
Can someone else with this problem confirm this was their issue too.

This is webhost depending. If MySQLli is compiled it works as such..if not than you need to use mySQL. MySQLi stands for MySQL Improved. Any descent host should support that (we do) http://en.wikipedia.org/wiki/MySQLi for more info

Leo

I think it is not a matter of Mysqli or Mysql. I tried many times both and still no connection. I think that Mysqli or Msql is not a problem at all.

Try to set the password for the database without any special characters.

I had the problem with connecting to the database. I've noticed that after getting error, password was cutted to only 5 characteres (which were letters). SO i've changed the password in database and it works.

andrzej61 wrote:I think it is not a matter of Mysqli or Mysql. I tried many times both and still no connection. I think that Mysqli or Msql is not a problem at all.

That depends on your host/server installation. If your host does not support MySQLli it won't run

Leo

I have the same problem with one.com hosting ... Unable to connect to the Database: Could not connect to MySQL.

Settings are correct.

Any thoughts ?

I had the same problem too. I was able to resolve it by entering root with no password and the installation proceeded. I hope this is helpful.

Using a Windows 7 64bit machine with WAMPSERVER 2.1e and receiving the exact same error message when attempting the Database Configuration in the J1.6 Stable installation! Doesn't Stable mean they actually tested this on exact if not similar IDE's prior to branding it with this status?!

* Could not connect to the database. Connector returned number: Unable to connect to the Database: Could not connect to MySQL.

CPUHelp wrote:I had the same problem too. I was able to resolve it by entering root with no password and the installation proceeded. I hope this is helpful.

Thanks CPUHelp that nailed it!

The same issue to me. Although on most of my sites, 1.6.1 installed without any problems, on some hosts, it didn't and none of the options mentioned above worked.
I decided to let it rest for a while. Recently however, my host added a short instruction in their control panel for using a MySQL5+ database: "you need to switch from PHP 5.2 to PHP 5.3". Guess what: it solved the problem.
Now I'm not a PHP guru, but to me this at least raises some questions over PHP5.2 being the recommended PHP-version for Joomla 1.6.x....

Hi!
I had the same issue in installing joomla 1.6 but I managed to solve it after following some advice from this forum.
You should be aware that not all host name is localhost; this is what worked for me:

- login to your cpanel account
- look for MySql Icon and click it
- read that page and you will find your host name there.
If you do not find it then contact your hosting company for the host name.

Note
Before you go for the above point, check the following:
-User name spelling
- sql password spelling(not the one you provided for cpanel login)
-database name spelling
- check if your host is using a prefix for the User name and the password.

I hope this is helpfull.

Good luck!!!!

had the same problem and just could not understand why, I had done at least 100 joomla installs! but it was my first time installing 1.6 so i blamed it on that.
so I went into my Lunarpages Cpanel and installed 1.6 this way instead of manual, and when I went to type in my preferred database name, it told me that it could not exceed 7 characters. Once I brought it down to 7 from 9 characters it installed perfectly!
Now I did not go back and try a manual install with the new shorter database name, but I think that was the problem.

Hi,

your issue seems to be with the mysql database name (not with userid or password or even host name).

Hence create a new database. The list of commands are here http://itswadesh.wordpress.com/2011/04/ ... -commands/

If you have forgotten your database root password visit http://itswadesh.wordpress.com/2011/04/ ... -password/

I am using godaddy shared linux hosting. I was getting this error. I put the ip address in for the database instead of db.xxxx.hostedresource.com. Also I I copy and pasted the addresses into to notepad first. Then it worked.

Hi,

I changed the option from Delete old database to Back Up and the installation went ok.

Not sure if backing the old database will cause problems later, suppose I'll cross that bridge when I come to it.

Regards,

Andy.

I found that when trying to create a new database and new user for the database manually, using "MySQL databases" in control panel to add a new user did not take me to the privileges screen. Because of that my new user had no privileges and the database was not being found. However I started again using the "MySQL database wizard" instead. This did take me to the privilege screen and everything worked ok once I gave my new user privileges.

None of the above posts has helped me resolve the issue encountered.
I'm trying to install Joomla!1.7.0 on my iMac running Mac OS X Lion 10.7.1, Apache 2.2.19, PHP 5.3.6 and MySQL 5.5.15.

I created a web site in my Sites folder to host the Joomla install. I access the web site via http://localhost/~Olivier/sncg.

However, to access the database I use the command mysql -h localhost -uroot -p

I have no problem connecting to MySQL using the terminal or the SQL client Navicat. It's just the Joomla install which is failing!

i suggest use appserver its very completely
i use it and i dont have any problem