Ayad knowledge base

1- stop mysql database from the services

2- save below code in this file mysql-init.txt in mysql directory under BIN

UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;
3-
C:\mysql\bin\mysql --init-file=C:\\mysql-init.txt

make sure the directory is mysql directory, may be the above directroy is not correct ,

Reference

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



								
				

					
						This entry was posted
												on Saturday, April 9th, 2011 at 8:54 pm						and is filed under DataBase.
						You can follow any responses to this entry through the RSS 2.0 feed.

													You can leave a response, or trackback from your own site.