Xampp 1.8.3 with phpmyadmin 4.1.12 Storage Configuration NOT Complete

I recently installed the latest Xampp with phpMyAdmin version 4.1.12 and noticed the following error messages after the installation process:

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click [here].

… and clicking the link showed the following errors:

$cfg[‘Servers’][$i][‘users’] … not OK [ Documentation ]

$cfg[‘Servers’][$i][‘usergroups’] … not OK [ Documentation ] Configurable menus: Disabled

$cfg[‘Servers’][$i][‘navigationhiding’] … not OK [ Documentation ] Hide/show navigation items: Disabled

The fix is simple:

STEP1:

Run the following query on the phpmyadmin database:

==================== START ===================

CREATE TABLE IF NOT EXISTS `pma_users` (

  `username` varchar(64) NOT NULL,

  `usergroup` varchar(64) NOT NULL,

  PRIMARY KEY (`username`,`usergroup`)

  COMMENT=’Users and their assignments to user groups’

  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

 

CREATE TABLE IF NOT EXISTS `pma_usergroups` (

  `usergroup` varchar(64) NOT NULL,

  `tab` varchar(64) NOT NULL,

  `allowed` enum(‘Y’,’N’) NOT NULL DEFAULT ‘N’,

  PRIMARY KEY (`usergroup`,`tab`,`allowed`)

  COMMENT=’User groups with configured menu items’

  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

 

CREATE TABLE IF NOT EXISTS `pma_navigationhiding` (

  `username` varchar(64) NOT NULL,

  `item_name` varchar(64) NOT NULL,

  `item_type` varchar(64) NOT NULL,

  `db_name` varchar(64) NOT NULL,

  `table_name` varchar(64) NOT NULL,

  PRIMARY KEY (`username`,`item_name`,`item_type`,`db_name`,`table_name`)

  COMMENT=’Hidden items of navigation tree’

  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

==================== STOP ===================

STEP2:

Add the following lines to your phpMyAdmin config.inc.php file:

$cfg[‘Servers’][$i][‘users’] = ‘pma_users’;

$cfg[‘Servers’][$i][‘usergroups’] = ‘pma_usergroups’;

$cfg[‘Servers’][$i][‘navigationhiding’] = ‘pma_navigationhiding’;

STEP3:

Logout and log back into phpMyAdmin

That’s it!

Enjoy 😉

 

Update:

Upgrading to phpMyAdmin 4.2.5 caused a similar problem but with ONLY one error.

$cfg[‘Servers’][$i][‘savedsearches’] … not OK [ Documentation ] Saved searches: Disabled

The solution is simply the same as above…

Execute the following query:

==================== START ===================

CREATE TABLE IF NOT EXISTS `pma_savedsearches` (

  `id` int(5) unsigned NOT NULL auto_increment,

  `username` varchar(64) NOT NULL default ”,

  `db_name` varchar(64) NOT NULL default ”,

  `search_name` varchar(64) NOT NULL default ”,

  `search_data` text NOT NULL,

  PRIMARY KEY  (`id`),

  UNIQUE KEY `u_savedsearches_username_dbname` (`username`,`db_name`,`search_name`)

)

  COMMENT=’Saved searches’

  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

==================== STOP ===================

STEP2:

Add the following lines to your phpMyAdmin config.inc.php file:

$cfg[‘Servers’][$i][‘savedsearches’] = ‘pma_savedsearches’;

STEP3:

Logout and log back into phpMyAdmin


Posted in Vista, Web Design, Windows, Windows 7, Windows Vista, Windows XP and tagged , , , , , by with comments disabled.

How To Reset And Change Local Administrator Password On Remote Windows Systems

This tutorial will show you how to reset and change local administrator password on remote windows systems. This was tested on Windows XP and Windows 2003 server but should work on Vista/7/2008 operating systems.

STEPS:

1.) Download the official PsTools from microsoft directly or click here

2.) Extract the downloaded file to a folder called PsTools

3.) Just copy pspasswd.exe to your executable path “C:\Windows\System32”

