Working with MySQL database

[Garlands]

Hello sir ! As I am new guy for MySQL database and I don't know how to connect to database server. I have been assigned with a user name and password but I didn't get the ways to create a connection to database.
Please help me perform this task.I will be highly thank full to you.

Thanks.

[opaper]

Working with MySQL database :

MySQL is a very popular, most reliable database management system software with the facility of Open Source SQL management.The world's largest corporation Sun Microsystems introduced with a new concept of Relation database management and designed, distributed which can be supported with different platform.

MySQL is a relational database management system which provide the management of Database Server is very fast, reliable, and easy to use.It can be constructed with the the client/server or embedded systems.

[Modifier]

Connecting with MySQL database :

You can connect with MySQL database but before that you need to create the database using provided tools of MySQL.Once you create a database you can easily connect with different ways :

Come on a shell prompt and type

mysql -u DBUSERNAME -h DBSERVER -p DBNAME
where DBUSERNAME specifies the name of the user and DBSERVER requires the correct database servername for your site and DBNAME requires the name of MySQL database.

After that you would be prompted for the password.Enter the password and you get a prompt of Mysql simply.

[Praetor]

Connecting to MySQL database using PHP script :

You can connect with MySQL database using PHP script after putting connection code inside the PHP script which would be as follows :

<?
mysql_connect("DBSERVER", "DBUSERNAME", "DBPASSWORD");
mysql_select_db("DBNAME");
?>

The highlighted things are necessary to connect with the database and fill it carefully.

[Katty]

Connect to MySQL database with perl script :

You can connect with a MySQL database using some defined code and put it into your file and get connect easily with database :

#!/usr/bin/perl
use DBI;

$database = "DBNAME";
$hostname = "DBSERVER";
$port = "3306";
$username = "DBUSERNAME";
$password = 'DBPASSWORD';

$dsn = "DBI:mysql:database=$database;host=$hostname;port=$port";

$dbh = DBI->connect($dsn, $username, $password) or die("Could not connect!");

$sql = "SELECT * FROM mytable";

$sth = $dbh->prepare($sql);
$sth->execute;


while(($column1, $column2) = $sth->fetchrow_array)
{
print "C1 = $column1, C2 = $column2n";
}


$dbh->disconnect;

The required field are necessary to fill with the proper information.Where DBNAME is the name of database,DBSERVER is the name of server to which you would connect,DBPASSWORD requires absolute password for the database to be connect.

[kelfro]

Changing the password of MySQL database :

You can change the password of MySQL database at a shell prompt. Get connect first and when you will be prompted with the "mysql>"

When you get Mysql prompt,type the following command :

mysql> set password = password("type_new_password");

To exit from the monitor type "QUIT"