Control Web Panel

WebPanel => MySQL => Topic started by: yeknafar on September 07, 2023, 06:47:32 PM

Title: MySQL user setup doesn’t have access to create tables
Post by: yeknafar 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

Title: Re: MySQL user setup doesn’t have access to create tables
Post by: overseer on September 07, 2023, 10:44:48 PM

https://docs.digitalocean.com/products/databases/mysql/how-to/modify-user-privileges/ (https://docs.digitalocean.com/products/databases/mysql/how-to/modify-user-privileges/)