Testcases Kaizen Group4

AppLabs Technologies

Test Case Summary

Last Update: mm/dd/yyyy

PIN: Developed By:

# Tests:

Execution Start Date : Execution End Date : Execution Build : #

AppLabs Technologies

Summary in Numbers

Summary in Percentage

Summary in Graphical View

214

Passed Cases

# Completed:

0

% Complete:

0.00%

# Passed:

0

% Passed:

#DIV/0!

0

% Failed:

#DIV/0!

% To be executed

100.00%

# Failed: # To be executed # Blocked:

214 0

System Test Cases

% Blocked:

Failed Cases

100.00%

To be executed Cases Blocked Cases

0.00%

Executed Test Cases are shaded in Red color Section

#Tests

Completed

Passed

Failed

Blocked

1. Edit Privileges

78

0

0

0

0

2.Privileges Home Page

28

0

0

0

0

3.AddNewUser

83

0

0

0

0

4.Database Specific Privileges

25

Doc Id: SPQ-T02 Proprietary Confidential

Page 1 of 65 V 2.1

AppLabs Technologies

System Test Cases

PIN:

Execution Section / Functionality:

Test Area:

Last Updated:

Method:

Executed Build Version:

TOTAL TESTS

TOTAL PERCENT

Doc ID:(SDP-STC-F-09) Version:1.0

# Tests:

78

# Completed:

0

% Complete:

0%

P = Passes test cases.

# Passed:

0

% Passed:

0%

F = Failed test cases.

# Failed:

0

% Failed:

0%

# Blocked:

0

% Blocked:

0%

Test Case id

Status Defect #

Status:

Title

Precondition for the tests below the user with all privileges. home page should be opened

B = Blocked test cases because of other bug/functionality. Defect # => Tracking number for the defect test cases. Steps

Expected Result

Comments

Requiremen t / Use Case ID

Testing Method

OS

Browsers

Designed By

1.Login as 2.The "phpMyAdmin"

Edit_ppg_001

To Check the functionality of 1.Select the user. "Edit Privileges" for a 2.Click on "Edit Privileges" on that particular particular user. user.

It must display the Edit Privileges page.

Edit_ppg_002

To Check the functionality of "Check All" which is under Edit Privileges page--> Edit Privileges--> Global Privileges.

1.Select the user. 2.Click on "Edit Privileges" on that particular user. 3.Click on "Check All" which is under Privileges page--> Edit Privileges--> Global Privileges.

Edit_ppg_003

To Check the functionality of "Check All & Go" which is under Edit Privileges page-> Edit Privileges--> Global Privileges.

1.Select the user. 2.Click on "Edit Privileges" on that particular user 3.Click on "Check All" which is under Edit Privileges page-->Edit Privileges--> Global Privileges. 4.Click on "Go".

Then it must display "ALL PRIVILEGES" under "Global Privileges" field to that particular user & it must also generate the SQL query.

Edit_ppg_004

To Check the functionality of "Uncheck All" which is under Edit Privileges page--> Edit Privileges--> Global Privileges.

1.Select the user. 2.Click on "Edit Privileges" on that particular user 3.Click on "Check All" which is under Edit Privileges page--> Edit Privileges--> Global Privileges.

Then all the check boxes in "Data","Structure" & "Administration" under "Global Priviliges" are not selected.

Edit_ppg_005

To Check the functionality of "Uncheck All & Go" which is under Edit Privileges page--> Edit Privileges--> Global Privileges.

1.Select the user. 2.Click on "Edit Privileges" on that particular user 3.Click on "Uncheck All" which is under Edit Privileges page--> Edit Privileges--> Global Privileges. 4.Click on "Go".

Then it must display "USAGE" "Global Privileges" field to that particular user under & it must also generate the SQL query.

Edit_ppg_006

To Check the functionality of only one check box in "Data" field which is under Edit Privileges page--> Edit Privileges--> Global Privileges.

1.Select the user 2.Click on "Edit Privileges" on that particular user 3.Select any one check box from "Data" field which is under Edit Privileges page--> Edit Privileges-->Global Privileges. 4.Click on "Go".

The selected privilege must be updated & SQL query must be generated.

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Then all the check boxes in "Data","Structure" & "Administration" under "Global Priviliges" must be Edit selected.

Edit_ppg_007

To Check the functionality of multiple check boxes in "Data" field which is under Edit Privileges page--> Edit Privileges--> Global Privileges.

1.Select the user. The selected privileges must be 2.Click on "Edit Privileges" on that particular updated & SQL query must be user 3.Select generated. multiple check boxes from "Data" field which is under Edit Privileges page--> Edit Privileges--> Global Privileges. 4.Click on "Go".

Edit_ppg_008

To Check the functionality of only one check box in "Structure" field which is under Edit Privileges page--> Edit Privileges--> Global Privileges.

1.Select the user The selected privilege must be 2.Click on "Edit Privileges" on that particular updated & SQL query must be user 3.Select any one check box from generated. "Structure" field which is under Edit Privileges page--> Edit Privileges--> Global Privileges. 4.Click on "Go".

Edit_ppg_009

Checking the functionality of multiple check boxes in "Structure" field which is under Edit Privileges page--> Edit Privileges--> Global Privileges.

1.Select the user. 2.Click on "Edit Privileges" on that particular user 3.Select multiple check boxes from "Structure" field which is under Edit Privileges page--> Edit Privileges--> Global Privileges. 4.Click on "Go".

Edit_ppg_010

Checking the functionality of only one check box in "Administration" field which is under Edit Privileges page--> Edit Privileges--> Global Privileges.

1.Select the user The selected privilege must be 2.Click on "Edit Privileges" on that particular updated & SQL query must be user 3.Select any one generated. check box from "Administration" field which is under Edit Privileges page--> Edit Privileges--> Global Privileges. 4.Click on "Go".

Edit_ppg_011

To Check the functionality of multiple check boxes in "Administration" field which is under Edit Privileges page--> Edit Privileges--> Global Privileges.

1.Select the user. The selected privileges must be 2.Click on "Edit Privileges" on that particular updated & SQL query must be user 3.Select multiple generated. check boxes from "Administrtion" field which is under Edit Privileges page--> Edit Privileges--> Global Privileges. 4.Click on "Go".

Edit_ppg_012

To Check the functionality of "Resource Limits" field which is under Edit Privileges page--> Edit Privileges--> Global Privileges.

1.Select the user. It must throw an error saying that 2.Click on "Edit Privileges" on that particular "MAX QUERIES PER HOUR" box will user. 3.Select the accepts only integer values. "Data","Structure" & "Administrator" in Edit Privileges page--> Edit Privileges--> Global Privileges. 4.Enter some characters in "MAX QUERIES PER HOUR" box under Resource Limits 5.Click on "Go"Button.

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

The selected privileges must be updated & SQL query must be generated.

Edit_ppg_013

To Check the functionality of "Resource Limits" field which is under Edit Privileges page--> Edit Privileges--> Global Privileges.

1.Select the user. It must throw an error saying that 2.Click on "Edit Privileges" on that particular "MAX UPDATES PER HOUR" box user. 3.Select the will accepts only integer values. "Data","Structure" & "Administrator" in Edit Privileges page--> Edit Privileges--> Global Privileges. 4.Enter some characters in "MAX UPDATES PER HOUR" box under Resource Limits 5.Click on "Go" Button.

Edit_ppg_014

To Check the functionality of "Resource Limits" field which is under Edit Privileges page--> Edit Privileges--> Global Privileges.

1.Select the user. 2.Click on "Edit Privileges" on that particular user. 3.Select the "Data","Structure" & "Administrator" in Edit Privileges page--> Edit Privileges--> Global Privileges. 4.Enter some characters in "MAX CONNECTIONS PER HOUR" box under Resource Limits 5.Click on "Go"Button

It must throw an error saying that "MAX CONNECTIONS PER HOUR" box will accepts only integer values.

Edit_ppg_015

To Check the functionality of all fields together which are under Edit Privileges page--> Edit Privileges--> Global Privileges.

1.Select the user. 2.Click on "Edit Privileges" on that particular user. 3.Select the "Data","Structure" , "Administrator" & "Resource Limits" fields in Edit Privileges page--> Edit Privileges--> Global Privileges. 4.Click on "Go"Button.

The newely selected Global Privileges must be updated to that particular user under "Global Privileges" field & must display the SQL query.

Edit_ppg_016

To Check the functionality of "Database-specific privileges" in Edit Privileges page.

1.Select the user. 2.Click on "Edit Privileges" on that particular user. 3.Select the Data Base in Edit Privileges page--> Databasespecific privileges. 4.Click on "Go" Button.

It should display the page that contains Edit Privileges & Table Specific Privileges for that particular database.

Edit_ppg_017

To Check the functionality of "Add privileges on the following database" in Edit Privileges page--> Databasespecific privileges.

1.Select the user. 2.Click on "Edit Privileges" on that particular user. 3.Select the database in Edit Privileges page--> Databasespecific privileges--> Add privileges on the following database. 4.Click on "GO" button. 5.It will display new page which contains the "Edit Privileges & Table Privileges" to that data base. 6.Select the check boxes in "Edit Privileges & Table Privileges" and press "Go" button.

