Skip to main content

Installing, Configuring and Testing MySQL Database Server on ‘localhost’

Installing, Configuring and Testing MySQL Database Server on ‘localhost’

Here we go with another installation and configuration post for out local server; this time for MySQL, the well known and widely popular free database server.

[You may want to read Installing Web Server on your PC, Installing Apache and PHP on your PC and Configuring Apache Web Server and PHP]

In this post, we’ll learn to set-up MySQL server on our own local server and see how we can connect to it from our scripts.

Since the last few posts we have been having problems implementing data storage/retrieval from files, we thought it was the right time to start using database for that purpose. However before we can use database connectivity from our scripts, we need to install a database server, we’ve chosen My SQL. In spite of MySQL database server being free, it has proven itself time and again as the best database server around. Its free too so there is no point in us looking for anything else.

OK, let’s start by first downloading the MySQL package, you may download it directly from mysql-5.0.51b-win32.zip and unzip it to some temporary directory. You’ll be glad to know that MySQL comes in a standard Install Shield package and its installation is no different than other software. That means installing it would be a breeze. You may proceed with the ‘typical’ installation filling up the details as asked or choose the ‘custom’ installation which would require lots of information to be given hence more power and control over how it gets installed.

Please write down the ‘root’ password that you supply to the installer. That’d be needed to connect to MySQL from our scripts.

Installation of MySQL is pretty simple, after it getting installed, open the ‘php.ini’ file from the Windows directory and follow the following steps:

1. Look for a bunch of lines which look something like below:

Installing MySQL on local server

2. Now uncomment the following lines by deleting the ‘;’ before them so that they look something like below:

Installing MySQL on local server

3. Restart Apache.

Now MySQL has been installed and configured completely and is ready to be tested.

Testing

To test the working of MySQL create a PHP script with the following content and run it:

<?php
$db
=new mysqli('localhost','root','-PASS-');
$db->query('create database temp');
$db->close();
?>

If you don’t get any errors on running the above script then it means you’ve successfully installed MySQL server.

A little about the code:

First line sets up the connection between our script and the MySQL database server.

We are using the Object Oriented interface, so creating a new object of class mysqli or MySQL (Improved).

First argument is the host on which MySQL is installed, for local servers it is ‘localhost’. Second is the MySQL user we’re using the predefined username ‘root’ and password that we provided while installation. It’s a BAD idea to use ‘root’ account for database connection on a real web server.

MySQL understands Structured Query Language. In the second line we’re querying the MySQL to create a Database named ‘temp’, this line might probably not work on many web hosts since they require you to create Database from their own interface and not directly form MySQL.

We close the connection with MySQL in the last line.

Previous Articles:

Popular posts from this blog

Fix For Toshiba Satellite "RTC Battery is Low" Error (with Pictures)

RTC Battery is Low Error on a Toshiba Satellite laptop "RTC Battery is Low..." An error message flashing while you try to boot your laptop is enough to panic many people. But worry not! "RTC Battery" stands for Real-Time Clock battery which almost all laptops and PCs have on their motherboard to power the clock and sometimes to also keep the CMOS settings from getting erased while the system is switched off.  It is not uncommon for these batteries to last for years before requiring a replacement as the clock consumes very less power. And contrary to what some people tell you - they are not rechargeable or getting charged while your computer or laptop is running. In this article, we'll learn everything about RTC batteries and how to fix the error on your Toshiba Satellite laptop. What is an RTC Battery? RTC or CMOS batteries are small coin-shaped lithium batteries with a 3-volts output. Most laptops use

The Best Way(s) to Comment out PHP/HTML Code

PHP supports various styles of comments. Please check the following example: <?php // Single line comment code (); # Single line Comment code2 (); /* Multi Line comment code(); The code inside doesn't run */ // /* This doesn NOT start a multi-line comment block /* Multi line comment block The following line still ends the multi-line comment block //*/ The " # " comment style, though, is rarely used. Do note, in the example, that anything (even a multi-block comment /* ) after a " // " or " # " is a comment, and /* */ around any single-line comment overrides it. This information will come in handy when we learn about some neat tricks next. Comment out PHP Code Blocks Check the following code <?php //* Toggle line if ( 1 ) {      // } else {      // } //*/ //* Toggle line if ( 2 ) {      // } else {      // } //*/ Now see how easy it is to toggle a part of PHP code by just removing or adding a single " / " from th

Introduction to Operator Overloading in C++

a1 = a2 + a3; The above operation is valid, as you know if a1, a2 and a3 are instances of in-built Data Types . But what if those are, say objects of a Class ; is the operation valid? Yes, it is, if you overload the ‘+’ Operator in the class, to which a1, a2 and a3 belong. Operator overloading is used to give special meaning to the commonly used operators (such as +, -, * etc.) with respect to a class. By overloading operators, we can control or define how an operator should operate on data with respect to a class. Operators are overloaded in C++ by creating operator functions either as a member or a s a Friend Function of a class. Since creating member operator functions are easier, we’ll be using that method in this article. As I said operator functions are declared using the following general form: ret-type operator#(arg-list); and then defining it as a normal member function. Here, ret-type is commonly the name of the class itself as the ope