Mysql Doesnot create on staging site

  • HI
    I recive such a long error for all table of mysql on a staging wordpress site.the database is empty too.


    WordPress database error:     [CREATE command denied to user ‘salamzab_pluy’@’localhost’ for table ‘wp_termmeta’]
    CREATE TABLE wp_termmeta ( meta_id bigint(20) unsigned NOT NULL auto_increment, term_id bigint(20) unsigned NOT NULL default '0', meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (meta_id), KEY term_id (term_id), KEY meta_key (meta_key(191)) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

    WordPress database error: [CREATE command denied to user ‘salamzab_pluy’@’localhost’ for table ‘wp_terms’]
    CREATE TABLE wp_terms ( term_id bigint(20) unsigned 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), KEY slug (slug(191)), KEY name (name(191)) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

    Success!

    WordPress has been installed. Thank you, and enjoy!UsernameXlugPassword

    Your chosen password.

    • This topic was modified 1 year, 2 months ago by yeknafar.
Viewing 1 replies (of 1 total)

  • Hello @yeknafar

    The error you are getting looks like you need to update the user trying to create the MySQL tables, as that user doesn’t have the required permissions to create tables on the database environment you’re trying to set it up on.

    Are you trying to create a copy of your site on your web hosts staging environment, or on a local WordPress installation? If it’s with your web host, best to check with their support.

    If locally, how are you creating the staging copy of the site and what local WordPress installation software are you using?

Viewing 1 replies (of 1 total)
  • The topic ‘Mysql Doesnot create on staging site’ is closed to new replies.

Tags