4.) Open the prompt command line (star -> Run (type “cmd” + OK) and type in the following:

pspasswd \\{IP-Address} -u administrator -p {OldPasswd} administrator {NewPasswd}

whereby:

{OldPasswd} = Old Password

{NewPasswd} = New Password

{IP-Address} = System IP Address

Reset and Change Local Administrator Password On Remote Windows System

Typing “pspasswd” displays its usage syntax.

Usage: pspasswd [\\[computer[,computer,[,…]|Domain]|@file] [-u Username [-p Pa

ssword]]] Username [NewPassword]

     computer    Direct PsPasswd to perform the command on the remote

                 computer or computers specified. If you omit the computer

                 name PsPasswd runs the command on the local system,

                 and if you specify a wildcard (\\*), PsPasswd runs the

                 command on all computers in the current domain.

     @file       PsPasswd will change the password on the computers listed

                 in the file.

     -u          Specifies optional user name for login to remote

                 computer.

     -p          Specifies optional password for user name. If you omit this

                 you will be prompted to enter a hidden password.

     Username    Specifies name of account for password change.

     NewPassword New password. If ommitted a NULL password is applied.

Have fun 😉


Posted in Vista, Windows, Windows 7, Windows Vista, Windows XP and tagged , , , , by with comments disabled.

How To Remotely Enable Remote Desktop (RDP) Using PsExec

As in many situations the network administrator has task of connecting to remote systems to perform his duties. Ocassionally, the remote tasks become more difficult and frustrating when there are no remote tools available on the system and the remote desktop application is deactivated. Forturnately, Microsoft has provided a means for resolving such problems and therefore restoring back the hope of the administrator.

PsExec is one of the many PsTools Microsoft has provided for network administrors for the sole purpose of system administration. The following steps will show you how to activate RDP remotely from your local computer with the use of PsExec.

1.) Download the official PsTools either from microsoft directly or here

2.) Extract the downloaded file

3.) Just copy PsExec.exe from the extracted location into your executable path “C:\Windows\System32”.

4.) Open the prompt command line (start -> Run and type “cmd” + OK) and enter the following:

psexec -u {username} -p {password} \\{iP-Address} reg add “hklm\system\currentcontrolset\control\terminal server” /f /v fDenyTSConnections /t REG_DWORD /d 0

whereby:

{username} = Administrator (must be administrator)

{password} = Administrator’s password

{IP-Address} = System IP Address

psexec remote desktop activation

If not already enabled, use the following commands to enable RDP traffic through the windows firewall:

psexec \\ {iP-Address} netsh firewall set service remoteadmin enable

psexec \\ {iP-Address} netsh firewall set service remotedesktop enable

Note:

To deactivate RDP, just change “0” to “1”.

Typing “psexec” displays its usage syntax.

Usage: psexec [\\computer[,computer2[,…] | @file][-u user [-p psswd]][-n s][-l][-s|-e][-x][-i [session]][-c [-f|-v]][-w directory][-d][-<priority>][-a n,n,… ] cmd [arguments]

computer Direct PsExec to run the application on the computer or computers specified. If you omit the computer name PsExec runs the application on the local system and if you enter a computer name of “\\*” PsExec runs the applications on all computers in the current domain.

@file Directs PsExec to run the command on each computer listed in the text file specified.

-a Separate processors on which the application can run with commas where 1 is the lowest numbered CPU. For example, to run the application on CPU 2 and CPU 4, enter: “-a 2,4”

-c Copy the specified program to the remote system for execution. If you omit this option then the application must be in the system’s path on the remote system.

-d Don’t wait for application to terminate. Only use this option for non-interactive applications.

-e Does not load the specified account’s profile.

-f Copy the specified program to the remote system even if the file already exists on the remote system.

-i Run the program so that it interacts with the desktop of the specified session on the remote system. If no session is specified the process runs in the console session.

-l Run process as limited user (strips the Administrators group and allows only privileges assigned to the Users group). On Windows Vista the process runs with Low Integrity.

-n Specifies timeout in seconds connecting to remote computers.

-p Specifies optional password for user name. If you omit this you will be prompted to enter a hidden password.

-s Run remote process in the System account.

-u Specifies optional user name for login to remote computer.

-v Copy the specified file only if it has a higher version number or is newer on than the one on the remote system.

-w Set the working directory of the process (relative to the remote computer).

-x Display the UI on the Winlogon desktop (local system only).

-priority Specifies -low, -belownormal, -abovenormal, -high or -realtime to run the process at a different priority. Use -background to run at low memory and I/O priority on Vista.

Enjoy!


Posted in Windows, Windows 7, Windows Vista, Windows XP and tagged , , by with 3 comments.

How To Make Bootable USB-Drive For Windows Password & Registry Editor

If you forget your Windows password and wonder if you’ll ever have the chance to log into your system again, well… this might be helpful 😉

We’re going to use “Offline NT Password & Registry Editor” to reset the password of user(s) we want. This tool is one of the best and fastest password recovery tool for windows (almost all versions). It is a windows console tool and easy to use.

Offline NT Password & Registry Editor

Requirements:

a) USB-Drive (must NOT be formated but advisable)

