How to run mysql on an ec2 instance on Amazon Web Services?

The fact that this server is on EC2 is irrelevant. SUSE and MySQL do not know this. Amazon cannot block anything, you have root access to the server.

You recover/change the root password the same as any server, with mysqladmin, or by starting mysqld with --skip-grant-tables while you make the change.

I know, this isn't a direct answer to your question, but I would recommend using the AWS Relational Database Service. Amazon will host a MySQL database for you and take care of all the setup, maintenance, scaling, backup, etc. aws.amazon.com/rds.

1 ...at the equivalent cost of several equivalent servers of your own each month. – Dan Grossman Aug 5 '11 at 2:24 Amazon RDS is expensive if you just want to run a small instance of mysql database. – Sundar Aug 5 '11 at 12:24.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.