Reset mysql root password

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

IT WORKS!

In order to access the database through phpMyAdmin, you should change the password in phpmyadmin/config.inc.php ( $cfg['Servers'][$i]['password'] = ‘mysql_root_password’; ) to the same as mysql.

Set directory in xampp

Either set Apache to use the other directory as the home directory (in the config file) or put an index.html file in htdocs that has just a permanent redirect header to your real file.

Add comments to pages in wordpress

Add the following line in the Page.phpfile just before the <?php endwhile; endif; ?> :

<?php if ((‘open’ == $post-> comment_status)) { comments_template(); } ?>

and by choosing “Allow comments” when creating the page you can enable or disable comments in a certain page.

chm files: Page cannot be displayed

We’re dealing with this problem of not being able to read chm files on our lan. The server is Windows 2003 Server with SP1.

By now i’ve found out that on XP, by uninstalling the security update KB896358 and then restart, everythings works ok. I now can read chm over my network from Windows XP.

Still, the case of 2003 server remains unsolved.

2-column Match in Excel

Exact match on column values A1&B1 with 2 other columns:

(bool) =MATCH(1, (A1=Column1) * (B1=Column2),0)

Arithmetic on a boolean results in a number. eg. TRUE * FALSE = 0.
Only TRUE * TRUE will result in the “1″ MATCH is looking for.

(list of values for validation combobox) =OFFSET(Start_point,MATCH(1, (A1=Column1) * (B1=Column2), 0),1,COUNTIF(column2,A1),1)

IMPort Oracle

Case:

-created a new schema without data and need to import data into it from a dump

IMP userid=system/manager@DB file=D:\Full-SP4.dmp fromuser=LADORNA touser=COPIE ignore=Y grants=N buffer=4096000 log=D:\Import_COPIE.log
I get the following errors even if import goes ok.

IMP-00017: following statement failed with ORACLE error 20005:
“BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,’”ACS_ACCOUNTING_U1″‘,NULL,NULL,NULL”
“,3,1,3,1,1,1,0,6); END;”
IMP-00003: ORACLE error 20005 encountered
ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: at “SYS.DBMS_STATS”, line 1607
ORA-06512: at “SYS.DBMS_STATS”, line 2117
ORA-06512: at “SYS.DBMS_STATS”, line 5394
ORA-06512: at line 1

Merge si asa dar o tabela nu s-a imprtat. Am rulat din nou si a mers. E posibil s fie de la ordinea de import. Fac test acum cu import pe Constraint=N si apoi Constraint = Y.

Ramane de verificat si daca e de la export sa se fi facut without CONSISTENT=Y

import into your new database with rows=y constraints=n ignore=y
import from same export file rows=n contraints=y

Hello world!

Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!