Flyspray is an uncomplicated, web-based bug tracking system written in PHP for assisting with software development. It was originally conceived when the Psi Jabber client project couldn't find a bugtracker that suited their needs, and has been made available for everyone to use for their own projects.

shell> mysqld --verbose --help

The output includes the default variable values and looks something like this:

Warning: mysql_connect(): Host 'ip-address' is not allowed to connect to this you can get similar error many time in your scripts.This error normaly appear if you dont have "privileges" set for that host name.

your username is actually combination of two parts

1)User

2)host

user string not necessary to be Unique..! but combination user@host should be unique.This string tells us that which user from which host is allowed to connect with database.Folowing is most common way for solving this issue which i have used :-)

The MySQL® database is the most popular world's open source database because of its consistent fast performance, high reliability and ease of use. You can find most of Web developers dealing with Mysql And PHP based Web developments.This database is used with many popular web sites and most of sites are now reffering this database.

way to change max_allowed_packet

mysql> show variables like 'max%' ;

+-----------------------+------------+
| Variable_name         | Value      |
+-----------------------+------------+
| max_allowed_packet    | 1048576    |
...

mysql> set max_allowed_packet = 1500000;
Query OK, 0 rows affected (0.03 sec)

mysql> show variables like 'max%' ;
+-----------------------+------------+
| Variable_name         | Value      |
+-----------------------+------------+
| max_allowed_packet    | 1499136    |
...

You can use SELECT command for performaing single as well as complax operations depending on requirements.Belo is a simple use of SQL statement for getting duplicate records from database table:-

SELECT *
FROM `<table>`
WHERE  <key>
IN (

SELECT <key>
FROM  <table>
GROUP BY <key>
HAVING count( * ) >1
)
 

Example:-

SELECT *
FROM `demo`
WHERE id
IN (

SELECT id
FROM demo
GROUP BY id
HAVING count( * ) >1
)

First things first, we need to get the latest version of
phpMyAdmin, at the time
this tutorial was written the latest stable version was 2.5.5-pl1,
and you can get it at;



The phpMyAdmin Home Page 

The Link I used:

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

A Mysql injection is attack tried by site visitors/users to get/damage data in databases by taking benefit from poor programming of websites.An injection attack occurs when a visitor to your site types something into a form input with the purpose of changing the outcome of your MySQL query. For example, at a login screen someone may try this type of attack to gain access to a secure area of the website.

If your query to check the username and password entered by the user was this:

The RENAME TABLE statement defines a new name for an existing table in the database enviornment
Scope/Usage

Application Programs

SQL Syntax

RENAME TABLE [Owner.] TableName TO NewTableName

Parameters

[Owner.]TableName

Denotes the old table that is to be renamed.You can enclose database owner name in prefix.

NewTableName

    is the new table name.

Description