Wordpress DB Problem

Discussion in 'Third-party applications' started by gsm, Mar 28, 2005.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. gsm

    gsm

    Hello guys...

    I'm trying to install wordpress blog on the server..

    I keep getting this error msg..

    Error establishing a database connection

    This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at *******.discountasp.net..

    * Are you sure you have the correct username and password?
    * Are you sure that you have typed the correct hostname?
    * Are you sure that the database server is running?

    And , it's only 4 lines for configuraing the file , usrname , pass , db name , and host name !!!

    Can any one tell me what I'm doing worng ??
    and how can I make it right ??

    Thanx in advance.

    </font> </font>
     
    gsm, Mar 28, 2005
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    i have not use this software before, so it's very hard to provide much help.

    i suggest you contact wordpress blog to see if they can help.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Mar 28, 2005
    #2
  3. Bruce

    Bruce DiscountASP.NET Staff

    I'll give it a shot to install this. We have not tested phpmyadmin after upgrading to mysql 4.1

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Mar 29, 2005
    #3
  4. gsm

    gsm

    Thanx man ... but....

    MySQL payment has been collected !!! and I can't acces my DB !!!!!!!!!!!! :(

    I really need some help here...

    I tried everything , even phpmyadmin is not working with the same error !!!

    phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
    Error

    MySQL said
    #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

    I'll be thankfull if you get my a quick healing answer Bruce :)
     
    gsm, Mar 29, 2005
    #4
  5. gsm

    gsm

    thanx Bruce for your auick replying...

    I tried also to use phpMyAdmin but got this msg....

    phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and
    password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.

    then , I did check my billig payment , to find that MySQL addon is not my biling yet , althoght it's availabe on my control panel !!

    Do I have to wait to make the payment first ???
     
    gsm, Mar 29, 2005
    #5
  6. gsm

    gsm

    using phpMyAdmin 2.6.1-pl3

    with error text

    MySQL said: Documentation
    #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
     
    gsm, Mar 29, 2005
    #6
  7. DavidH

    DavidH DiscountASP.NET Staff

    I have tried to install from the instruction of PhpMyAdmin,
    the info i have to modify from the config.inc.php is :
    $cfg['Servers'][$i]['host'] = '<mysqldatabase>'; // MySQL hostname or IP address
    $cfg['Servers'][$i]['user'] = '<my username>'; // MySQL user
    $cfg['Servers'][$i]['password'] = '<my password>'; // MySQL password (only needed
    // with 'config' auth_type)
    $cfg['Servers'][$i]['only_db'] = '<DB Name>'; // If set to a db-name, only
    $cfg['PmaAbsoluteUri'] = 'http://www.mydomain.net/phpMyAdmin/';

    it turns out without problem and i am able to connect to MySQL from phpmyadmin page.


    hope this can can help you.
     
    DavidH, Mar 30, 2005
    #7
  8. Bruce

    Bruce DiscountASP.NET Staff

    we found something wacky w/ the new mySQL (4.1).

    i let our DBA know already. if the problem doesn't resolve itself within 24 hrs, please create a support ticket.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Mar 30, 2005
    #8
  9. gsm

    gsm

    DeeJay : Thanx , but I was already did ...

    bruce : Thanx man :) It works... I didn't change a thing ... but It was working .... until..

    I fing out , that whenever I log to

    FrontPage Tool --> Manage FrontPage Extension --> Change anonymous access settings

    and change it ....

    I got the ( #2004 - Can't create TCP/IP socket (10106) ) error...

    So , It stops again...

    So , what should I do to avoid such things , and make it woek agian ??

    Thanx ;)
     
    gsm, Mar 30, 2005
    #9
  10. gsm

    gsm

    Thanx ... everything is in it's place and working perfectlly..

    As I think , it needs like 15 min or so to re-activate the anonymous access settings

    That's all..

    Thanx for your help guys... /emoticons/turn.gif

    Best Regards.

    Geo
     
    gsm, Mar 30, 2005
    #10
  11. gsm

    gsm

    phpmyadmin supports 3 ways of auth...
    config , http , cookies

    all of them didn'y function...

    so ...what is the authentication protocol that your MySQL server use ??
     
    gsm, Mar 30, 2005
    #11
  12. gsm

    gsm

    i tried the code in
    http://kb.discountasp.net/article.aspx?id=10086

    as an abstract test... I get...

    Connection to MySQL-server failed!PHP Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in E:\web\xxxxxxx\htdocs\cont.php on line 19

    and with .net

    ERROR [HY000] [MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server; consider upgrading MySQL client ERROR [HY000] [MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server; consider upgrading MySQL client

    and now .. I'm getting ...

    #2004 - Can't create TCP/IP socket (10106

    so ,I donno where the probelm is...

    waiting your reply Bruce :)

    Post Edited (gsm) : 3/30/2005 1:15:09 AM GMT
     
    gsm, Mar 30, 2005
    #12
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page