Problem with WordPress Install – database user privileges

  • Hi!
    I recently upgraded my hosting package with Fasthost to include 3 domain names and 3 hosting. I already have a website https://www.klikadesign.com and this is the pack I upgraded.

    I now want to install WordPress for additional domain https://www.klikaboutique.com, which is part of the package above.

    But I get this error message:
    ‘WordPress database error: [CREATE command denied to user ‘……..’ for table ‘wp_users’]
    CREATE TABLE wp_users ( ID bigint(20) unsigned NOT NULL auto_increment, user_login varchar(60) NOT NULL default ”, user_pass varchar(255) NOT NULL default ”, user_nicename varchar(50) NOT NULL default ”, user_email varchar(100) NOT NULL default ”, user_url varchar(100) NOT NULL default ”, user_registered datetime NOT NULL default ‘0000-00-00 00:00:00’, user_activation_key varchar(255) NOT NULL default ”, user_status int(11) NOT NULL default ‘0’, display_name varchar(250) NOT NULL default ”, PRIMARY KEY (ID), KEY user_login_key (user_login), KEY user_nicename (user_nicename), KEY user_email (user_email) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    …….’
    There is more to this error message of course, which is very long and I’m sure some of you might be familiar with.
    So then I google this error and I found out that this error might be caused but my database user not having all privileges set up.

    So I went to PHPMyAdmin (through link on my Fasthost databases panel) to add all privileges to the database user but I can’t see anywhere a PRIVILAGES button nor the USER button. All I can see information_schema and name of my database on the left hand side.

    By the way: I tried to follow the famous 5 minutes install :
    https://codex.www.ads-software.com/Installing_WordPress#Famous_5-Minute_Install
    However the Using phpMyAdmin Point 2 – Click the phpMyAdmin icon in the upper left to return to the main page, then click the Users tab – is impossible as I don’t have the user button.

    Here is also mysql guide, which I tried to follow too but I’m stuck starting from page 6.
    https://help.fasthosts.co.uk/euf/assets/pdf-guides/mysql-quick-start-guide.pdf

    I don’t know what to do next. I didn’t have this kind of problems with previous websites I was working on, so I’m a bit lost.

    I don’t know much about coding and in depth technical issues. I looked through the forums and asked my web designer friends and they are stuck too.

    I’m working on mac, yosemite 10.10.

    I don’t know, what information you might need to help, so let me know.
    Thank you so much!
    Monika

Viewing 5 replies - 1 through 5 (of 5 total)

  • I just went to your new domain and it looks like the install needs to be completed. Is this where you are getting the error? When I go to the https://www.klikaboutique.com domain it gives you the typical install completion steps. Let me know if this is when you receive the error or if it has been corrected. If you still receive the error, I will try to assist as best I can. Cheers

    Thread Starter MonikaCieplinska

    (@monikacieplinska)

    Hi labcoatlackie, thanks for reply.
    Yes, that’s exactly where I’m lost.
    I choose the language, fill in the form with username, password etc after which I’m getting this long error message. I’m using mysql/phpmyadmin setup by my hosting company -fasthosts. Do I have to contact them or is it something I overlooked?
    Thanks!

    Personally, with that kind of error and without having access to the database myself, I would contact the host and have them kill the install. Remove the current install on that domain and start fresh with a new database. It does look like it is having issues with user permissions so it wont create the tables. The permission issue could be for several reasons that would be far too complicated to go through and you can go down a really long road banging your head against the wall trying to get it corrected yourself.

    On a side note, you shouldn’t have to do the 5 minute install on fasthost.com. I believe they have a one click WordPress install under their “app” section. I am not familiar enough with fasthost to know for sure where to locate the install, but it shouldn’t be too difficult to find when you log into your account.

    Thread Starter MonikaCieplinska

    (@monikacieplinska)

    Hi, Many thanks for your advise and help! I will contact them, I hope they can help out.
    Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Problem with WordPress Install – database user privileges’ is closed to new replies.