b) USB-Drive formating tool (optional) found here

c) Offline NT Password & Registry Editor (USB version). Click here to download

 

STEPS:

Skip step 1 if you do NOT want to format the USB-Drive

1.) insert the USB-Drive into your computer and use the downloaded tool (b) above to format it. It is advisable to use FAT32 filesystem

2.) Unzip the download “Offline NT Password & Registry Tool” into a folder called “usb110511”

3.) copy all contents from the folder usb110511 into the root of the USB-Drive

4.) Install bootloader on the USB drive, from command prompt in windows (start the command line with “run as administrator” if possible)

5.) type X: + EnterKey (where X is the letter of your USB-drive) to change directory to the usb drive

6.) type X:\>syslinux.exe -ma X:

windows command prompt

That’s it!

Safely unplug the USB-Drive from the second computer and use it to boot your system with the lost password.

It might be neccessary to adjust your BIOS settings to allow booting from the USB-Drive

Follow the instructions carefully to reset your password. Most of the default settings is safe to accept by tapping on the EnterKey. Be carefull to select the correct Windows system partition otherwise it won’t work. In some systems (standard systems from dell, compaq etc), the first partition (/dev/sda) is usually reservered.

Enjoy and best of luck!


Posted in Vista, Windows, Windows 7, Windows Vista, Windows XP and tagged , , , by with 12 comments.

How to Remove WGA (Windows Genuine Activation) Notifications

For some reason, microsoft has decided to integrate this little application in Windows operating system. The problem is, even if you legitimately purchased your copy of the operating system, the nagging application doesn’t stop.

Follow these steps to remove this software:

1.) First you need to start your system in “safe mode”
2.) Search for all WGA files (wga*.*) and delete all entries (you may not be able to delete WgaTray.exe and two other entries. Don’t worry!!!)
3.) Click Start -> Run, enter “regedit” and press the ENTER-Key
4.) Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon\Notify
5.) delete WgaLogon folder
6.) Restart your computer (normal mode)
7.) Search again for WGA files (wga*.*) like in step 2
8.) delete all entries
9.) Restart your computer (normal mode)

You’re done!

All traces of WGA should be gone.


Posted in Vista, Windows, Windows 7, Windows Vista, Windows XP and tagged , , by with 2 comments.

Hibernate Your PC By Creating A Button on The Windows “Quick Launch” Toolbar

If you don’t know what hibernate is, please click here to read more about this very useful feature in Windows.

The Hibernate function in Windows XP Professional can make the batteries in your laptop computer last longer.

As there is no windows standard button for hibernate in Windows XP, we can create a custom button and place it on the “Quick Launch” toolbar. Follow these steps below:

1.) start the windows explorer by right clicking on “Start” and choosing “Explore”

2.) Navigate to “C:\Documents and Settings\username\My Documents” and create a folder called “MyScripts”

3.) In the folder “MyScripts”, create another folder called “Hibernate”