Then that database privileges must be added with the entered database name under Edit Privileges page--> Database-specific privileges to that user.

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Edit_ppg_018

To Check the functionality of "Use text field" in Edit Privileges page--> Database-specific privileges--> Add privileges on the following database.

1.Select the user. 2.Click on "Edit Privileges" on that particular user. 3.Select the Use text field in Edit Privileges page--> Database-specific privileges--> Add privileges on the following database. 4.Enter the database name & press "Go". 5.It will display new page which contains the "Edit Privileges & Table Privileges" to that data base. 6.Select the check boxes in "Edit Privileges & Table Privileges" and press "Go" button.

Then that database privileges must be added under Edit Privileges page--> Database-specific privileges to that user.

Edit_ppg_019

To Check the functionality of "Edit" field in Edit Privileges page--> Database-specific privileges--> Action.

1.Select the user. It should display the page that contains 2.Click on "Edit Privileges" on that particular Edit Privileges & Table Specific user. 3.Select the any Privileges for that particular database. one Data Base in "Data base-specific privileges" in Edit Privileges page & click on Edit which is under Action field.

Edit_ppg_020

To Check the functionality of "Revoke" field in Edit Privileges page--> Database-specific privileges--> Action.

1.Select the user. It must delete the selected Datebase 2.Click on "Edit Privileges" on that particular from Database Specific Privileges. user. 3.Select the any one Data Base in "Data base-specific privileges in Edit Privileges page & click on Revoke which is under Action field.

Edit_ppg_021

To Check the functionality of 1.Select the user. radio button "No Password" 2.Click on "Edit Privileges" on that particular in Edit Privileges page--> user. 3.Select the "No Change password. Password" button in Edit Privileges page--> Change Password. 4.Click on "Go" Button.

It should display that the password is changed successfully & SQL query must be generated.

Edit_ppg_022

To Check the functionality of radio button " Password" in Edit Privileges page-> Change password.

It should display that the password is changed successfully & SQL query must be generated.

Edit_ppg_023

To Check the functionality of 1.Select the authorised user. It must ask for password to perform radio button " Password" in 2.Click on "Edit Privileges" on that any operation. Edit Privileges page-- user. 3.Select the > Change password. "Password" button & enter the password in "Change Password". 4.Click on "Go"Button. 5.Then password is changed successfully & it will display the SQL query. 6.Here perform any operation.

Giri Babu

1.Select the user. 2.Click on "Edit Privileges" on that particular user. 3.Select the "Password" button & enter the password in Edit Privileges page--> Change Password. 4.Click on "Go"Button.

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Edit_ppg_024

To Check the functionality of "Default Settings" in Edit Privileges page--> Change Login Information / Copy User.

1.Select the user. 2.Click on "Edit Privileges" on that particular user. 3.Check the "User Name" & "Host" in Edit Privileges page--> Change Login Information / Copy User.

The "User Name" & "Host" in Edit Privileges page--> Change Login Information / Copy User must be same as "User" & "Host" in privileges home page..

Edit_ppg_025

To Check the functionality of "User name" in Edit Privileges page--> Change Login Information / Copy User.

1.Select the user. It must create new user as "Any" in 2.Click on "Edit Privileges" on that particular Privileges page & must generate the user. 3.Select the SQL query. "Any user" in Edit Privileges page--> Change Login Information / Copy User-->User name. 4.Click on Go button.

Edit_ppg_026

To Check the functionality of "User name" in Edit Privileges page--> Change Login Information / Copy User.

1.Select the user. 2.Click on "Edit Privileges" on that particular user. 3.Select the "Use text field" in Edit Privileges page--> Change Login Information / Copy User -->User name. 4.Enter the name of user. 5.Click on Go button.

It must create new user in Privileges page with the given name & SQL query must be generated.

Edit_ppg_027

To Check the functionality of "Host" in Edit Privileges page--> Change Login Information / Copy User.

1.Select the user. 2.Click on "Edit Privileges" on that particular user. 3.Select the "Any host" in Edit Privileges page--> Change Login Information / Copy User -->Host. 4.Click on Go button.

It must create new user in Privileges page with the given name,host field must be displayed as % & SQL query must be generated.

Edit_ppg_028

To Check the functionality of "Host" in Edit Privileges page--> Change Login Information / Copy User.

1.Select the user. 2.Click on "Edit Privileges" on that particular user. 3.Select the "Local" in Edit Privileges page--> Change Login Information / Copy User -->Host. 5.Click on Go button.

It must create new user in Privileges page with the given name,host field must be displayed as localhost & SQL query must be generated.

Edit_ppg_029

To Check the functionality of "Host" in Edit Privileges page--> Change Login Information / Copy User.

1.Select the user. 2.Click on "Edit Privileges" on that particular user. 3.Select the "User Host Table" in Edit Privileges page--> Change Login Information / Copy Use -->Host. 4.Click on Go button.

It must create new user in Privileges page with the given name,nothing is displayed in host field & SQL query must be generated.

Edit_ppg_030

To Check the functionality of "Host" in Edit Privileges page--> Change Login Information / Copy User.

1.Select the user. 2.Click on "Edit Privileges" on that particular user. 3.Select the "Use text field" in Edit Privileges page--> Change Login Information / Copy User -->Host. 4.Enter the name. 5.Click on Go button.

It must create new user in Privileges page with the given name,host field as with the given name & SQL query must be generated.

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Edit_ppg_031

To Check the functionality of "Password" in Edit Privileges page--> Change Login Information / Copy User.

1.Select the user. It must create the new user as Any & 2.Click on "Edit Privileges" on that particular password field as yes with same user. 3.Select the privileges. User name as Any user ,host as Any host & password as "Donot change the password" in Edit Privileges page--> Change Login Information / Copy User -->Password. 4.Click on Go button.

Edit_ppg_032

To Check the functionality of "Password" in Edit Privileges page--> Change Login Information / Copy User.

1.Select the user. 2.Click on "Edit Privileges" on that particular user. 3.Select the User name as Any user ,host as Any host & password as "No password" in Edit Privvileges page--> Change Login Information / Copy User -->Password. 4.Click on Go button.

Edit_ppg_033

To Check the functionality of "Password" in Edit Privileges page--> Change Login Information / Copy User.

1.Select the user. It must create the new user as Any & 2.Click on "Edit Privileges" on that particular password field as yes with same user. 3.Select the User privileges. name as Any user ,host as Any host & password as "Use text field" in Edit Privileges page--> Change Login Information / Copy User ->Password. 4.Enter the text. 5.Click on Go button.

Edit_ppg_034

To Check the functionality of "Change Login Information / Copy User" in Edit Privilege page.

1.Select the user. It must create the new user with same 2.Click on "Edit Privileges" on that particular privileges and must keep the old one. user. 3.Select the user name ,host & password fields in Change Login Information / Copy User. 4.Select Create a new user with the same privileges and keep the old one. 5.Click on Go button.

Edit_ppg_035

To Check the functionality of "Change Login Information / Copy User" in Edit Privileges page.

1.Select the user. It must create the new user with same 2.Click on "Edit Privileges" on that particular privileges and must delete the old user. 3.Select the one from user tables. user name ,host & password fields in Change Login Information / Copy User. 4.Select Create a new user with the same privileges and delete the old one from the user tables. 5.Click on Go button.

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

It must create the new user as Any & password field as no with same privileges.

Edit_ppg_036

To Check the functionality of "Change Login Information / Copy User" in Edit Privileges page.

1.Select the user. 2.Click on "Edit Privileges" on that particular user. 3.Select the user name ,host & password fields in Change Login Information / Copy User. 4.Select Create a new user with the same privileges and revoke all active previleges from the old one and delete it after wards. 5.Click on Go button.

It must create the new user with same privileges and revoke all active previleges from the old one and delete it after wards.

Edit_ppg_037

To Check the functionality of "Change Login Information / Copy User" in Edit Privileges page.

1.Select the user. 2.Click on "Edit Privileges" on that particular user. 3.Select the user name ,host & password fields in Change Login Information / Copy User. 4.Select Create a new user with the same privileges and delete the old one from the user tables and reload the privileges afterwards. 5.Click on Go button.

It must create the new user with same privileges and delete the old one from the user tables and reload the privileges afterwards.

Manual

win xp

IE

Giri Babu

Manual

win xp

IE

Giri Babu

Precondition for the tests below 1.Login as the user with administration privileges.

Edit_ppg_037

2.The permissions set through the interface are updated successfully. 3.A query should be generated when a privilege is edited. Verify query generated after 1.Copy the "Select" query generated. editing Select privilege 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

A message showing 'Query executed successfully" should be displayed and the 'Select' privilege is added/removed from privilege table for the user intended in privileges page.. Prasad Babu

Edit_ppg_038

Verify query generated after 1.Copy the "Insert" query generated. editing Insert privilege 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

A message showing 'Query executed successfully" should be displayed and the 'Insert' privilege is added/removed from privilege table for the user intended in privileges page..

Edit_ppg_039

Verify query generated after 1.Copy the "Update" query generated. editing Update privilege 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

