Internet Commerce

Partners & Affiliates

Developer Channel


Featured Flash FLA
Gallery Downloads 11401 Flash Movies | 5 New Flash Movies Added
What's New | Top 100

Featured FLA

»  Author: Nick Kouvaris
»  Title: Znax
»  Description: Znax is a board game. Click 4 tiles of the same color and form squares as big as you can. You will erase all the tiles inside the square and collect points. Get maximum score if you make a square with game edges.
»  More by: Nick Kouvaris


Random FLAs | Add Flash Movie
Featured Flash Site
Gallery Downloads 4941 Flash Sites | 1 New Flash Links
What's New | Top 100 Flash Site

Featured Site

»  Author Agence WOP Digital Agency
»  Title: Electricdrum
»  Description: French WOP Agency, 3D websites, Flash (Papervision, Away 3D), event or institutional projects. The agency operates on all digital projects: consulting, design, graphic design, development, online communication. The WOP agency follows you on the implementation of original, creative and optimized digital projects.


Random Links | Add your own Flash Related Links
Flash Tutorials 1481 Tutorials 7 New Tutorials Added!
What's New | Top100

» How To Make A Simple Animation Using Christmas Clips
» Simple Step by step flash game tutorial Spot the diffrence
» How To Make A Moving Text Slide
» Create Flash Banner With Text Float Effect
» How To Make Zoo Photos Slideshow
» How To Make A Dolphin Photos Slideshow
» How To Make A Fathers Day Slideshow
» How To Make A Transparent Background of Your Flash File
» Create Flash Banner With Text Disco Light Effect Today we will introduce you a Text Disco Light eff
» Unknown Tag: Title10
Random Tutorial | Add Site


Tutorials Home What's New Top Rated Submit myTutes Random!

Search Tutorials


Tutorials Tutorials » Backend

Categories Installing Apache 2.0, PHP 4.2, MySQL 3.23, and PHPMyAdmin
Author: Jeffrey F. Hill | Website: http://www.flash-db.com |

 
Page 6
«prev 1 2 3 4 5 6 7 8 9 next»

Installing MySQL 3.23.49

First where going to have to download MySQL
You can download MySQL 3.23 here:  http://www.mysql.com/downloads/mysql-3.23.html 
Or more specifically here:  Download (mysql-3.23.49-win.zip)

After you have downloaded this file unzip it to a temporary directory.  For exampe:  C:\MySQLTemp

Go to that folder and click the Setup Application file (shown as a computer icon).

The Setup should begin.  Click through the first couple of screens and select the default location to install MySQL to (C:\MySQL).

Next:  Open up the file C:\mysql\bin\winmysqladmin.exe (The icon has a little my SQL graphic).  This will prompt you for a UserName and password you want to use for accessing MySQL.  Enter a Username and password of your choice and then click ok.  This creates a file called my.ini (Located: C:\Windows\my.ini) You can open this up if you want, you should see the Username and Password you just specified as the 3rd and 4th line in this file.  Their are some other items you can change here, but for are purpose's that's all that's needed.

Exercise: Testing if MySQL is running
Create a PHP script called 'TestSQL.php'.  Then add the following to that file.

<?php
mysql_connect("localhost","yourUserName","yourPassword") or die("Uh Oh, Could not connect");

$Version = mysql_get_server_info();
$HostInfo = mysql_get_host_info();
print "My current MySQL version is: $Version
On $HostInfo";
?>

Make sure to replace "yourUserName" and "yourPassword" with the ones you choose above.  Then place this file into your htdocs folder and open up: http://localhost/TestSQL.php - This should result in 2 lines being printed to the screen - saying something like "My current MySQL version is: 3.23.49  On localhost via TCP/IP".  If that was successful then MySQL is up and running.  You should also see a Stop Light Icon on your task bar - The light will be Green if mySQL is running.  You can use that to display some system info (select show me) if wanted.

That's about it for MySQL. The next section will go into detail on one Web based tool that easily allows you to create new database, tables, and the over all structure of your database along with some simple examples.  For those of you that are more comfortable with the command line MySQL can also be used by opening up a DOS prompt to the C:\mysql\bin directory and typing in MySQL - then you can go on to do whatever you want with MySQL.  This is virtually the same as using Telnet to access MySQL on a Unix server.  However since many of us are not really comfortable with the Command line option - we'll be using a Tool called PHPMyAdmin that avoids this and makes MySQL really really easy to use!

For information on using the command line from the DOS prompt or from Telnet read the first part of this

For further information on MySQL and a great reference manual visit - http://www.mysql.com/doc/.

«prev 1 2 3 4 5 6 7 8 9 next»

» Level Advanced

Added: : 2002-05-08
Rating: 9.20 Votes: 108
Hits: 3279
» Author
Jeffrey Hill is a freelance web developer from Boulder, Colorado. He specializes in creating and developing dynamic database driven Flash content, applications, and content management systems. Specialty's include SQL, PHP, Perl, XML, web services, and Flash clients for web services.
» Download
Download the files used in this tutorial.
Download (30 kb)
Get conversion and unzipping tools for PC and Mac here!

» Forums
More help? Search our boards for quick answers!

Please rate this tutorial, 10 is the top rating, you can also click the comments link to read/write a review.
10 9 8 7 6 5 4 3 2 1
Read or Post Comments