MySQL Tutorials - Herong's Tutorial Examples
∟MySQL 4.0 Introduction and Installation
∟Installing MySQL 4.0.18
This section provides a tutorial example on how to install MySQL 4.0.18 on a Windows system.
1. Go to http://dev.mysql.com/downloads and select the latest production release.
2. Go to "Windows downloads" and select "Without installer (unzip in C:\)" entry.
3. Save the downloaded file, mysql-4.0.18-win-noinstall.zip, on your hard disk.
4. Unzip mysql-4.0.18-win-noinstall.zip to "\" and rename "\mysql-4.0.18" to "\mysql".
5. Open a command window and run "\mysql\bin\mysqld" to start MySQL server:
\mysql\bin\mysqld --console nnnnnn 22:16:53 InnoDB: Started \mysql\bin\mysqld: ready for connections. Version: '4.0.18-max-debug' socket: '' port: 3306
6. Open another command window and run "\mysql\bin\mysqladmin" to administrate MySQL server:
\mysql\bin\mysqladmin ping mysqld is alive \mysql\bin\mysqladmin shutdown
If everything works correctly, you should see MySQL server printing notice and shutting down in the first command window.
Table of Contents
About This Book
Introduction of SQL
►MySQL 4.0 Introduction and Installation
MySQL 4.0 Introduction
►Installing MySQL 4.0.18
Creating First Table in MySQL
Installing MySQL 5.5.15
Installing MySQL 5.0.2 (Alpha)
Introduction of MySQL 5.0 Programs
Perl Programs and MySQL Servers
PHP Programs and MySQL Servers
Java Programs and MySQL Servers
Datatypes and Data Literals
Operations and Expressions
Character Strings and Bit Strings
Commonly Used Functions
Table Column Types for Different Types of Values
Using DDL to Create Tables and Indexes
Using DML to Insert, Update and Delete Records
Using SELECT to Query Database
Transaction Management and Isolation Levels
Locks-Used-in-MySQL
Defining and Calling Stored Procedures
Variables, Loops and Cursors Used in Stored Procedures
References
Printable Copy - PDF Version