Start earning money with your Website. Matched.co.uk pays 5 english pounds when you sign up and 3 pounds per month for each ad you publish
Find out more at http://www.matched.co.uk
To install MySql on Vista is not much different than installing it on Windows xp.Just be aware of wich version of MySql you will download.There are many versions available on the net,and I used the MySql 5.0.45 for win32 that you can find here at the MySql website, Scroll down the page and fibd this version Windows ZIP/Setup.EXE (x86) a file of 42.5 MB and download it.
Log in as a user with administrator permissions.When your dowload is complete,go to the location where you saved the file and double click it.
The installation process begins
On the window below click Install
Then, the installation is complete .Check Configure the MySql
server now and click
Finish
Now the configuration wizard starts.If it doesn't start automatically,go to Programs / MySql / Configuration Wizard and start it manually.Click Next.
On the window below I chose Detailed Configuration to have
access to change the options following.Click Next.
Then, on this window you choose how you going to use MySql todetermine how many resources to allocate for
the server and click Next.
Now choose MultifunctionalDatabase
and.Click Next.
On the window below you can choose the drive where install MySql
or leave the default and Click Next.
Then, on this window you can choose how many connectors
at the same time,when you make your choice,consider how many resources
you have on your machine and click Next.
Now ,if you have a firewall on your computer ,make sure to allow port
number 3306 .At the beginning uncheck Enable Strict Mode to make it
easier for you and then,when you more confident,you can enable it again.
and.Click Next.
On the window below ,leave Standard Character Set
and.Click Next.
Then, on this window choose to run MySql as Windows Service and click Next.
Now enter the root password,this is a very important step,because this
password will allow you to access the database root as administrator and
do basically everything,so make sure to choose a strong password
and.Click Next.
Now you've done and the configuration wizard is ready to execute
the settings you chose just Click Execute .
Go to Start / Programs / MySql and click on
MySql Command Line ClientA command prompt appears, like the figure below, you'll be
asked for a password. Type the password you choose during the
configuration and press enter, if you see something like below,
MySql Server is successfully running on your computer.
When the installation is
finished ,you have to configure PHP to run MySql
if you haven't done it yet when installing PHP.
To start go to the
PHP directory,in this case C:\ PHP and open php.ini with
Notepad .
Find extension_dir =
"./" and change it in extension_dir = "C:/PHP./ext" where ext is the folder
where all the extension are.
Find and uncomment (delete the
;) ;extension=php_mysql.dll and ;extension=php_mysqli.dll or type them in the
case they aren't with the extensions
.
A this stage open your browser and open the page you have done to test the PHP installation, phptest.php and now you should be able to see all the information about MySql like in the figure below .If you can't see them ,the reason is PHP can't load MySql extension and you'll have to go through the PHP configurations steps and make sure that you've followed all the steps.
A further test to connect to MySql from PHP , open Notepad , new
document and copy and paste the following code:
<?php
$host='localhost';
//host name
$username='user';
//database user name
$password='mypassword'; //database password
mysql_connect($host,$username,$password) or die (mysql_error());
echo"connected<br/>";
?>
Then save the file in your website root directory and name it
test_sql.php.Now open the file in your browser and,if everything OK
you should read 'connected ' on a white page ,
845