A message showing 'Query executed successfully" should be displayed and the 'Update' privilege is added/removed from privilege table for the user intended in privileges page..

Edit_ppg_040

Verify query generated after 1.Copy the "Delete" query generated. editing Delete privilege 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

A message showing 'Query executed successfully" should be displayed and the 'Delete' privilege is added/removed from privilege table for the user intended in privileges page..

Edit_ppg_041

Verify query generated after 1.Copy the "File" query generated. editing File privilege 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

A message showing 'Query executed successfully" should be displayed and the 'File'privilege is added/removed from privilege table for the user intended in privileges page..

Prasad Babu

Prasad Babu

Prasad Babu

Prasad Babu

Edit_ppg_042

Verify query generated after 1.Copy the "Create" query generated. editing Create privilege 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

A message showing 'Query executed successfully" should be displayed and the 'Create' privilege is added/removed from privilege table for the user intended in privileges page..

Edit_ppg_043

Verify query generated after 1.Copy the "Alter" query generated. editing Alter privilege 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

A message showing 'Query executed successfully" should be displayed and the 'Alter' privilege is added/removed from privilege table for the user intended in privileges page..

Edit_ppg_044

Verify query generated after 1.Copy the "Index" query generated. editing Index privilege 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

A message showing 'Query executed successfully" should be displayed and the 'Index' privilege is added/removed from privilege table for the user intended in privileges page..

Edit_ppg_045

Verify query generated after 1.Copy the "Drop" query generated. editing Drop privilege 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

A message showing 'Query executed successfully" should be displayed and the 'Drop' privilege is added/removed from privilege table for the user intended in privileges page..

Edit_ppg_046

Verify query generated after 1.Copy the "Create Temporary Tables" query editing Create Temporary generated. 2.Open the Tables privilege SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

A message showing 'Query executed successfully" should be displayed and the 'Create Temporary Tables' privilege is added/removed from privilege table for the user intended in privileges page..

Edit_ppg_047

Verify query generated after 1.Copy the "Grant" query generated. editing Grant privilege 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

A message showing 'Query executed successfully" should be displayed and the 'Grant' privilege is added/removed from privilege table for the user intended in privileges page..

Edit_ppg_048

Verify query generated after 1.Copy the "Super" query generated. editing Super privilege 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

A message showing 'Query executed successfully" should be displayed and the 'Super' privilege is added/removed from privilege table for the user intended in privileges page..

Edit_ppg_049

Verify query generated after 1.Copy the "Process" query generated. editing Process privilege 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

A message showing 'Query executed successfully" should be displayed and the 'Process' privilege is added/removed from privilege table for the user intended in privileges page..

Edit_ppg_050

Verify query generated after 1.Copy the "Reload" query generated. editing Reload privilege 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

A message showing 'Query executed successfully" should be displayed and the 'Reload' privilege is added/removed from privilege table for the user intended in privileges page..

Prasad Babu

Prasad Babu

Prasad Babu

Prasad Babu

Prasad Babu

Prasad Babu

Prasad Babu

Prasad Babu

Prasad Babu

Edit_ppg_051

Verify query generated after 1.Copy the "Shutdown" query generated. editing Shutdown privilege 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

A message showing 'Query executed successfully" should be displayed and the 'Shutdown' privilege is added/removed from privilege table for the user intended in privileges page..

Edit_ppg_052

Verify query generated after 1.Copy the "Show Databases" query editing Show Databases generated. 2.Open the privilege SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

A message showing 'Query executed successfully" should be displayed and the 'Show Databases' privilege is added/removed from privilege table for the user intended in privileges page..

Edit_ppg_053

Verify query generated after 1.Copy the "Lock Tables" query generated. editing Lock Tables privilege 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

A message showing 'Query executed successfully" should be displayed and the 'Lock Tables' privilege is added/removed from privilege table for the user intended in privileges page..

Edit_ppg_054

Verify query generated after 1.Copy the "References" query generated. editing References privilege 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

A message showing 'Query executed successfully" should be displayed and the 'References' privilege is added/removed from privilege table for the user intended in privileges page..

Edit_ppg_055

Verify query generated after 1.Copy the "Execute" query generated. editing Execute privilege 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

A message showing 'Query executed successfully" should be displayed and the 'Execute' privilege is added/removed from privilege table for the user intended in privileges page..

Edit_ppg_056

Verify query generated after 1.Copy the "Replication Client" query editing Replication Client generated. 2.Open the privilege SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

A message showing 'Query executed successfully" should be displayed and the 'Replication Client' privilege is added/removed from privilege table for the user intended in privileges page..

Edit_ppg_057

Verify query generated after 1.Copy the "Replication Slave" query editing Replication Slave generated. 2.Open the privilege SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

A message showing 'Query executed successfully" should be displayed and the 'Replication Slave' privilege is added/removed from privilege table for the user intended in privileges page..

Edit_ppg_058

Verify the functionality Select 1.Login as the user on which the privileges The privilege should be assigned privilege set for a particular are edited. sucessfully. user 2.Try to validate the Select privilege by firing the queries in sql window / through interface.

Prasad Babu

Edit_ppg_059

Verify the functionality Insert 1.Login as the user on which the privileges The privilege should be assigned privilege set for a particular are edited. sucessfully. user 2.Try to validate the Insert privilege by firing the queries in sql window / through interface.

Prasad Babu

Edit_ppg_060

Verify the functionality Update privilege set for a particular user

Prasad Babu

Prasad Babu

Prasad Babu

Prasad Babu

Prasad Babu

Prasad Babu

1.Login as the user on which the privileges The privilege should be assigned are edited. sucessfully. 2.Try to validate the Update privilege by firing the queries in sql window / through interface.

Prasad Babu

Prasad Babu

Edit_ppg_061

Verify the functionality Delete privilege set for a particular user

1.Login as the user on which the privileges The privilege should be assigned are edited. sucessfully. 2.Try to validate the Delete privilege by firing the queries in sql window / through interface.

Prasad Babu

Edit_ppg_062

Verify the functionality File privilege set for a particular user

1.Login as the user on which the privileges The privilege should be assigned are edited. sucessfully. 2.Try to validate the File privilege by firing the queries in sql window / through interface.

Prasad Babu

Edit_ppg_063

Verify the functionality Create privilege set for a particular user

1.Login as the user on which the privileges The privilege should be assigned are edited. sucessfully. 2.Try to validate the Create privilege by firing the queries in sql window / through interface.

Prasad Babu

Edit_ppg_064

Verify the functionality Alter privilege set for a particular user

1.Login as the user on which the privileges The privilege should be assigned are edited. sucessfully. 2.Try to validate the Alter privilege by firing the queries in sql window / through interface.

Prasad Babu

Edit_ppg_065

Verify the functionality Index 1.Login as the user on which the privileges The privilege should be assigned privilege set for a particular are edited. sucessfully. user 2.Try to validate the Index privilege by firing the queries in sql window / through interface.

Prasad Babu

Edit_ppg_066

Verify the functionality Drop 1.Login as the user on which the privileges The privilege should be assigned privilege set for a particular are edited. sucessfully. user 2.Try to validate the Drop privilege by firing the queries in sql window / through interface.

Prasad Babu

Edit_ppg_067

Verify the functionality Create Temporary Tables privilege set for a particular user

Edit_ppg_068

Verify the functionality Grant 1.Login as the user on which the privileges The privilege should be assigned privilege set for a particular are edited. sucessfully. user 2.Try to validate the Grant privilege by firing the queries in sql window / through interface.

Prasad Babu

Edit_ppg_069

Verify the functionality Super 1.Login as the user on which the privileges The privilege should be assigned privilege set for a particular are edited. sucessfully. user 2.Try to validate the Super privilege by firing the queries in sql window / through interface.

Prasad Babu

Edit_ppg_070

Verify the functionality Process privilege set for a particular user

1.Login as the user on which the privileges are edited. 2.Try to validate the Process privilege by firing the queries in sql window / through interface.

Edit_ppg_071

Verify the functionality Reload privilege set for a particular user

1.Login as the user on which the privileges The privilege should be assigned are edited. sucessfully. 2.Try to validate the Reload privilege by firing the queries in sql window / through interface.

1.Login as the user on which the privileges The privilege should be assigned are edited. sucessfully. 2.Try to validate the Create Temporary Tables privilege by firing the queries in sql window / through interface. Prasad Babu

The privilege should be assigned sucessfully.

Prasad Babu

Prasad Babu

Edit_ppg_072

Verify the functionality 1.Login as the user on which the privileges Shutdown privilege set for a are edited. particular user 2.Try to validate the Shutdown privilege by firing the queries in sql window / through interface.

The privilege should be assigned sucessfully.

Edit_ppg_073

Verify the functionality Lock Tables privilege set for a particular user

The privilege should be assigned sucessfully.

Edit_ppg_074

Verify the functionality 1.Login as the user on which the privileges References privilege set for are edited. a particular user 2.Try to validate the References privilege by firing the queries in sql window / through interface.

The privilege should be assigned sucessfully.

Edit_ppg_075

Verify the functionality Execute privilege set for a particular user

