buy hypertropin

Archive for the ‘DataBase’ Category


 Powered by Max Banner Ads 

reset mysql root password windows

Saturday, April 9th, 2011

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

Mysql load

Wednesday, January 12th, 2011

to detect the user that caused mysql to be high load

mysqladmin processlist

Thank you.

how to know MSSQL 2008 Edition

Sunday, August 29th, 2010

YOu need to run the command below then you will get the edition

SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

Thank you.

JSP connect to mysql

Saturday, June 12th, 2010

refer ot the url below

http://www.roseindia.net/jsp/connect-jsp-mysql.shtml

i have test it and it is working fine