mySQL Error – Unable to connect to mySQL. Joomla HELP?

We recently bought an account at Afrihost, and installed joomla on it. Everything seems to be working now, but we cannot make the mySQL server connect with joomla, we keep getting this error "Unable to connect to the database:Could not connect to MySQL"

Can anyone assist me in this..

September 4, 2010 | Filed Under Joomla 

Comments

4 Responses to “mySQL Error – Unable to connect to mySQL. Joomla HELP?”

  1. Brandon on September 4th, 2010 9:34 am

    Since joomla requires the database in order in order to do ANYTHING, I assume you mean that nothing is working now.

    Different hosts use different formats for the name of the server, username and database name. In the place where you actually made the blank user and database, pay very careful attention to their instructions as to what to use for these strings. Often they will have a format like yourAccount_dbname or yourAccount_userName. They might require a form that uses a non-default port.

    For better help, go to the joomla forums ( http://forum.joomla.org/ ) and ask.

  2. sahaana on September 4th, 2010 9:34 am

    its ur pc
    then
    1 st chek you give the corrrect code to connect sql

  3. D on September 4th, 2010 9:34 am

    A) check your my.ini file make sure your not binded to 127,0,0,1
    B) make sure you are pointing to your mysql server.

  4. Russ on September 4th, 2010 9:34 am

    If it were a username / password issue the Error would indicate so. The error you are receiving typically occurs when you have the host entry incorrect. Many web hosting companies configure their MySQL databases so you can access as "localhost". However, some, like Godaddy, actually have their MySQL databases on a differerent server so you have to check with your hosting provider as to what host you should use to access the database.

    Also, just double check to be sure you are using prefix_username and prefix_database

Powered by Yahoo! Answers