1.Login as the user on which the privileges are edited. 2.Try to validate the Execute privilege by firing the queries in sql window / through interface.

The privilege should be assigned sucessfully.

Edit_ppg_076

Verify the functionality Replication Client privilege set for a particular user

1.Login as the user on which the privileges are edited. 2.Try to validate the Replication Client privilege by firing the queries in sql window / through interface.

The privilege should be assigned sucessfully.

Edit_ppg_077

Verify the functionality Replication Slave privilege set for a particular user

1.Login as the user on which the privileges are edited. 2.Try to validate the Replication Slave privilege by firing the queries in sql window / through interface.

The privilege should be assigned sucessfully.

1.Login as the user on which the privileges are edited. 2.Try to validate the Lock Tables privilege by firing the queries in sql window / through interface.

Prasad Babu

Prasad Babu

Prasad Babu

Prasad Babu

Prasad Babu

Prasad Babu

Executed By

AppLabs Technologies

System Test Cases

PIN:

Execution Section / Functionality:

Test Area:

Last Updated:

Method:

Executed Build Version:

TOTAL TESTS

TOTAL PERCENT

Doc ID:(SDP-STC-F-09) Version:1.0

# Tests:

28

# Completed:

0

% Complete:

0%

P = Passes test cases.

# Passed:

0

% Passed:

0%

F = Failed test cases.

# Failed:

0

% Failed:

0%

# Blocked:

0

% Blocked:

0%

Test Case id

Status Defect #

Status:

Title

B = Blocked test cases because of other bug/functionality. Defect # => Tracking number for the defect test cases. Steps

Expected Result

The home page of phpMyAdmin 2.6.1-pl3 should be opened Ppg_01

Ppg_02

Ppg_03

To check the functionality of Click on the Privileges link Privileges link existed at middle portion of the home page

The privilege page should be opened To Check the functionality of Put the cursor on the localhost link localhost link To Check the functionality of Click on the localhost link localhost link

The system should display the privilege page that should contain Left Frame : 1)PhpMyadmin link 2)Pictorial linksforHome,Logout,Querywindow,PhpMyAdmin documentation,MySQL-Documentation 3)Database combobox 4)List of tables on that databaseTop portion : 1)Links : localhost 2)Tabs : Databases,Status,Variables,Charsets,Privileges,Processe s,Export and among these the Privileges tab should be darkened Middle Portion : 1)All alphabets among them some alphabets,numerics,special characters should be enabled depending on the Users first character/numeric/special character and a 'Show all' link should be there 2)A Privilege table with attributes of user,Host,Password,Global Privileges,Grant 3) check boxes on the left side of Users for selection and Edit Pivileges link on the right side of the Grant values 4)Check All,Uncheck All,Add a new User links below the table Bottom Portion :Remove selected User text ,below that three radio buttons ,one check box and Go button should be there

local host link color should be changed to red

The Homepage should be displayed

Comments

Requiremen t / Use Case ID

Testing Method

OS

Ppg_04

To Check the functionality of Click on the Database tab Databases tab

The database page should be displayed which should contain Left Frame : 1)PhpMyadmin link 2)Pictorial links fo rHome,Logout,Querywindow,PhpMyAdmin documentation,MySQL-Documentation 3)Database combobox 4)List of tables on that database Top portion : 1)Links : localhost 2)Tabs : Databases,Status,Variables,Charsets,Privileges,Processe s,Export and among these the Databases tab should be darkened Middle Portion : 1)Links :Database , the database names which are on the Database combobox ,Check All,Uncheck All,Enable Statistics,Check Priviliges icons on the right side of each database name 2)Check boxes on the left side of Database names for selection purpose 3)Drop button for dropping the selected database Bottom Portion : A textbox,Collation combobox,Create button in sequence for creating the new database

Ppg_05

To Check the functionality of Click on the Statistics tab Statistics tab

The Statistics page should be displayed which should contain Left Frame : 1)PhpMyadmin link 2)Home,Logout,Querywindow,PhpMyAdmin documentation,MySQL-Documentation icons 3)Database combobox4)List of tables on that database Top portion : 1)Links : localhost 2)Tabs : Databases,Status,Variables,Charsets,Privileges,Processe s,Export and among these the Statistics tab should be darkened Middle Portion : Runtime Information tables Bottom Portion : InnoDB Status link

Ppg_06

To Check the functionality of Click on the Variables tab Variables tab

The Variables page should be displayed which should contain Left Frame : 1)PhpMyadmin link 2)Home,Logout,Querywindow,PhpMyAdmin documentation,MySQL-Documentation icons 3)Database combobox4)List of tables on that database Top portion : 1)Links : localhost 2)Tabs : Databases,Status,Variables,Charsets,Privileges,Processe s,Export and among these the Variables tab should be darkened Middle Portion : Server variables and settings table

Ppg_07

To Check the functionality of Click on the Charsets tab Charsets tab

The Charsets page should be displayed which should contain Left Frame : 1)PhpMyadmin link 2)Pictorial links fo rHome,Logout,Querywindow,PhpMyAdmin documentation,MySQL-Documentation 3)Database combobox4)List of tables on that database Top portion : 1)Links : localhost 2)Tabs : Databases,Status,Variables,Charsets,Privileges,Processe s,Export and among these the Charsets tab should be darkened Middle Portion : Character Sets and Collations table

Ppg_08

To Check the functionality of Click on the Processes tab Processes tab

The Processes page should be displayed which should contain Left Frame : 1)PhpMyadmin link 2)Pictorial links fo rHome,Logout,Querywindow,PhpMyAdmin documentation,MySQL-Documentation 3)Database combobox4)List of tables on that database Top portion : 1)Links : localhost 2)Tabs : Databases,Status,Variables,Charsets,Privileges,Processe s,Export and among these the Processes tab should be darkened Middle Portion : Processes list with Kill tab

Ppg_09

To Check the functionality of Click on the Export tab Export tab

The Processes page should be displayed which should contain Left Frame : 1)PhpMyadmin link 2)Home,Logout,Querywindow,PhpMyAdmin documentation,MySQL-Documentation icons 3)Database combobox4)List of tables on that database Top portion : 1)Links : localhost 2)Tabs : Databases,Status,Variables,Charsets,Privileges,Processe s,Export and among these the Export tab should be darkened Middle Portion : Many fields for Viewing dump (schema) of databases,saving as files

Ppg_10

To Check the functionality of 1) Click on the enabled(blue colored) the enabled alphabets in the alphabet/numeric/special cahracter Privilege link

1)The user names starting with clicked alphabet/numeric/special character only should be displayed with their privelege table

Ppg_11

To Check the functionality of 1) Click on the Show all link the Show all link

1)All user names should be displayed with their privilege table

Ppg_12

To Check the functionality of Click on the Edit Privileges link the Edit Privileges link

A page containing fields for editing privileges,databasespecific privileges,changing password,changing login information/copy user should be displayed

Ppg_13

To Check the functionality of Click on the Check All link Chech All link

All the radio buttons on the left of the users should be selected

Ppg_14

To Check the functionality of Click on the Uncheck All link Uncheck All link

All the radio buttons on the left of the users should be unselected

Ppg_15

Check the functionality of the click on the Add a new User link Add a new User link Check the functionality of Click on the PhpMyAdmin link PhpMyAdmin link

A page containing fields for giving Login information,global privileges should be displayed. The www.Phpmyadmin.net web page should be displayed

Check the functionality of Home icon

The home page should be displayed

Ppg_16

Ppg_17

Click on the Home icon

Ppg_18

Check the functionality of Log Out icon

Click on the Log Out icon

The user should be able to Log Out

Ppg_19

Check the functionality of Query Window icon

Click on the Query Window icon

The system should display the query window

Ppg_20

Check the functionality of PhpMyAdmin Documentation icon

Click on the PhpMyAdmin Documentation icon

phpMyAdmin 2.6.1-pl3 Documentation should be displayed

Ppg_21

Check the functionality of SQL- Documentation icon

Click on the SQL- Documentation icon

The dev.mysql.com/doc/refman/5.0/en/ web page should be displayed

Ppg_22

Select the database from Databases drop down list box

Click on the drop down list of Databases and select a database from the list

The selected database and tables in it should be displayed on the left pane and the selected database page should be displayed

1)Previlige page should be opened 2)Users should be selected in the Previlege table Ppg_23

Ppg_24

Check the functionality of the Select the Just delete the users from the Just delete the users from privilege tables and click on the Go button the privilege tables radio button

The selected users in the privilege table should be deleted

1)Previlige page should be opened 2)User having same name as database should exist and he should be selected in the Previlige table Check the functionality of the Select the Drop the databases that have the The database should be deleted from the database table Drop the databases that same names as the users check box and which is having same name as user. have the same names as click on the Go button the users check box

1) A new user with all privileges should be created and login as this user 2) privilege page should be opened Ppg_25

Check the functionality of Just delete the users from the privilege tables radio button for deleting the present login user

1)Select the present login user in the privilege The user name from the table should be deleted and the table 2) select the Just delete the users present login session should be expired from the privilege tables radio button and click on the Go button

Execute test case no : 3.4 should be executed Ppg_26

