What privileges does our lab account have in mysql and what's the password?


#1

I am following the 96 scenarios practices, one of the practices asks to make changes to a table in retail_db, as the retail_user I used to login has only read access to this database, I wonder if I can do it with the lab user credential? My attempt was denied:

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

Thank you.


#2

You can use the below command to connect to MySQL.

mysql -u retail_user -h ms.itversity.com -pitversity

You can utilize the retail_export database to make changes.


#3

OK, thanks. I didn’t reslize I can use retail_export database.