Regarding mysql root password

mysql

#1

Hai,
I want to know the password for username root of mysql database for itversity big data labs.can u help me with this?


#2

@karthick_raja Users don’t have permission to access root user in MySQL.
If you want to connect MySQL in big data labs use command like below.

If you want to export and import tables you can use retail_export and retail_import databases.

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


#3

I want to copy files from MySQL into the local directory in big data labs.I executed the below query:

select * from categories into outfile ‘/tmp/categories01.psv’ fields terminated by ‘|’ lines terminated by ‘\n’;

But it is showing the following error:

ERROR 1045 (28000): Access denied for user ‘retail_dba’@’%’ (using password: YES)

can u tell me what is this error ?


#4

@karthick_raja You can try this command in your local machine. In big data labs it is restricted.