phpmyadmin error #2002

#2002 - No connection could be made because the target machine actively refused it.

Solved

Modified appropriate line in config.inc.php line to $cfg['Servers'][$i]['auth_type'] = 'cookie'; (instead of 'config') and the system works fine.

Procedure to connect windows server2003 to client XP

Server side work

Step1:   Add Client machine to active directory users and computers =>Open admin tools => manage your server =>manage user and computers in active directory

Setp2: Servername=> builtin=> computers (right click)(computers right click) => new => computer

Setp3:  Provide computer name => next => next

Client side work

Setp4: Go to system properties => computer name => change –member of domain server name=> ok asks for server credentials provide it => welcome message appears

Setp5: Go to network neighborhood /my network places => tcp/ip => properties => preferred dns server ip (ip address of dns server ie., wi2003 server ip)

Setp6: Restart machine

Setp7: Logon => user name : user/admin => give password=> logon to =>server domain name

Password restrictions in windows server 2003

è        Start => admin tools => domain security policy => account policies => password policy => password meet complexity requirements (right click & disable it)

    

To import data from Excel to MySQL phpmyadmin.

used software: phpMyAdmin 3.1.1 and MySQL 5.1

 Save your Excel data as a csv file (In Excel 2007/2003 using Save As)

1. Check the saved file using a text editor such as Notepad to see what it actually looks like, i.e. what delimiter was used ex. : ; , etc.
2. Goto localhost-phpmyadmin, select required database and create a table with column crediantials.
3. Select the table and select the import tab then browse file to import.
4. Select the format of imported file .csv file, goto fields terminated by change your delimited symbol example ; or , which ever on your data mostly select , symbol there.
5. Click on go button.
6. Thats all your data sheet will be imported into mysql database

Hope this my help.

Regards
Janardhan