Check the functionality of Add a new User link

1)Click on the Add a new User link 2)Enter A message should display that 'user already exist' the Login information ,Global Privileges,Resouce limits as the present login user and click on the Go button

1) User with all privileges should be existed 2you should login as that user 3) Privilege Page should be opened

Ppg_27

To verify the changes of privileges of user

1)Click on the Edit Privileges of the user through which you had logged in 2)Click on the Uncheck all link 3)Select some Privileges in the Global Privileges and click on the Go button 4)Click on the Privileges tab in that page

1)Edit privilege should be opened with all Global Privileges selected 2)All the Privileges should be unselected 3)SQL query for that selection should be displayed on that page 4)The Privilege Page should be opened

1) User with all privileges should be existed 2)you should login as that user 3) Privilege Page should be opened Ppg_28

To verify the changes of privileges of a user

1)Click on the Edit Privileges of the user through which you had logged in 2)Click on the Uncheck all link 3)Select some Privileges in the Global Privileges and click on the Go button 4)Click on the Home icon

1)Edit privilege should be opened with all Global Privileges selected 2)All the Privileges should be unselected 3)SQL query for that selection should be displayed on that page 4)The Home Page should be opened

Browsers

Designed By

Executed By

AppLabs Technologies

System Test Cases

PIN:

Execution Section / Functionality:

Test Area:

Last Updated:

Method:

Executed Build Version:

TOTAL TESTS

TOTAL PERCENT

Doc ID:(SDP-STC-F-09) Version:1.0

# Tests:

83

# Completed:

0

% Complete:

0%

P = Passes test cases.

# Passed:

0

% Passed:

0%

F = Failed test cases.

# Failed:

0

% Failed:

0%

# Blocked:

0

% Blocked:

0%

Test Case id

Status Defect #

Status:

Title

B = Blocked test cases because of other bug/functionality. Defect # => Tracking number for the defect test cases. Steps

Precondition for the test cases are: 'PhpMyadmin' home page should be opened. 'user' who have all privileges. 'privileges' tab should be selected. user' page should be opened.

Expected Result

Comments

Requiremen t / Use Case ID

Testing Method

OS

Browsers

Designed By

1. The 2. Login as a 3. The 4. 'Add a new

Adduser_01

Check the functionality of the 1.Click on the drop down button which is of drop down list 'User name' 'User name' field. 2. Select one of the option from list either 'Use text field' or 'Any user'.

1.The drop down list should be opened with the options 'Use text field' and 'Any user'. 2.The selected option should be highlighted.

Manual

Windows XP

IE 6.0

S.N.Prasad

Adduser_02

Check the functionality of the 1.Click on the drop down button which is of drop down list of 'Host' option 'Host' field. 2. Select one of the option from list 'Any Host', 'Local', 'Use host table' or 'Any user'.

1.The drop down list should be opened with the options 'Any host',' Local', 'Use host table ' and 'Use text field'. 2. The selected option should be highlighted.

Manual

Windows XP

IE 6.0

S.N.Prasad

Adduser_03

Check the functionality of the 1.Click on the drop down button which is of drop down list of 'Password' the 'Password' field. 2. Select one of the option from list either 'Use text field' or 'No password'.

1.The drop down list should be opened with the options 'Use text field' and 'No Password'. 2. The selected option should be highlighted.

Manual

Windows XP

IE 6.0

S.N.Prasad

Adduser_04

Verify the functionality of 'Check all'

1. Click on the 'Check all' link in the 'Global Privileges' section

1. All the check boxes which are present under 'Global Privileges' should be selected..

Manual

windows Xp

IE 6.0

S.N.Prasad

Adduser_05

Verify the functionality of 'UnCheck all'

1. Click on the 'Uncheck all' link in the 'Global 1. All the check boxes which are Privileges' section present under 'Global Privileges' should be unselected.

Manual

windows Xp

IE 6.0

S.N.Prasad

Adduser_06

verify the functionality of 'Select' privilege.

1.Give the username,host,password for the new user 2.Click on the 'Select' check box in Data section under Global Privileges. 3. Click on the 'Go' button

1. A message 'You have added a new user' and Sql query should be displayed on the same page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_07

Verify query generated,after 1.Copy the 'Select' query generated. editing 'Select' privilege. 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

1. A message showing 'Query executed successfully" should be displayed and the 'Select' privilege is added/removed from privilege table for the user intended in privileges page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_08

verify the functionality of 'Select' privilege

1.Give the username,host,password for new 1. The new user name and the user. related privileges should be 2.Click on the 'Select' check box in Data displayed in the 'Privileges' tab section under Global Privileges. 3. Click on the 'Go' button 4. Click on the 'Privileges' tab

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_09

verify the functionality of 'Insert' privilege

1.Give the username,host,password for the new user 2.Click on the 'Insert' check box in Data section under Global Privileges. 3. Click on the 'Go' button

1. A message 'You have added a new user' and Sql query should be displayed on the same page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_10

Verify query generated after 1.Copy the 'Insert' query generated. editing 'Insert' privilege 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

1. A message showing 'Query executed successfully" should be displayed and the 'Insert' privilege is added/removed from privilege table for the user intended in privileges page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_11

verify the functionality of 'Insert' privilege

1.Give the username,host,password for new 1. The new user name and the user. related privileges should be 2.Click on the 'Insert' check box in Data displayed in the 'Privileges' tab section under Global Privileges. 3. Click on the 'Go' button 4. Click on the 'Privileges' tab

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_12

verify the functionality of 'Update' privilege.

1.Give the username,host,password for the new user 2.Click on the 'Update' check box in Data section under Global Privileges. 3. Click on the 'Go' button

1. A message 'You have added a new user' and Sql query should be displayed on the same page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_13

Verify the query generated after editing 'Update' privilege.

1.Copy the 'Update' query generated. 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

1. A message showing 'Query executed successfully" should be displayed and the 'Update' privilege is added/removed from privilege table for the user intended in privileges page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_14

verify the functionality of 'Update' privilege . .

1.Give the username,host,password for new 1. The new user name and the user. related privileges should be 2.Click on the 'Update' check box in Data displayed in the 'Privileges' tab section under Global Privileges. 3. Click on the 'Go' button 4. Click on the 'Privileges' tab

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_15

verify the functionality of 'Delete' privilege.

1.Give the username,host,password for the new user 2.Click on the 'Delete' check box in Data section under Global Privileges. 3. Click on the 'Go' button

1. A message 'You have added a new user' and Sql query should be displayed on the same page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_16

Verify that query generated 1.Copy the 'Delete' query generated. after editing 'Delete' privilege 2.Open the SQL window by to a new user is working clicking the 'Sql icon' in the left panel. properly. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

1. A message showing 'Query executed successfully" should be displayed and the 'Delete' privilege is added/removed from privilege table for the user intended in privileges page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_17

verify the functionality of 'Delete' privilege

Manual

Windows Xp

IE 6.0

S.N.Prasad

1.Give the username,host,password for new 1. The new user name and the user. related privileges should be 2.Click on the 'Delete' check box in Data displayed in the 'Privileges' tab section under Global Privileges. 3. Click on the 'Go' button 4. Click on the 'Privileges' tab

Adduser_18

verify the functionality of 'File' 1.Give the username,host,password for the 1. A message 'You have added a privilege . new user new user' and Sql query should be 2.Click on the 'File' check box in Data section displayed on the same page. under Global Privileges. 3. Click on the 'Go' button

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_19

Verify the query generated 1.Copy the "File" query generated. after editing 'File' privilege to 2.Open the SQL window by clicking a new user . the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_20

verify the functionality of 'File' privilege

1.Give the username,host,password for new 1. The new user name and the user. related privileges should be 2.Click on the 'File' check box in Data section displayed in the 'Privileges' tab under Global Privileges. 3. Click on the 'Go' button 4. Click on the 'Privileges' tab

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_21

verify the functionality of 'Create' privilege

1.Give the username,host,password for the new user 2.Click on the 'Create' check box in Data section under Global Privileges. 3. Click on the 'Go' button

1. A message 'You have added a new user' and Sql query should be displayed on the same page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_22

Verify the query generated after editing 'Create' privilege

1.Copy the 'Create' query generated. 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

1. A message showing 'Query executed successfully" should be displayed and the 'Create' privilege is added/removed from privilege table for the user intended in privileges page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_23

verify the functionality of 'Create' privilege

1.Give the username,host,password for new 1. The new user name and the user. related privileges should be 2.Click on the 'Create' check box in Data displayed in the 'Privileges' tab section under Global Privileges. 3. Click on the 'Go' button 4. Click on the 'Privileges' tab

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_24

verify the functionality of 'Alter' privilege

1.Give the username,host,password for the new user 2.Click on the 'Alter' check box in Data section under Global Privileges. 3. Click on the 'Go' button

1. A message 'You have added a new user' and Sql query should be displayed on the same page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_25

Verify the query generated after editing 'Alter' privilege to a new user

1.Copy the 'Alter' query generated. 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

1. A message showing 'Query executed successfully" should be displayed and the 'Alter' privilege is added/removed from privilege table for the user intended in privileges page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_26

