Many times in ASP or dot net we may need to connect to a mysql database.For making a connection to mysql database we need to install mysql connector for windows which you can download from:-..

First of all you should know how you can add users in mysql databases:-

* Using CREATE USER and/or GRANT commands
* Inserting a new record into the mysql.user table

First let’s see how to use the CREATE USER command:-

CREATE USER user [IDENTIFIED BY [PASSWORD] ‘password’]

e.g

mysql>CREATE USER ‘myuser’@'localhost’ IDENTIFIED BY ‘mypassword’;

Many times it is needed to get the structure of table in PHP file or drupal module.There may be conditions that you dont have got admin user name and passwords for cpanel/phpmyadmin.In such cases you must have idea how to know the structure using a small PHP code.you can get connection info for mysql from [...]

Requirements before getting started with development or web programming
Any one who want to develop a web application must have the following systems:
1. A web server.
2. An editor to develop the web pages.
3. A browser to view the web page you develop.
4. A database program like MS Access, SQL Server etc, if your web site need [...]