WordPress.org

Support

Support » How-To and Troubleshooting » [Resolved] WordPress and MYSQL 5

[Resolved] WordPress and MYSQL 5

  • My server has recommended that I change all of my databases over to MYSQL 5. So I have, and now there’s a shiny new database called “username_database” instead of the old “database” (not the actual names, obv, just using them as an example).

    However, when I try to change the Config file to pull from this new database, it keeps giving me a “cannot connect to database” error.

    My current config file, with some of the information changed for security’s sake:

    $db_servertype = "mysql";
    $db_host = "localhost";
    $db_name = "database";
    $db_user = "user";
    $db_password = "password";
    
    $table_prefix = "4images_";

    The information on my new DB server host is as follows (with the username changed for security’s sake)

    MySQL
    
        * Server: Localhost via UNIX socket
        * Server version: 5.0.82-msl-usrs-sure2-log
        * Protocol version: 10
        * User: username@localhost
        * MySQL charset: UTF-8 Unicode (utf8)
    
    Web server
    
        * Apache
        * MySQL client version: 5.0.82
        * PHP extension: mysqli

    What am I doing wrong?

Viewing 5 replies - 1 through 5 (of 5 total)
  • $db_host = “localhost”;

    Server: Localhost via UNIX socket

    Check with your Host. My host requires something in the form of

    $db_host = “localhost:/mysql.sock”

    $db_name = “database”; is wrong??????

    Let’s try something simple –

    Did you ever create a database?

    If so, what did you name it? What user name and password did you create it with?

    Don’t post the last answer here.

    Yes, I created the database. If the old database name was “database”, for example, the new one is simply “username_database”.

    Nevermind, I’ve asked my host, and I’m going to try their answer first.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘[Resolved] WordPress and MYSQL 5’ is closed to new replies.
Skip to toolbar