verify the functionality of 'Alter' privilege

1.Give the username,host,password for new 1. The new user name and the user. related privileges should be 2.Click on the 'Alter' check box in Data displayed in the 'Privileges' tab section under Global Privileges. 3. Click on the 'Go' button 4. Click on the 'Privileges' tab

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_27

verify the functionality of 'Index' privilege

1.Give the username,host,password for the new user 2.Click on the 'Index' check box in Data section under Global Privileges. 3. Click on the 'Go' button

Manual

Windows Xp

IE 6.0

S.N.Prasad

1. A message showing 'Query executed successfully" should be displayed and the 'File' privilege is added/removed from privilege table for the user intended in privileges page.

1. A message 'You have added a new user' and Sql query should be displayed on the same page.

Adduser_28

Verify the query generated 1.Copy the 'Index' query generated. after editing 'Index' privilege 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

Adduser_29

verify the functionality of 'Index' privilege.

Adduser_30

1. A message showing 'Query executed successfully" should be displayed and the 'Index' privilege is added/removed from privilege table for the user intended in privileges page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

1.Give the username,host,password for new 1. The new user name and the user. related privileges should be 2.Click on the 'Index' check box in Data displayed in the 'Privileges' tab section under Global Privileges. 3. Click on the 'Go' button 4. Click on the 'Privileges' tab

Manual

Windows Xp

IE 6.0

S.N.Prasad

verify the functionality of 'drop' privilege

1.Give the username,host,password for the 1. A message 'You have added a new user new user' and Sql query should be 2.Click on the 'drop' check box in Data section displayed on the same page. under Global Privileges. 3. Click on the 'Go' button

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_31

Verify the query generated after editing 'drop' privilege

1.Copy the 'drop' query generated. 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_32

verify the functionality of 'drop' privilege

1.Give the username,host,password for new 1. The new user name and the user. related privileges should be 2.Click on the 'drop' check box in Data section displayed in the 'Privileges' tab under Global Privileges. 3. Click on the 'Go' button 4. Click on the 'Privileges' tab

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_33

verify the functionality of 'Grant' privilege

1.Give the username,host,password for the new user 2.Click on the b check box in Data section under Global Privileges. 3. Click on the 'Go' button

1. A message 'You have added a new user' and Sql query should be displayed on the same page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_34

Verify the query generated 1.Copy the 'Grant' query generated. after editing 'Grant' privilege 2.Open the SQL window by to a new user clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

1. A message showing 'Query executed successfully" should be displayed and the 'Grant' privilege is added/removed from privilege table for the user intended in privileges page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_35

verify the functionality of 'Grant' privilege

1.Give the username,host,password for new 1. The new user name and the user. related privileges should be 2.Click on the 'Grant' check box in Data displayed in the 'Privileges' tab section under Global Privileges. 3. Click on the 'Go' button 4. Click on the 'Privileges' tab

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_36

verify the functionality of 'Super' privilege .

1.Give the username,host,password for the new user 2.Click on the 'Super' check box in Data section under Global Privileges. 3. Click on the 'Go' button

1. A message 'You have added a new user' and Sql query should be displayed on the same page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_37

Verify that query generated 1.Copy the 'Super' query generated. after editing 'Super' privilege 2.Open the SQL window by to a new user is working clicking the 'Sql icon' in the left panel. properly. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

1. A message showing 'Query executed successfully" should be displayed and the 'Super' privilege is added/removed from privilege table for the user intended in privileges page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

1. A message showing 'Query executed successfully" should be displayed and the 'drop' privilege is added/removed from privilege table for the user intended in privileges page.

Adduser_38

verify the functionality of 'Super' privilege .

1.Give the username,host,password for new 1. The new user name and the user. related privileges should be 2.Click on the 'Super' check box in Data displayed in the 'Privileges' tab section under Global Privileges. 3. Click on the 'Go' button 4. Click on the 'Privileges' tab

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_39

verify the functionality of 'Process' privilege .

1.Give the username,host,password for the new user 2.Click on the 'Process' check box in Data section under Global Privileges. 3. Click on the 'Go' button

1. A message 'You have added a new user' and Sql query should be displayed on the same page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_40

Verify the query generated after editing 'Process' privilege

1.Copy the "Process" query generated. 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

1. A message showing 'Query executed successfully" should be displayed and the 'Process' privilege is added/removed from privilege table for the user intended in privileges page.

Manual

Windows Xp

IE 6.0

Apuroop

Adduser_41

verify the functionality of 'Process' privilege

1.Give the username,host,password for new 1. The new user name and the user. related privileges should be 2.Click on the 'Process' check box in Data displayed in the 'Privileges' tab section under Global Privileges. 3. Click on the 'Go' button 4. Click on the 'Privileges' tab

Manual

Windows Xp

IE 6.0

Apuroop

Adduser_42

verify the functionality of 'Reload' privilege .

1.Give the username,host,password for the new user 2.Click on the 'Reload' check box in Data section under Global Privileges. 3. Click on the 'Go' button

1. A message 'You have added a new user' and Sql query should be displayed on the same page.

Manual

Windows Xp

IE 6.0

Apuroop

Adduser_43

Verify the query generated after editing 'Reload' privilege

1.Copy the 'Reload' query generated. 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

1. A message showing 'Query executed successfully" should be displayed and the 'Reload' privilege is added/removed from privilege table for the user intended in privileges page.

Manual

Windows Xp

IE 6.0

Apuroop

Adduser_44

verify the functionality of 'Reload' privilege

1.Give the username,host,password for new 1. The new user name and the user. related privileges should be 2.Click on the 'Reload' check box in Data displayed in the 'Privileges' tab section under Global Privileges. 3. Click on the 'Go' button 4. Click on the 'Privileges' tab

Manual

Windows Xp

IE 6.0

Apuroop

Adduser_45

verify the functionality of 'Shutdown' privilege .

1.Give the username,host,password for the 1. A message 'You have added a new user new user' and Sql query should be 2.Click on the 'Shutdown' check box in Data displayed on the same page. section under Global Privileges. 3. Click on the 'Go' button

Manual

Windows Xp

IE 6.0

Apuroop

Adduser_46

Verify that query generated after editing 'Shutdown' privilege to a new user

1.Copy the 'Shutdown' query generated. 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

Manual

Windows Xp

IE 6.0

Apuroop

Adduser_47

verify the functionality of 'Shutdown' privilege .

1.Give the username,host,password for new 1. The new user name and the user. related privileges should be 2.Click on the 'Shutdown' check box in Data displayed in the 'Privileges' tab section under Global Privileges. 3. Click on the 'Go' button 4. Click on the 'Privileges' tab

Manual

Windows Xp

IE 6.0

Apuroop

1. A message showing 'Query executed successfully" should be displayed and the 'Shutdown' privilege is added/removed from privilege table for the user intended in privileges page.

Adduser_48

verify the functionality of 1.Give the username,host,password for the 'Show Databases' privilege . new user 2.Click on the 'Show Databases' check box in Data section under Global Privileges. 3. Click on the 'Go' button

1. A message 'You have added a new user' and Sql query should be displayed on the same page.

Manual

Windows Xp

IE 6.0

Apuroop

Adduser_49

Verify the query generated after editing 'Show Databases' privilege

1.Copy the 'Show Databases' query generated. 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

1. A message showing 'Query executed successfully" should be displayed and the 'Show Databases' privilege is added/removed from privilege table for the user intended in privileges page.

Manual

Windows Xp

IE 6.0

Apuroop

Adduser_50

verify the functionality of 'Show Databases' privilege

1.Give the username,host,password for new user. 2.Click on the 'Show Databases' check box in Data section under Global Privileges. 3. Click on the 'Go' button 4. Click on the 'Privileges' tab

1. The new user name and the related privileges should be displayed in the 'Privileges' tab

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_51

verify the functionality of 'Lock Tables' privilege .

1.Give the username,host,password for the new user 2.Click on the 'Lock Tables' check box in Data section under Global Privileges. 3. Click on the 'Go' button

1. A message 'You have added a new user' and Sql query should be displayed on the same page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_52

Verify the query generated after editing 'Lock Tables' privilege to a new user

1.Copy the 'Lock Tables' query generated. 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

1. A message showing 'Query executed successfully" should be displayed and the 'Lock Tables' privilege is added/removed from privilege table for the user intended in privileges page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_53

verify the functionality of 'Lock Tables' privilege .

1.Give the username,host,password for new user. 2.Click on the 'Lock Tables' check box in Data section under Global Privileges. 3. Click on the 'Go' button 4. Click on the 'Privileges' tab

1. The new user name and the related privileges should be displayed in the 'Privileges' tab

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_54

verify the functionality of 'References' privilege .

1.Give the username,host,password for the 1. A message 'You have added a new user new user' and Sql query should be 2.Click on the 'References' check box in Data displayed on the same page. section under Global Privileges. 3. Click on the 'Go' button

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_55

Verify the query generated after editing 'References' privilege to a new user

1.Copy the 'References' query generated. 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_56

verify the functionality of 'References' privilege . .

