mysql root password setting.

gistfile1.sql

start mysqld --skip-grant-tables

mysql -u root mysql

use mysql;
 select * from  user;


select * from user where user='root';
update user set password=PASSWORD('XXXXXX') where user='root';

 SET PASSWORD FOR root@"%"=PASSWORD('XXXXX');


SET PASSWORD FOR bitnami@"%"=PASSWORD('QQQQQQ');


SET PASSWORD FOR bitnami@"%"=PASSWORD('QQQQQQ');
update user set password=PASSWORD('QQQQQQ') where user='bitnami';


mysqldump -u bitnami -pQQQQQQ bitnami_redmine > redmine.dump
mysql -u bitnami -pQQQQQQ bitnami_redmine < redmine.dump