WordPress.org

Forums

[resolved] MySQL 4.0.25 (4 posts)

  1. rcmullins
    Member
    Posted 8 years ago #

    Does anyone know if there are any problem issues concerning wordpress seeing this? My hosting provider has this version of MySQL on a linux box but i keep getting the below error;

    Can’t select database

    We were able to connect to the database server (which means your username and password is okay) but not able to select the rmullins_wordpress database.

    * Are you sure it exists?
    * On some systems the name of your database is prefixed with your username, so it would be like username_wordpress. Could that be the problem?

    If you don't know how to setup a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.

    I know the config is set up properly, and i cant seem to find anything on this forum concerning it.

  2. rcmullins
    Member
    Posted 8 years ago #

    Additionally, here is my sql dbase;

    Current Databases:
    rmullins_wordpress

    here is my config:
    <?php
    // ** MySQL settings ** //
    define('DB_NAME', 'rmullins_wordpress'); // The name of the database

  3. rcmullins
    Member
    Posted 8 years ago #

    Ok, I fixed the problem. It was a stupid error on my part. Seems that my website hosting person, uses CPanel as a front end. Not knowing how to use it, I created a MySQL database, and I created a MySQL user, but there is an additional step you have to do before wordpress can log into the d-base. You have to click a little button, near the bottom that actually ADDS the user to the database. If you do not do this important step, then all you have is a dbase with no user, and a user with no dbase.

    I am used to editing and manipulating MySQL from the CLI and MySQL's front end tools, not a foreign gui. Incidentally, this is one area that the makers of cpanel could really improve on. However, if you do not use cpanel for your linux webserver you really should check into it. There are a ton of perks that come with it. Incidentally, I went through all this configuring needlessly. CPANEL has WordPress built in and all you have to do is click 'install' and go through a few installation procedures. Very nice.

  4. makky
    Member
    Posted 8 years ago #

    My host runs CPanel X. Does this have WordPress installed as well? If so, how did you find that out, and where can you find the install ability?

Topic Closed

This topic has been closed to new replies.

About this Topic