1.Give the username,host,password for new 1. The new user name and the user. related privileges should be 2.Click on the 'References' check box in Data displayed in the 'Privileges' tab section under Global Privileges. 3. Click on the 'Go' button 4. Click on the 'Privileges' tab

Manual

Windows Xp

IE 6.0

S.N.Prasad

1. A message showing 'Query executed successfully" should be displayed and the 'References' privilege is added/removed from privilege table for the user intended in privileges page.

Adduser_57

verify the functionality of 'Execute' privilege .

1.Give the username,host,password for the new user 2.Click on the 'Execute' check box in Data section under Global Privileges. 3. Click on the 'Go' button

1. A message 'You have added a new user' and Sql query should be displayed on the same page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_58

Verify that query generated after editing 'Execute' privilege .

1.Copy the 'Execute' query generated. 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

1. A message showing 'Query executed successfully" should be displayed and the 'Execute' privilege is added/removed from privilege table for the user intended in privileges page.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_59

verify the functionality of 'Execute' privilege . .

1.Give the username,host,password for new 1. The new user name and the user. related privileges should be 2.Click on the 'Execute' check box in Data displayed in the 'Privileges' tab section under Global Privileges. 3. Click on the 'Go' button 4. Click on the 'Privileges' tab

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_60

verify the functionality of 1.Give the username,host,password for the 1. A message 'You have added a 'Replication Client' privilege . new user new user' and Sql query should be 2.Click on the 'Replication Client' check box displayed on the same page. in Data section under Global Privileges. 3. Click on the 'Go' button

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_61

Verify that query generated after editing 'Replication Client' privilege to a new user is working properly.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_62

verify the functionality of 1.Give the username,host,password for new 1. The new user name and the 'Replication Client' privilege . user. related privileges should be . 2.Click on the 'Replication Client' check box displayed in the 'Privileges' tab in Data section under Global Privileges. 3. Click on the 'Go' button 4. Click on the 'Privileges' tab

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_63

verify the functionality of 1.Give the username,host,password for the 1. A message 'You have added a 'Replication Slave' privilege . new user new user' and Sql query should be 2.Click on the 'Replication Slave' check box displayed on the same page. in Data section under Global Privileges. 3. Click on the 'Go' button

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_64

Verify that query generated after editing 'Replication Slave' privilege to a new user is working properly.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_65

verify the functionality of 1.Give the username,host,password for new 1. The new user name and the 'Replication Slave' privilege . user. related privileges should be . 2.Click on the 'Replication Slave' check box displayed in the 'Privileges' tab in Data section under Global Privileges. 3. Click on the 'Go' button 4. Click on the 'Privileges' tab

Manual

Windows Xp

IE 6.0

S.N.Prasad

1.Copy the 'Replication Client' query generated. 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

1.Copy the 'Replication Slave' query generated. 2.Open the SQL window by clicking the 'Sql icon' in the left panel. 3.Paste the copied query in 'SQL window.' 4.Click on the Go button

1. A message showing 'Query executed successfully" should be displayed and the 'Replication Client' privilege is added/removed from privilege table for the user intended in privileges page.

1. A message showing 'Query executed successfully" should be displayed and the 'Replication Slave' privilege is added/removed from privilege table for the user intended in privileges page.

Adduser_66

Check the functionality of 'add a new user'

1.Click on the drop down button which is of 'User name' 2. Select one of the option from list either 'Use text field' and give the new user name. 3. Select the 'host' as 'Any host' from the drop down list. 4. Select the 'No password' option from the drop down list under the 'Password'. 5. click on 'Go' button.

1. The new username should be accepted by giving the message as 'You have added a new user'.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_67

Check the functionality of 'add a new user'. Privileges ->Add a new user->Login Information by giving the existing 'login information'.

1.Click on the drop down button which is of 'User name' 2. Select one of the option from list either 'Use text field' and give the existing user name. 3. Select the 'host' as 'Any host' from the drop down list. 4. Select the 'No password' option from the drop down list under the 'Password'. 5. click on 'Go' button.

1. The new username should not be accepted by giving the message as 'The user already exist'.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_68

Check the functionality of the 'Max queries per hour' which is under the Resource limits by giving the correct value. Privileges ->Add a new user->Resource limits.

1.Give the username,host,password for new user. 2. Give the 'Max queries per hour' value between 0 to 2147483647. 3. Click on the 'Go' button.

1. The new user, Resource limits should be accepted by giving message 'You have added a new user'.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_69

Check the functionality of the 'Max queries per hour' which is under the Resource limits by giving the incorrect value i.e. above the limit. Privileges ->Add a new user>Resource limits

1.Give the username,host,password for new 1. The new user, Resource limits user. 2. should not be accepted by giving Give the 'Max queries per hour' value message error message like 'The between 2147483648 to 99999999999 include max limit is 2147483647' boundaries. 3. Click on the 'Go' button.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_70

Check the functionality of the 'Max updates per hour' which is under the Resource limits by giving the correct value. Privileges ->Add a new user->Resource limits.

1.Give the username,host,password for new user. 2. Give the 'Max updates per hour' value between 0 to 2147483647. 3. Click on the 'Go' button.

1. The new user, Resource limits should be accepted by giving message 'You have added a new user'.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_71

Check the functionality of the 'Max updates per hour' which is under the Resource limits by giving the incorrect value i.e. above the limit. Privileges ->Add a new user>Resource limits

1.Give the username,host,password for new 1. The new user, Resource limits user. 2. should not be accepted by giving Give the 'Max updates per hour' value message error message like 'The between 2147483648 to 99999999999 include max limit is only 2147483647' boundaries. 3. Click on the 'Go' button.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_72

Check the functionality of the 'Max connections per hour' which is under the Resource limits by giving the correct value. Privileges ->Add a new user->Resource limits.

1.Give the username,host,password for new user. 2. Give the 'Max connections per hour' value between 0 to 2147483647. 3. Click on the 'Go' button.

Manual

Windows Xp

IE 6.0

S.N.Prasad

1. The new user, Resource limits should be accepted by giving message 'You have added a new user'.

Adduser_73

Check the functionality of the 'Max connections per hour' which is under the Resource limits by giving the incorrect value i.e. above the limit. Privileges ->Add a new user>Resource limits

1.Give the username,host,password for new 1. The new user, Resource limits user. 2. should not be accepted by giving Give the 'Max connections per hour' value message error message like 'The between 2147483648 to 99999999999 include max limit is 2147483647' boundaries. 3. Click on the 'Go' button.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_74

Check the functionality of the 'Max queries per hour' which is under the Resource limits by giving the incorrect value i.e. alphabets or special characters only. Privileges ->Add a new user>Resource limits

1.Give the username,host,password for new user. 2. Give the 'Max queries per hour' like 'Abc' , '#&', 'A#p', '$uhj' so on. 3. Click on the 'Go' button.

1. The new user, Resource limits should not be accepted by giving message error message like 'The characters won't be accepted and it only accept numbers between 0 to 2147483647'

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_75

Check the functionality of the 'Max updates per hour' which is under the Resource limits by giving the incorrect value i.e. alphabets or special characters only. Privileges ->Add a new user>Resource limits

1.Give the username,host,password for new user. 2. Give the 'Max updates per hour' like 'Abc' , '#&', 'A#p', '$uhj' so on. 3. Click on the 'Go' button.

1. The new user, Resource limits should not be accepted by giving message error message like 'The characters won't be accepted and it only accept numbers between 0 to 2147483647'

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_76

Check the functionality of the 'Max connections per hour' which is under the Resource limits by giving the incorrect value i.e. alphabets or special characters only. Privileges ->Add a new user>Resource limits

1.Give the username,host,password for new user. 2. Give the 'Max connections per hour' like 'Abc' , '#&', 'A#p', '$uhj' so on. 3. Click on the 'Go' button.

1. The new user, Resource limits should not be accepted by giving message error message like 'The characters won't be accepted and it only accept numbers between 0 to 2147483647'

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_77

Check the functionality of the 'Username' by select the 'Any user'. Privileges-> Add a new user ->Login Information

1. Select the 'User name' as 'Any user'. 2. 1. The new username should be Select the host as 'Local',' Any host' or 'Use accepted by giving the message host table'. 3. as 'You have added a new user'. Select the 'Password' as 'No password'. 4. Click on 'Go' button.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_78

Check the functionality of the 'Username' by select the 'Use text field'. Privileges-> Add a new user ->Login Information

1. Select the 'User name' as 'Use text field' 1. The new username should be and give the new username in the text box. accepted by giving the message 2. as 'You have added a new user'. Select the host as 'Local',' Any host' or 'Use host table'. 3. Select the 'Password' as 'No password'. 4. Click on 'Go' button.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Adduser_79

Check the functionality of the 'Host' by select the 'Local'. Privileges-> Add a new user ->Login Information

1. Select the 'username' as 'User text field' 1. The new username should be and give the new username in the text box. 2. accepted by giving the message Select the 'Host' as 'Local' so that the text as 'You have added a new user'. box is filled by 'Local host'.

Manual

Windows Xp

IE 6.0

S.N.Prasad

3. Select the 'Password' as 'No password'. 4. Click on 'Go' button.

Adduser_80