4.) Launch the “Notepad” (Start –> All Programs –> Accessories –> Notepad)

5.) Type the following in the new document:

@echo off
%windir%\system32\rundll32.exe powrprof.dll,SetSuspendState Hibernate
exit

6.) Save the file as “hibernate.bat” on this path:

“C:\Documents and Settings\stan\My Documents\MyScripts\hibernate.bat”

Don’t forget to choose “All Files” under “Save As Type”. Otherwise the file will be saved as a text file.

7.) Create a shortcut of the file “hibernate.bat” and place the shortcut in the folder “Hibernate” earlier on step 3.

8.) Ricght click on the shortcut and choose “Properties”.

9.) Choose to “Run” the script “Minimized”

10.) Click on “Change Icon” search the Icon of your choice. My choice is shown below:

11.) On the Windows “Toolsbar”, right click on it, navigate to “Toolsbar” and choose “New Toolbar”

12.) Navigate to the folder “Hibernate” and click on it. Click “OK” to Exit

13.) We are almost done! You can unlock your “Taskbar” and arrange the new Toolbar in any position you want.

14.) It looks very urgly for my taste. To make it look more nice, right click on the “Hibernate” Toolbar and remove the hack on “Show Text” and “Show Title” respectively.

15.) Just one more adjustment… Reduce the space occupied by the “Hibernate” Toolbar and lock the taskbar.

And the final result looks like this…

That’s it… Whenever you click on the Hibernate icon, your PC will hibernate and save you some battery consumption.

Enjoy!


Posted in Vista, Windows, Windows 7, Windows Vista, Windows XP and tagged , , by with 1 comment.

How to create and use a button on the shortcut panel to make Windows XP Hibernate

Let’s start by creating a small batch script in an editor. I’ll use Notepad but any editor of your choice can be used.

1. Click on the windows “Start” button

2. Point to Program => Accessories => Notepad and left click on it.

3. Enter the following in the new file:

@echo off
%windir%\system32\rundll32.exe PowrProf.dll,SetSuspendState
:eof
exit

4. Click on file on the top left of the editor and save the file as “hibernate.bat” on the desktop.

5. Create a new folder under “My Documents” and name it “MyScripts”

6. Copy the script “hibernat.bat” created ealier to “C:\\Documents and Settings\%username%\My Documents\MyScripts\”

Note: %username% = your username under which you’re login

7. Make a shortcut of the hibernate.bat file in the same folder MyScripts

8. Change the Symbol of the shortcut to whatever you want. But for the purpose of this tutorial, I’ll use the shutdown symbol.

9. While press-holding the “Ctrl” button, drag the shortcut from MyScripts folder to the shortcut panel as shown on the screenshot below.

Whenever you want to hibernate your “Windows XP”, just click the newly created button.

That’s it!


Posted in Windows, Windows XP and tagged , , , by with comments disabled.

How to recreate “Show Desktop” when all of a sudden it’s nowhere to be found!

It might be a liitle weird to post this here but believe me, it has happened to me before and I thought this might help someone.

Follow these steps to recreate “Show Desktop” shortcut on your Windows Quick Launch:

1. Click Start

2. Click Run

3. Type in “notepad”

4. Click “OK”

5. Copy and paste the follwing text inside the notepad document:

[Shell]
Command=2
IconFile=explorer.exe,3
[Taskbar]
Command=ToggleDesktop

6. Save the file as ShowDesktop.scf in C:\Dokument and Settings\%username%\Appdata\Microsoft\Internet Explorer\Quick Launch

When finished, it lokks like this:


Posted in Vista, Windows, Windows 7, Windows Vista, Windows XP and tagged , , by with comments disabled.

How To Use SCHTASKS

Create, delete, edit, list, start or stop a scheduled task.
Works on local or remote computers.
Syntax:

SCHTASKS /Create [Connect_Options] create_options

SCHTASKS /Delete [Connect_Options] /TN taskname [/F]

SCHTASKS /Query [Connect_Options] [/FO format] [/NH] [/V]

