Database Cannot Connect When Installing Joomla, Database cannot connect when installing Joomla

[Merryck]

Hi,

I seem to have done my database without any hitchs. But when i try to install Joomla

localhost
username
password
databasename

I get the followinf message
An Error has occurred!:Could not connect to the database. Connector returned number: Unable to connect to the database:Could not connect to MySQL


Anyone can help ? Im not sure if the prob is on joomla itself or the database.

TY

[Adrian Marks]

I am having the same exact problem!

the error that I get is:

Unable to connect to the database:Could not connect to MySQL

I was able to install it on other hosts before, but I liked zymic better, can anyone please help me out?

[Adrian Marks]

i am almost 95% positive that the problem for me is with the host for the database...
for those of you who have successfully installed joomla! 1.5 could you be kind enough to share what you used to fill in the host box?

i've tried localhost, but my guess is that zymic's mysql application is on another machine(server), but of course i could be wrong.
if any of the admins know this, could they provide the IP address of that server so that we can use it in conjunction with joomla!

please get back to me ASAP, and thanks in advance!

[Dave]

localhost is correct for the host.

If you check out the database forum (where this should have been posted) there is one solution for this problem. Try making a new database and username that are less than 4 letters in length.

Eg:
Database: yoursite_db
User: yoursite_a

That seems to fix the problem for a lot of people. Try it and see if it works for you.

[dexter_ade]

localhost is correct for the host.

If you check out the database forum (where this should have been posted) there is one solution for this problem. Try making a new database and username that are less than 4 letters in length.

Eg:
Database: yoursite_db
User: yoursite_a

That seems to fix the problem for a lot of people. Try it and see if it works for you.

Thanks Man its great!! its funntional

[Phazon25811]

Hi,

I seem to have done my database without any hitchs. But when i try to install Joomla

localhost
username
password
databasename

I get the followinf message
An Error has occurred!:Could not connect to the database. Connector returned number: Unable to connect to the database:Could not connect to MySQL
Anyone can help ? Im not sure if the prob is on joomla itself or the database.

TY

Greets! I had a similar problem with Joomla 1.5, after upgrading my MySQL database (from 4.x to 5.x). Got that error when going through the installation process (database part of the install), went through lots of forums regarding that problem until I came to the solution.

First, I made sure that my new MySQL 5.x database was properly working with my Apache Webserver and my PHP 5.x installation by using the following script:

CODE

<?php
// Change the variables to meet your specific installation.

// localhost = the name of the database server
// admin = the username for login into the mysql database
// 1admin = the password for the username to log into the database

mysql_connect("localhost", "admin", "1admin") or die(mysql_error());
echo "Connected to MySQL<br />";
?>

I named the file test_mysql.php. When you execute the script, it should say "Connected to MySQL" if everything is working properly, otherwise you get an error, and, well, google the error message until you find the solution, which I found solved both my PHP/MySQL communication problem, as well as my Joomla installation problem.

The error that I got was "Client does not support authentication protocol; consider upgrading MySQL client", which was easily solved by opening a windows shell (start menu -> run -> cmd), login into the MySQL database under the root user, and executing the following command:

CODE

mysql> SET PASSWORD FOR
    -> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

Obviously change the appropriate variables within the single quotations mark to meet your needs. Once I executed that, the Joomla! 1.5 installation went smooth.

Hope this helps out, just like some of the forums helped me out!

Cheers!

[DeaDly-LoRD]

Go To Zymic Control Panel Then login your web hosting account then go to MySQL Database Management then click on "Assign Privileges"

[Tham]

HELP!
I'm getting the same problem as everyone else is. I've tried installing Joomla, but I'm always stuck in the error that says "Could not connect to My SQL." I've tried shortening my username and database name, assigned privileges, but nothing still seems to work. Any advice, please?

[ssfdre38]

go to http://zymickb.zxq.net/index.php/MySQL

[Dave]

Old thread *closed*