• Resolved DJ007Dude

    (@dj007dude)


    Hi there,

    I am trying to install WordPress and have come across this error that I have not seen before.

    Warning: mysql_connect(): Can’t connect to local MySQL server through socket ‘/tmp/mysqld.sock’ (2) in /homepages/22/d542277703/htdocs/devsite/wordpress/wp-includes/wp-db.php on line 1416

    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 localhost. This could mean your host’s database server is down.

    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?

    If you’re unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.

    The top part of this is what I am confused as to why this is an error. I have gone to line 1416 and this is what it shows.
    if ( WP_DEBUG ) {
    $this->dbh = mysql_connect( $this->dbhost, $this->dbuser, $this->dbpassword, $new_link, $client_flags );

    So the question is do I need to change anything here or has something else happened?

    Thanks,
    Jacob.

Viewing 11 replies - 1 through 11 (of 11 total)
  • This is a issue with the server. I recommend to change your hosting provider or to try to contact them. [moderated]

    @tejli007 – please note that specific hosting discussions aren’t allowed on these forums – https://codex.www.ads-software.com/Forum_Welcome#Closing_Posts

    g.

    (@morrisgraeme)

    So, did you put the correct DB info in your wp-config file? Is it uploaded to the correct space? Just shooting at some stuff… lmk ??

    Thread Starter DJ007Dude

    (@dj007dude)

    Hi there,

    I have looked at where the issue is in the file stated above and it has nothing to do with any hosting providers, It is to do with my database. Also look at your own files and see that it is to do with a login problem and trying to connect to a database. So @teji007 and @wpyogi are wrong.

    @g. The DB info is correct to my knowledge and should work fine. Do you mean if the database is uploaded to the correct space or the wp-config file?

    Thanks,
    Jacob.

    g.

    (@morrisgraeme)

    This is a shot in the dark… but be careful, some ISP’s require your MYSQL hostname not be ‘localhost’ for example… I have had a plethora of problems with simple naming conventions and stuff… However it sounds like it could be something more difficult, but first let’s rule out the obvious. For example cpanel is known for looking like it strips the underscores out of names as it displays the hostname without the underscore, but the DBNAME has underescores… so try not to use underscores in your DB Name… etc.
    Next the wp-config.php must be uploaded to the correct location, ie. the root of the install… I know that is obvious… but nevertheless.
    Ultimately it looks like you have a connection error between server space wp location and the MYSQL DB…
    Could be a firewall issue.
    Does your server provider allow you to remote into your DB?

    Thread Starter DJ007Dude

    (@dj007dude)

    I have no access to a cpanel or MySQL as I have tried to get that running in Ampps and nothing seemed to work.

    The scenario I am in is that the client has asked me to make their website from scratch and he has given me log in details for the FTP FileZilla. So I need to know whether or not I need to change the directory of the FTP files and install it in there or go into the Login thing and change a few things around. It is all very confusing and hard to type what the problem is.

    Have you looked at the line in the file that was causing the issue for me and seen what the line is about. I should have the correct DBHost, name and password.

    Thanks,
    Jacob.

    Moderator Samuel Wood (Otto)

    (@otto42)

    www.ads-software.com Admin

    Have you looked at the line in the file that was causing the issue for me and seen what the line is about. I should have the correct DBHost, name and password.

    You do not have the correct “DBHost, name and password”.

    That specific line is the mysql_connect line. It’s the line where it is trying to connect to your database. To do that, it needs to know the correct hostname, username, and password for that database.

    Since the information you have in the configuration file is incorrect, it cannot connect, and so you get an error on that line because that is the line where the error occurs. The error is caused by the bad information, not by the code itself.

    Correct the information in your wp-config.php file. Then the problem will go away.

    Thread Starter DJ007Dude

    (@dj007dude)

    Hi there,

    If the information for my ftp and DB are the same then it should work as that is what I have to work with.
    I have made sure that the login details are correct and seem to be having issues. So that doesn’t really solve the issue i’m afraid.
    Unless I need to delete the config-sample.php file and only have config.php file.

    Thanks,
    Jacob.

    Thread Starter DJ007Dude

    (@dj007dude)

    Hi there,

    I now have the issue of the fact that it has changed the warning to below:
    Warning: mysql_connect(): Access denied for user ‘**************’@'”””””””””””””””””‘ (using password: YES) in /homepages/22/d542277703/htdocs/devsite/wp-includes/wp-db.php on line 1416
    * = db
    ” = localhost thing
    This measns that it can’t seem to find the database and may ignore the username and password.

    So I am getting close to installing WP and still need to solve this.

    Thanks,
    Jacob.

    Moderator Samuel Wood (Otto)

    (@otto42)

    www.ads-software.com Admin

    If the information for my ftp and DB are the same

    They are most likely *not* the same, and you will need to find out what the correct DB connection information is.

    Thread Starter DJ007Dude

    (@dj007dude)

    Hi there,

    Problem was resolved by looking at the database items needed for the config file. Issue is that there is meant to be a dboRandomNumbers thing that you need but the hosting people have an added 0. So it was dbo0RandomNumbers. This is the issue so remove the 0 and it should work.

    Thanks,
    jacob.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Error message trying to install WP’ is closed to new replies.