Error in creating table in mysql retail_db


#1

I am getting error in the following command:

CREATE command denied to user ‘retail_dba’@‘172.16.1.113’ for table ‘result’
mysql> create table db.result(
-> order_date varchar(255) not null,
-> order_status varchar(255) not null,
-> total_orders int,
-> total_amount numeric,
-> constraint pk_order_result primary key (order_date,order_status)
-> );
ERROR 1142 (42000): CREATE command denied to user ‘retail_dba’@‘172.16.1.113’ for table ‘result’


#2

Hi @shreshtha_sharma

You don’t have permission to create tables in retail_db database.
Use have access only for other database like retail_import or retail_export