HTML TO JAVA

  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 @ .

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...

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

 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.  

Knowledge test of india -survey that is shooted by my students of St. Mary's school dahod must watch and share this video !! Knowledge test of india

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...

MySQL is a open source Relational Database Management System. MySQL is very fast reliable and flexible Database Management System. MySQL Installing packages The MySQL Installing packages comes in three flavors, you can choose any of the Installer package as per your requirements and your expertise level. These packages are: The Essential package The  Essential package has a Similar filename to MySQL-essential-5.0.25-win32. msi and it contains the minimum set of files needed for installation MySQL on Windows, including the Configuration Wizard except embedded server and benchmark suite.   " This package is recommended most of the users as the user can  install multiple instances of MySQL on a single server host and the advanced user can complete control over server configuration."    The Complete package The complete package has all the needed files that are required for windows installation ...