Skip to main content

Posts

How to remove shortcut virus from USB drive ?

How to  remove shortcut  virus from USB drive ? Press win+R it will open run window       Enter cmd and press ok. In command window type attrib and hit enter. Now type “attrib -h -r -s /s /d e:\*.*” and hit enter (Remove e:\ with sutaible USB Drive Level) After successfully run the script you will get following windows 

How to view MYSQL Users with their Privileges

  To Find list of users and permission granted them in MYSQL run following command :          select user,host from MySQL.user; Here (i) host component tells on which host they are connecting from.          (ii)%  is a wild card character interprets as 'any ' host. To find the privilege(s) granted to a particular MySQL account: --> show grants for 'super'@'%';  Here super is user name and host name user concatenated by @ .

How to Grant Privilages to an account in MYSQL

MYSQL 'GRANT' statement allows you to grant access privileges to database account. To achieve same ,syntax  is as follow: Syntax:- GRANT privileges [Column_List] ON  [Object_Type] Privilege_level To account [IDENTIFIED BY 'password'] [ REQUIRE encryption ] WITH with_option ; Detailed explanation: Privileges:- It indicates that you have assign privileges to account. column_List : - (1) Its  optional.                          (2) Column(s) to which privileges apply. Privileges_level :- Level at which privileges apply. You can use global  privileges,database privileges,table specific privileges, column privileges etc. Account :- Which  account is being granted privileges. Password: - Specifies password.It replace old password. Required:- Clause specify whether the account has to connect to database server over secure connec...

MYSQL Administration

Crating New User in MYSQL: Syntax:  Create user <UserName@localhost> Idendified By  '<paswword>'; Eg.: Create user dbadmin@localhost Identified By 'dbadmin' ;

Introduction of database concept

 A collection of data is referred to as database and a database (management) system is  basically a computer based record keeping system.  It maintains any information that may be necessary to the decision-making processes involved  in the management of the organization.  The intention of a database is that the same collection of data should serve as many       applications as possible.  Database would permit not only the retrieval of data but also continuous modification of data needed for control of operations.  It may be possible to search the database to obtain answers to queries or information for planning purpose.  

Step-by-Step guide for Installing MySQL on Windows

Step-by-Step guide for Installing MySQL on Windows Y ou can download the MySQL database from the MySQL website http://www.mysql.com by clicking on the downloads tab. Scroll down to the MySQL database server & standard clients section and select the latest production release of MySQL, 5.1.35 at the time of writing. Installation of MySQL Server: Unzip the setup file and execute the downloaded . MSI file. Follow the instructions below exactly when installing MySQL Server: Click on the "setup" MySQL Installing Type There are three type of MySQL Installation:- Typical  This MySQL installing process install the  MySQL server,command- line client and command line utilities. This command line and command client included in mysqldump, myisamchk and several tools to manage the MySQL Server. Complete By this installation type we install all the component included in the installation package. And this package include the component such as suppor...