Install – cannot establish connection

  • eldoren

    (@eldoren)


    21 years, 5 months ago

    Hi
    I wanted to load WordPress onto the a web server that we setup for a client yesterday and spent about 3 hrs fighting with it. I was one of the unlucky ones in terms of the 5 min install not working. Here is the approach I took.
    1) I downloaded the latest version of WordPress and dumped it into a directory called wordpress ( with the appropriate sub directories ).
    2) My server runs php 4.1.2, apache 1.3.23, mySQL 3.23.56. mod_rewrite is installed.
    3) I logged into phpMyAdmin and setup a new database. Then in the mysql database I created a new user ( no priviledges) with localhost as my host. Then went into the mysql database DB table and gave the user I created access to the wordpress database I created ( with all priviledges ). Then reloaded the mysql from the main phpmyadmin page.
    4) I edited the wp-config-sample.php file and added the proper connection info. Then saved out as the wp-config.php.
    5) I then uploaded the files into a directory on the server ( called wordpress) with all the files and subdirectories. Its a Linux box running RedHat Advanced Server 3. File permissions for the directories and files were 755 ( I tried 644 and others but that was never a problem ). WHen I uploaded, my FTP username has root priviledges so I don’t believe ownership is a problem.
    6) I then ran the htttp://www.domainnamehere.com/wordpress/wp-admin/install.php script and got the “cannot establish a connection” error message. I doubled check all settings and reuploaded files, played with different settings etc on the server and still with no success.
    7) I then came to the WordPress Support, read over a bunch of pages of support issues trying to identify the problem based on what others had trouble with. The server that I am using is one we setup for a trades and technology site. We can change or edit pretty much any setting or configuration.
    Any thoughts on what I may have missed? I wanted to get it working and get some experience getting familair with it
    I thought about uploading a simple script to make a connection to the database to see if it was my database or if it was the wordpress scripts. I have a basic understanding of php and mysql but I am missing something.
    Any advice is appreciated!
    Eldoren

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter eldoren

    (@eldoren)

    21 years, 5 months ago

    I tried what you said above and get the following errors:
    Warning: Access denied for user: ‘wordpressuser@localhost’ (Using password: YES) in /var/www/html/wordpress/wp-includes/wp-db.php on line 26
    Warning: MySQL Connection Failed: Access denied for user: ‘wordpressuser@localhost’ (Using password: YES) in /var/www/html/wordpress/wp-includes/wp-db.php on line 26
    Error establishing a database connection! This probably means that the connection information in your wp-config.php file is incorrect. Double check it and try again.
    ———————–

    Cypher

    (@cypher)

    21 years, 5 months ago

    OK..that means that you don’t have the right permissions/information in WP.
    Try something like this:

    mysql -uwordpressuser -p

    This should prompt you for the password, enter what you’ve entered in your wp-config.php file and see if you can login to MySQL.
    If that fails as well, then you need to login as root and ensure that you’ve created the user properly.
    Regards

    Thread Starter eldoren

    (@eldoren)

    21 years, 5 months ago

    Well after a number of tries, I managed to figure it out ( but with the kind support of mookitty.ca and others on the support forum). I was creating the accounts (database and user) using phpmyAdmin. They displayed and had the correct rights…but for some reason didn’t work.
    Again, with the help of the gang here and mookitty.ca, I logged in to the mysql command prompt and added the database, user, password and privileges “manually” and then edited my wp-config file. The install then went VERY FAST ( about 2 minutes.).
    Thanks everyone for the patience. It tells me that maybe my phpmyadmin is not setup like it should be. I need to research this at my end.
    Cheers
    Eldoren

    Anonymous

    21 years, 5 months ago

    I feel like an idiot trying to install this. I keep having the same problems. Sorry guys, but I’ll just stick with the very, very slow blogger composer.

    Mark (podz)

    (@podz)

    21 years, 5 months ago

    zridling – give us a chance to help you !
    What are the relevant details ?

    Anonymous

    21 years, 4 months ago

    ho wcan i archive mysql.sock. reinstall the mysql but nysql not created. why ? reply me on happy.bhutani@gmail.com

    Anonymous

    21 years, 4 months ago

    how can i archive mysql.sock. reinstall the mysql but mysql not created. why ?

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Install – cannot establish connection’ is closed to new replies.