• Resolved aengineer

    (@aengineer)


    I’m attempting to install in a “blog” subdirectory on my hosting service, IXwebhosting, following the instructions. I set up the DB and apparently logged on successfully because I made it through step one of the installation with no problem.

    Step 2, however gives me a long series of errors of the following sort:

    WordPress database error: [Access denied for user: ‘ABC_DEF@%’ to database ‘ABC_ATBlog’]
    CREATE TABLE wp_categories ( cat_ID bigint(20) NOT NULL auto_increment, cat_name varchar(55) NOT NULL default ”, category_nicename varchar(200) NOT NULL default ”, category_description longtext NOT NULL, category_parent bigint(20) NOT NULL default ‘0’, category_count bigint(20) NOT NULL default ‘0’, PRIMARY KEY (cat_ID), KEY category_nicename (category_nicename) )

    It looks as though it’s telling me that I don’t have proper privileges, but that account (details changed here for security reasons) is an admin account.

    Can anyone interpret for me and suggest what I should do.

    Here’s the wp-config.php contents – again edited for security

    <?php
    // ** MySQL settings ** //
    define('DB_NAME', 'ABC_ATBlog'); // The name of the database
    define('DB_USER', 'ABC_DEF'); // Your MySQL username
    define('DB_PASSWORD', 'xxxxxxxxx'); // ...and password
    define('DB_HOST', 'xxxxxxx.ixwebhosting.com'); // 99% chance you won't need to change this value
    // You can have multiple installations in one database if you give each a unique prefix
    $table_prefix = 'wp_'; // Only numbers, letters, and underscores please!
    // Change this to localize WordPress. A corresponding MO file for the
    // chosen language must be installed to wp-includes/languages.
    // For example, install de.mo to wp-includes/languages and set WPLANG to 'de'
    // to enable German language support.
    define ('WPLANG', '');
    /* That's all, stop editing! Happy blogging. */
    define('ABSPATH', dirname(__FILE__).'/');
    require_once(ABSPATH.'wp-settings.php');
    ?>

Viewing 5 replies - 1 through 5 (of 5 total)
  • I believe I’ve seen this where the user seemed to have admin rights but had to manually set both read and write check boxes as well.

    Thread Starter aengineer

    (@aengineer)

    Help again. I’m not sure what you mean by the “read and write check boxes”. Is that in the MySQL admin, or in the server permissions, or is it something in the WP configuration – and if so, where?

    mysql admin (or phpMyAdmin).

    The user specified in wp-config.php must have read/write access to the database specified in wp-config.php.

    Thread Starter aengineer

    (@aengineer)

    Thanks. I could have sworn I had r/w access, but you pushed me to go back and check on the host. Indeed I didn’t. It has now installed as promised.

    Jim Mitchell

    Sweet – glad you got it sorted. Mark this topic as [Resolved]? (toggle at the top)

    Happy blogging!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Access Denied’ is closed to new replies.