SCHTASKS /Run [Connect_Options] /TN taskname
SCHTASKS /End [Connect_Options] /TN taskname

SCHTASKS /Change [Connect_Options] {[/RU username] [/RP password] [/TR taskrun]} /TN taskname

Connect_Options:
/S system #remote system (default is local)
[/U username [/P password]] #submit job under this name

create_options:
[/RU username [/RP password]] #run job under this name
/SC schedule [/MO modifier] #When to run, see below
[/D day] #day = MON,TUE,WED,THU,FRI,SAT,SUN
[/M months] #month=JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC.
[/I idletime] #1 – 999 minutes (ONIDLE task only)
/TN taskname /TR taskrun #Name and pathname for task
/ST starttime #HH:MM:SS (24 hour)
[/SD startdate] [/ED enddate] #start and end date “dd/mm/yyyy”

options:
/F Force delete, ignore warnings even if the task is currently runnning.
/FO format Output format: TABLE, LIST, CSV
/NH No header
/V Verbose output
Notes:
For MONTHLY schedules give the DAY as a number 1 – 31 (default=1)

To prompt for the password, specify /RP * or /RP none
The User Account under which the Schedule service runs may require specific file access permissions, user permissions and drive mappings.
If the /RU username and /RP Password parameters match the currently logged-in user, the task will run interactively (visible in the foreground).

For the system account, /RU username can be written as “”, “NT AUTHORITY\SYSTEM” or “SYSTEM”, a Password is not required. The system account has full access to the local machine but has no permissions on any other machines (or mapped drives) across the Network.
/SC schedule The schedule frequency.
Valid schedules: MINUTE,HOURLY,DAILY,WEEKLY,MONTHLY, ONCE,ONSTART,ONLOGON,ONIDLE.

/MO modifiers allow finer control:

MINUTE: 1 – 1439 minutes.
HOURLY: 1 – 23 hours.
DAILY: 1 – 365 days.
WEEKLY: 1 – 52 weeks.
ONCE: No modifiers.
ONSTART: No modifiers.
ONLOGON: No modifiers.
ONIDLE: No modifiers.
MONTHLY: 1 – 12, or FIRST, SECOND, THIRD, FOURTH, LAST, LASTDAY.
Power Saving
The property for “Wake up the machine to run this task” cannot be set using schtasks, but this property is essential if you need the task to run on a machine that has PowerSaving enabled.
To work around this, create a task on one computer using the control panel GUI. This will create a .job file in C:\%windir%\Tasks\
To replicate the scheduled task onto other machines copy the .JOB file to C:\%windir%\Tasks on each machine.

This techique will not retain any system account credentials, so if you need to run the tasks under System, run the following after copying the .JOB file:
SCHTASKS /CHANGE /RU “NT Authority\System” /TN “Yourtaskname”
Examples:
Create a task to run at 11 pm every weekday
SCHTASKS /Create /SC weekly /D MON,TUE,WED,THU,FRI /TN MyDailyBackup /ST 23:00:00 /TR c:\backup.cmd /RU MyDomain\MyLogin /RP MyPassword
Now delete the task:
SCHTASKS /Delete /TN “MyDailyBackup” /f
Create a daily task to run a script at 5 pm:
SCHTASKS /create /tn “My Script” /tr “\”c:\my folder\script.cmd\” arguments” /sc daily /sd 12/29/2008 /st 17:00
Task Scheduler options are stored in the registry
HKLM\SOFTWARE\Microsoft\SchedulingAgent\


Posted in Vista, Windows, Windows 7, Windows Vista, Windows XP and tagged , by with 1 comment.

Here is how to activate Windows manually

We will be using the commandd line to start the activation program.

Windows (XP/Vista/7/2003/2008) will normally remind users to activate their product soon after installation. To activate Windows manually, you can use the Start menu shortcut in the System Tools Accessories folder. At the command prompt, type

oobe/msoobe /a

In case you’re wondering, msoobe stands for “Microsoft Out of Box Experience.”


Posted in Vista, Windows, Windows 7, Windows Vista, Windows XP and tagged , by with 4 comments.