A Flash Developer Resource Site














Internet Commerce

Partners & Affiliates














Developer Channel

internet.com


Featured Flash FLA
Gallery Downloads 11337 Flash Movies | 1 New Flash Movies Added
What's New | Top 100

Featured FLA

» Author: Bugra Ozden
» Title: Skatalog v9 - product catalog
» Description: Create your product catalog easly and publish on your website or Create your image gallery, documents list, portfolio. Fully XML Driven
» More by Bugra Ozden


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

Featured Site

» Posted in the Flash Kit Links section
» Title: Creative DW Image Show PRO
» Description: Creative DW Image Show PRO is a Dreamweaver extension which enables the user to create multimedia presentations. It combines the features of the popular Creative DW Image Show with the ability to add professional text effects to slides (similar to After Effects). The product is very customizable: the user can choose the duration of the transition effects, the slide motion start and end position, zoom and panning type for both images and texts.


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

» Make a Flash Slide Show Screen Saver
» Simple flash making tutorial for thanksgiving
» Create flash banner for website
» Create xml slideshow with free template
» How to Insert a Multilingual Subtitle Into Your Flash Video Studio
» How to Create Cool Halloween Slideshow
» Debugging flash using the Firebug console
» Create Flash Slideshow on Blogger
» FLASH TRICKS IN WEB ADVERTISING: FLASH BANNERS
» Unknown Tag: Title10
Random Tutorial | Add Site

Trading Customer Accounting (IL)
Next Step Systems
US-IL-Chicago

Justtechjobs.com Post A Job | Post A Resume


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.19 Votes: 107
Hits: 3275
» 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
 
   
 

internet.commediabistro.comJusttechjobs.comGraphics.com

Search:

WebMediaBrands Corporate Info

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | Shopping | E-mail Offers | Freelance Jobs