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