Database Error

  • Resolved buckmajor

    (@buckmajor)


    16 years, 10 months ago

    Hi there

    I have been trying to install wordpress and the following error is displayed.

    WordPress database error: [Access denied for user ‘dbuser’@’%’ to database ‘dbn’]
    CREATE TABLE wp_terms ( term_id bigint(20) NOT NULL auto_increment, name varchar(200) 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), KEY name (name) ) DEFAULT CHARACTER SET utf8

    This is only a snippet and there was whole chunk of errors similar to the above quote.

    Please help me!

    Many thanks in advance
    CHEERS 🙂

Viewing 1 replies (of 1 total)
  • Thread Starter buckmajor

    (@buckmajor)

    16 years, 10 months ago

    All good people, I solved this problem and man it feels great knowing you have conquered so many barriers hahaha lol.

    I’m not sure if somebody already posted a solution to this error but I am willing to explain everything.

    Ok..here we go.

    If you have entered the correct config.php info then all you need is this last step to install wordpress.

    1. The reason why I was getting this error was because my database privileges only had one selected which was the ‘select’ name. I have no idea what they all mean so I looked at one of my other database and noticed that it was all checked.

    Here are the list privileges from my Web Host. Not sure if its the same for every Host.

    Privilege name:
    > grant
    > drop
    > update
    > create
    > alter
    > index
    > insert
    > delete

    I’m not sure if all of them have to be checked, but I did it at my first go and installation was a success!

    Well, I hope this helps someone in the future.

    CHEERS 🙂

Viewing 1 replies (of 1 total)

The topic ‘Database Error’ is closed to new replies.