WAMP Server: Mysql login Error (Cant open phpmyAdmin)

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

This is very common error encountered while using WAMP server , its because you have not set mySql password and you need to set it first!

Solution :

1) Go to C:\wamp\bin\mysql\mysql5.1.36\bin\
2) mysql.exe -u root -p
3) mysql>
4) Type this query :
     update mysql.user set password=password('1234') where user='root';
5) flush privileges;
6) That's it! now u set password 1234 to mysql.
7) Now whenever you will establish connection with mysql from php pages you will need to provide this password 1234


Thank You,
Have A Nice Day!

Command not found (RHEL 5) chkconfig,service,ifconfig

Hi,

I know its very simple issue but important for beginneers ,
Many times some configuration changes in .bash_profile file may lead to these types of errors . .

As all your commands are there in /sbin/ if $PATH variable is not set properly then you may get this error...

Solution :

1) If you are logged in as root
2) cd ~
3) vim .bash_profile
4) export $PATH=/sbin
5) Thats it.! now you specified your system where to check for system commands!

Fireup your fav system command and check the output!

Enjoy!
Have a nice day!

Acunetix Vulnerability scanner 6 Full version

Hi,

Acunetix Vulnerability scanner 6 Full version : Download 

Thank You,
Have A nice day !

Advanced File Organizer 3.1

Hi,
A very gud software for those who need software to manage their data instead of moving it from one location to other ....
You can categorize your data like movies,softwares, blah blah blah...

http://www.warez-files.com/show-file-crack-kis11-0-1-400en.html

Download

If any queries then you can simply post me a comment !
Thank You,

Load and extract XML File data in Oracle

This is really nice thing we can do it in oracle , recently i encountered a situation where data came from XML File and need to load it in Table in oracle 10g , This was a good opportunity to learn this stuff ,

Here i have written a simple tutorial for beginners , how to load XML file data in Oracle 10g , there are others ways to do these things but this is good method to understand it for beginners like us!

You can download Tutorial from here

Download and playout with this data : download

Correct me if am wrong somewhere ,
You can always post your views and suggestions here on this blog ,

Thank You,

Have a nice day ,

Oracle Installation Problem : X11 problem

Most probably you will see this line in your error " X11 window server using '192.168.1.2:0.0' as the value of the DISPLAY variable "


This clearly says that problem is related to X11 . . .




Steps :
---------
1) Try executing xeyes as root and check wheather it shows or not . . 
2) now login as your oracle account as ,

    su - oracle


3) Try executing xeyes again if error pops up something like this :


    Xlib: connection to ":0.0" refused by server
    Xlib: No protocol specified

    Error: Can't open display: :0.0

4) Go ahed by firing :  xterm and you will see TERMINAL OPENED 

5) thats it now you can fire xeyes from that terminal 

6) run your oracle installer as  ./runInstaller

Thats It !

can't drop table

drop table xyz;

ORACLE SAYS : exact fetch returns more than requested number of rows ? ? ? how come . . .

yea, once i was playing with dual table and i inserted new row in a dual table which is why i can't drop this table xyz

to Add Rows in Dual table connect to sysdba

1) conn / as sysdba
2) insert into dual values('Z');


Now if you try to drop any table you will get above error to solve it just delete one row from dual table
as

delete from dual where dummy='Z'

Thats it! Now you can drop any table you want without any errors!
Thank You!