Connect to Retail_Export Database


#1

Hi

I want to create my own set of tables in a database and try some POCs

I understand RETAIL_DB is restricted and some forums say RETAIL_EXPORT can be used for custom tables.

But I am not able to login

[rajeshkancharla@gw01 ~]$ mysql -u retail_export -h nn01.itversity.com -p
Enter password:
ERROR 1045 (28000): Access denied for user ‘retail_export’@‘gw01.itversity.com’ (using password: YES)

Can you please help me connecting to RETAIL_EXPORT and create / insert / update data?

Regards
Rajesh K


#2

@rajeshkancharla To create your own tables you can create under retail_export and retail_import.

To connect mysql you can only use like below

mysql -u retail_dba -h nn01.itversity.com -p
password : itversity


#3

@BaLu_SaI - thanks very much for the info. I will try it to use those databases rather than connecting to them


#4