Adduser_81

Adduser_82

Adduser_83

Check the functionality of the 'Password' by select the 'No Password'. Privileges-> Add a new user ->Login Information

1. Select the 'username' as 'User text field' 1. The new username should be and give the new username in the text box. 2. accepted by giving the message Select the 'Host' as 'Local' so that the text box as 'You have added a new user'. is filled by 'Local host'.

Check the functionality of the 'Password' by select the 'User test field' and give same password in both the text boxes of 'Password' and 'Re-type'. Privileges-> Add a new user ->Login Information

1. Select the 'username' as 'User text field' 1. The new username should be and give the new username in the text box. 2. accepted by giving the message Select the 'Host' as 'Local' so that the text box as 'You have added a new user'. is filled by 'Local host'.

Check the functionality of the 'Password' by select the 'User test field' by give the password correctly. Privileges-> Add a new user ->Login Information

1. Select the 'username' as 'User text field' 1. The new username should be and give the new username in the text box. 2. accepted by giving the message Select the 'Host' as 'Local' so that the text box as 'You have added a new user'. is filled by 'Local host'.

Check the functionality of the 'Password' by select the 'User test field' by give the password incorrectly. Privileges-> Add a new user ->Login Information

1. Select the 'username' as 'User text field' and give the new username in the text box. 2. Select the 'Host' as 'Local' so that the text box is filled by 'Local host'.

Manual

Windows Xp

IE 6.0

S.N.Prasad

Manual

Windows Xp

IE 6.0

S.N.Prasad

Manual

Windows Xp

IE 6.0

S.N.Prasad

Manual

Windows Xp

IE 6.0

S.N.Prasad

3. Select the 'Password' as 'No password'. 4. Click on 'Go' button.

3. Select the 'Password' as 'User test field' give the same password in 'password' text field and in 're-type' text box again. 4. Click on 'Go' button.

3. Select the 'Password' as 'User test field' give the same password in 'password' text field and in 're-type' text box again. 4. Click on 'Go' button.

3. Select the 'Password' as 'User test field' give the password in 'password' text field only or by enter the password not exactly in 're-type' text box again. 4. Click on 'Go' button.

1. The alert window should be accepted by giving the message as 'The password aren't the same' With 'Ok' and 'Close' buttons.

Executed By

AppLabs Technologies

System Test Cases

PIN: Test Area: Method: TOTAL TESTS

TOTAL PERCENT

# Tests:

25

# Completed:

0

% Complete:

# Passed:

0

% Passed:

# Failed:

0

% Failed:

# Blocked:

0

% Blocked:

Test Case id

Status

Defect Title #

Precondition for the tests below 1.User should exist. 2.Edit privileges page is opened. 3.Database should exist. dbppg_001

Navigate to the Database specific privileges page

dbppg_002

Navigate to the Database specific privileges page

dbppg_003

check the functionality of Edit Privileges window

dbppg_004

check the functionality of Edit Privileges window

dbppg_005

check the functionality of SELECT check box

dbppg_006

check the functionality of INSERT check box

dbppg_007

check the functionality of update check box

dbppg_008

check the functionality of DELETE check box

Check All

link in

Uncheck All

link in

dbppg_009

check the functionality of CREATE check box

dbppg_010

check the functionality of ALTER check box

dbppg_011

check the functionality of INDEX check box

dbppg_012

check the functionality of DROP check box

dbppg_013

check the functionality of TEMPORARY TABLES check box

dbppg_014

check the functionality of GRANT check box

dbppg_015

check the functionality of LOCK TABLES check box

dbppg_016

check the functionality of REFERENCES check box

dbppg_017

Table-specific privileges for Database

dbppg_018

Table-specific privileges for Database

dbppg_019

verify Table-specific privileges for sql server

CREATE

dbppg_020

verify GO button functionality

dbppg_021

verify Change password

dbppg_022

verify Change password

dbppg_023

verify Change password

dbppg_024

verify Change password

dbppg_025

verify Change password

System Test Cases Execution Section / Functionality: Last Updated: Executed Build Version: Doc ID:(SDP-STC-F-09) Version:1.0 Status: 0%

P = Passes test cases.

0%

F = Failed test cases.

0%

B = Blocked test cases because of other bug/functionality.

0%

Defect # => Tracking number for the defect test cases. Steps

Expected Result

1.Open the phpmyadmin homepage. Database specific privileges page 2.Click on Privileges option with different permissions should 3.Click on Edit privileges image next to the user name. 4.Select be opened. a database from the dropdown list under Database specific privileges section. 1.Open the phpmyadmin homepage. 2.Click on Privileges option 3.Click on Edit privileges image next to the user name. on next to the data base edit button

4click

Database specific privileges page with different permissions should be opened.

1.open the edit privileges window to the check all button the check all button

2.go check boxes should be selected 3.click on in the in the edit privileges window

1.open the edit privileges window to the check all button the check all button

2.go check boxes should be 3.click on unselected in the edit privileges section

1.open the edit privileges window to the select check box the check box go button

2.go "updated the privileges for existing 3.click on user" window should be opened 4.click on the ,the corresponding query should be generated and it should be updated with the select permission

1.open the edit privileges window to the insert check box the insert box go button

2.go "updated the privileges for existing 3.click on user" window should be opened 4.click on the ,the corresponding query should be generated and it should be updated with the Insert permission

1.open the edit privileges window to the update check box the update box go button

2.go "updated the privileges for existing 3.click on user" window should be opened 4.click on the ,the corresponding query should be generated and it should be updated with the Updated permission

1.open the edit privileges window to the delete check box the delete checkbox on the go button

2.go "updated the privileges for existing 3.click on user" window should be opened 4.click ,the corresponding query should be generated and it should be updated with the Delete permission

1.open the edit privileges window to the file CREATE box the CREATE box go button

2.go "updated the privileges for existing 3.click on user" window should be opened 4.click on the ,the corresponding query should be generated and it should be updated with the Create permission

1.open the edit privileges window to the file ALTER box on the ALTER box the go button

2.go "updated the privileges for existing 3.click user" window should be opened 4.click on ,the corresponding query should be generated and it should be updated with the Alter permission

1.open the edit privileges window 2.go to the file INDEX box 3.click on the INDEX box 4.click on the go button

"updated the privileges for existing user" window should be opened ,the corresponding query should be generated and it should be updated with the Index permission

1.open the edit privileges window 2.go to the file DROP box 3.click on the DROP box 4.click on the go button

"updated the privileges for existing user" window should be opened ,the corresponding query should be generated and it should be updated with the Drop permission

1.open the edit privileges window "updated the privileges for existing 2.go to the file CREATE TEMPORARY TABLES box user" window should be opened 3.click on the CREATE TEMPORARY TABLES box and it should be updated with the 4.click on the go button CREATE TEMPORARY TABLES permission 1.open the edit privileges window to the file GRANT box on the GRANT box on the go button

2.go "updated the privileges for existing 3.click user" window should be opened 4.click and it should be updated with the GRANT permission

1.open the edit privileges window to the file LOCK TABLES box 3.click on the LOCK TABLES box 4.click on the go button

2.go "updated the privileges for existing user" window should be opened and it should be updated with the LOCK TABLES permission

1.open the edit privileges window 2.go to the file REFERENCES box 3.click on the REFERENCES box 4.click on the go button

"updated the privileges for existing user" window should be opened and it should be updated with the REFERENCES permission

1.open the edit privileges window 2. Go to Add privileges on the following database 3.select the drop down list 4.select the apachelog web server

Database apachelog Edit Privileges should open with Table-specific privileges

1.open the edit privileges window Go to Add privileges on the following database 3.select the drop down list 4.select mysql server 1.open the edit privileges window 2.go to the Database mysql page 3.select one option from drop down list 4.click go

2. Database apachelog Edit Privileges should open with Table-specific privileges

Table host should display in the next page with Table-specific privileges window

1.open the edit privileges window to the go button 3.click on the button

2.go it should Navigate to the next page

1.open the edit privileges window 2.go to the change password 3.keep the change password empty 4.click go button

it should show the message "the password is empty "in the pop up window

1.open the edit privileges window 2.go to the change password 3.select the no password radio button 4.click go button

it should Navigate to the next page

1.open the edit privileges window 2.go to the change password 3.select the password radio button 4.type the password 5.retype the password 6.click the go button

it should Navigate to the next page

1.open the edit privileges window 2.go to the change password 3.select the password radio button 4.type the password 5.retype the wrong password 6.click the go button

it should show the message "the password aren't same "in the pop up window

1.open the edit privileges window 2.go to the change password 3.select the password radio button 4.type the password 5.retype the wrong password 6.click the go button

because of other bug/functionality.

mber for the defect test cases. Comments

Requiremen t / Use Case ID

Testing Method

OS

Browsers

Designed By

Executed By

AppLabs Technologies Revision History

System Test Cases

PIN: VERSION

AUTHOR

DATE

CHANGE

<1.0>

<AppLabs>

<mm/dd/yyyy>

<Modification / Included test case or the changes made to the test case should be entere here>

SPQ-T02 Proprietary Confidential

Page 65 of 65 V 2.1