WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Installation Problem - Yahoo MySql - Keeps Asking For Local Host (5 posts)

  1. mikey3
    Member
    Posted 6 years ago #

    I set up the database and even changed the DB_HOST to mysql

    when I get past the first screen (with the blog title and email address) of the wp-admin/install.php

    I get:

    "WordPress database error: [Access denied for user 'pal001'@'localhost' to database 'wordpress']
    CREATE TABLE wp_terms ( term_id bigint(20) NOT NULL auto_increment, name varchar(55) NOT NULL default '', slug varchar(200) NOT NULL default '', term_group bigint(10) NOT NULL default 0, PRIMARY KEY (term_id), UNIQUE KEY slug (slug) ) DEFAULT CHARACTER SET utf8

    WordPress database error: [Access denied for user 'pal001'@'localhost' to database 'wordpress']
    CREATE TABLE wp_term_taxonomy ( term_taxonomy_id bigint(20) NOT NULL auto_increment, term_id bigint(20) NOT NULL default 0, taxonomy varchar(32) NOT NULL default '', description longtext NOT NULL, parent bigint(20) NOT NULL default 0, count bigint(20) NOT NULL default 0, PRIMARY KEY (term_taxonomy_id), UNIQUE KEY term_id_taxonomy (term_id,taxonomy) ) DEFAULT CHARACTER SET utf8

    WordPress database error: [Access denied for user 'pal001'@'localhost' to database 'wordpress']
    CREATE TABLE wp_term_relationships ( object_id bigint(20) NOT NULL default 0, term_taxonomy_id bigint(20) NOT NULL default 0, PRIMARY KEY (object_id,term_taxonomy_id), KEY term_taxonomy_id (term_taxonomy_id) ) DEFAULT CHARACTER SET utf8

    ......
    "

    And it extends for quite sometime

    Any ideas on how to fix this?

    Thanks in advance

  2. WebDev WaxLotus LLC
    Member
    Posted 6 years ago #

    Hey Mikey3,

    WordPress database error: [Access denied for user 'pal001'@'localhost' to database 'wordpress']

    So the system is trying to connect to a database called 'wordpress' that it expects to find on a, well, server element/part of the network called 'localhost' using the login credentials of the database user 'pal001'.

    Now, is this on a hosted account? If so, depending on your hosts' setup (like cPanel) all the server stuff you create will have your hosting account's name as a prefix e.g. if you log into your cPanel with the user name of 'oldcat', everything will be like this:
    /home/oldcat/public_html/ etc.

    So, assuming something like that...

    That would look like this in the wp-config.php file:

    define('DB_NAME', 'oldcat_wordpress'); // The name of the database
    define('DB_USER', 'oldcat_pal001'); // Your MySQL username
    define('DB_PASSWORD', 'Mag1cPazW0rd3JIO'); // ...and password
    define('DB_HOST', 'localhost'); // 99% chance you won't need to change this value
    define('DB_CHARSET', 'utf8');
    define('DB_COLLATE', '');

    Which reminds me, I think that there may be a limit to the length used by the server when trying to make a connection. It just chops off the stuff after the limit and complains all day that you're trying to log in with the wrong information, haha. It has been a while since I ran into this so others will chime in.

    The password is the password you created for the database user 'pal001' to be able to connect to which ever database 'pal001' is assigned to (by you, before you run the install!)

    Oh heck! Read this?

    Why did you change the DB_HOST value to 'mysql'?

  3. mikey3
    Member
    Posted 6 years ago #

    Thanks for the help....but I set all the figures as you said in the wp-config.php as well as on phpmyadmin

    The reason I used 'mysql' for the DB_HOST is because I'm using Yahoo to host and it says to use mysql for yahoo's web hosting.

    Appreciate the attempt though

  4. MichaelH
    Member
    Posted 6 years ago #

    For some stupid reason, Yahoo does not give what they call the Database Administrator, all the privileges to the database.

    Read this to fix that situation:
    User:MichaelH/Installation_Notes/Yahoo

  5. WebDev WaxLotus LLC
    Member
    Posted 6 years ago #

    Interesting. Good link MichaelH. Thanks.

Topic Closed

This topic has been closed to new replies.

About this Topic