mysql password

Reset:

stop server and run windows-console with Admin’s rights

«C:\Program Files\MySQLnew\MySQL Server 5.6\bin\mysqld» —defaults-file=»C:\ProgramData\MySQnewL\MySQL Server 5.6\my.ini» —init-file=C:\\mysql-init.txt

Change:

SET PASSWORD FOR root@localhost=PASSWORD(‘newpass’);

CREATE USER ‘jeffrey’@’localhost’ IDENTIFIED BY ‘mypass’;

or:

$ mysqladmin -u root -p oldpassword newpass

link link