MySQL access for lab

mysql

#1

Hi i am getting below error for my username and unable to create database

I tried with
mysql -u retail_dba -h nn01.itversity.com -p itveristy

mysql> create table piyush_mock_orders as select * from orders;
ERROR 1142 (42000): INSERT, CREATE command denied to user ‘retail_dba’@‘gw03.itversity.com’ for table ‘piyush_mock_orders’

i also tried with create table piyush_mock_orders as select * from retail.db.orders; still same issue


#2

@pi_patel

There was a typo.

Use the following
mysql -u retail_dba -h nn01.itversity.com -p
itversity


#3

@pi_patel please visit the topic Unable to create database and tables in MySQL