First time here? First time here? Newsletter Signup Newsletter
651326 Members and growing! | Flash Jobs
Search tutorials
Author: Jeffrey F. Hill | Website: http://www.flash-db.com

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.

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/.

» Level Advanced

Added: 2002-05-08
Rating: 9 Votes: 108
(10 being the highest)
» 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.
» Forums
More help? Search our boards for quick answers!

Comments

  • There are no comments yet. Be the first to comment!

  • You must have javascript enabled in order to post comments.

Leave a Comment
  • Your email address will not be published. All fields are required.
Featured Flash FLA
» Author: work2survive
» Title: Girl Walking 1kb
» Description: Walking girl, animation just takes 1kb, using high heels shoes, and fashion model attitude.
Featured Sound Loops
Image for equalize

Audio Player

» Author: BoxCat
» Title: CPU Talk
» Description: From the cyberpunk RPG, "Nameless: the Hackers" Completely Free to use! Keywords: edm hip hop rap electronic mysterious mission hacking chase exciting spy ios ambient chilling love happy sad angry suspense
Latest Font
» Author: Fábio FAFERS
» Description: I created this font for free use. Everyone can apply it in personal or business texts. Its free, but I want to be communicated in case of business use. Donations are accepted to keep the project of free fonts alive! Thank you all
Featured Sound Fx
Image for equalize

Audio Player

» Author: nathan
» Description:

A recorded sound of the Dimensional Fork Gate.