Re: Carlos

[Shane Bester]

You can reset password by starting mysqld with --skip-grant-tables option.
Then login as run:

----
flush privileges;
select user,host,password from mysql.user where user='root';
update mysql.user set password=password('newpassword') where user='root';
----

then restart mysqld without the --skip-grant-tables option and login as root.


http://dev.mysql.com/doc/refman/5.6/en/resetting-permissions.html