I have recorded an video to help you on lightsail server. In this video I explain how we can get an MySQL root user password for your lightsail instance.
After watching an video if you still have an query then post your query in comment I will help you on that.