Author Topic: MySQL user setup doesn’t have access to create tables  (Read 892 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
MySQL user setup doesn’t have access to create tables
« on: September 07, 2023, 06:47:32 PM »
Hello
I recive such an error for all the tables of the database when I want to install a new Wordpress:

 WordPress database error: [CREATE command denied to user 'salamzab_px'@'localhost' 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

 
As I asked  the error looks like the MySQL user setup doesn’t have access to create tables


CREATE command denied to user 'salamzab_pluy'@'localhost' for table 'wp_1users']

 How can I solve it?
Thanks for your attention and answer
I love CWP