With root access to a server, how would I change mysql root password?

Question

Possible Duplicate:
How do I change the password of the root user in MySQL?

I have root access to an ec2 instance, but I don't know what the mysql root password is, which I need. How would I either 1) find this? or 2) re-install mysql and give myself a root password?

It could happily live here as well, though as @sarnold correctly points out it's an exact duplicate. — John Carter, May 29 '12 at 00:49

score 1 · Accepted Answer · answered May 29 '12 at 00:46

$ sudo service mysql stop
$ /usr/bin/mysqld_safe --skip-grant-tables &
mysql -h localhost
> use mysql
> update user set password = password('') where user = 'root' and host='localhost';
> quit
$ sudo service mysql start
$ mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.

With root access to a server, how would I change mysql root password?

1 Answers1