MySQL Tutorials - Herong's Tutorial Examples - v4.46, by Herong Yang
Archived: Installing MySQL 5.6.28
This section provides a tutorial example on how to install MySQL 5.6.28 on a Windows system.
1. Go to dev.mysql.com/downloads/mysql/5.6.html Website.
2. Click the "Download" button next to "Windows (x86, 32-bit), ZIP Archive 5.6.28 344.5M" in the "Other Downloads:" section. The "Begin Your Download - mysql-5.6.28-win32.zip" page shows up.
3. Click "No thanks, just start my download." to skip login and start the download.
4. Save the downloaded file, mysql-5.6.28-win32.zip, on your hard disk in \temp folder.
5. Unzip mysql-5.6.28-win32.zip to "\temp\mysql" and move it to "\local\mysql".
6. Open a command window and run "\local\mysql\bin\mysqld" to start MySQL server:
herong> \local\mysql\bin\mysqld --console [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). [Note] \local\mysql\bin\mysqld (mysqld 5.6.28) starting as process 8092 [Note] Plugin 'FEDERATED' is disabled. [Note] InnoDB: Using atomics to ref count buffer pool pages [Note] InnoDB: The InnoDB memory heap is disabled [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions [Note] InnoDB: Memory barrier is not used [Note] InnoDB: Compressed tables use zlib 1.2.3 [Note] InnoDB: Not using CPU crc32 instructions [Note] InnoDB: Initializing buffer pool, size = 128.0M [Note] InnoDB: Completed initialization of buffer pool [Note] InnoDB: Highest supported file format is Barracuda. [Note] InnoDB: 128 rollback segment(s) are active. [Note] InnoDB: Waiting for purge to start [Note] InnoDB: 5.6.28 started; log sequence number 1629848 [Note] Server hostname (bind-address): '*'; port: 3306 [Note] IPv6 is available. [Note] - '::' resolves to '::'; [Note] Server socket created on IP: '::'. [Note] Event Scheduler: Loaded 0 events [Note] \local\mysql\bin\mysqld: ready for connections. Version: '5.6.28' socket: '' port: 3306 MySQL Community Server (GPL)
7. Open another command window and run "mysqladmin" to administrate MySQL server:
herong> \local\mysql\bin\mysqladmin ping mysqld is alive herong> \local\mysql\bin\mysqladmin -u root shutdown
If you see the MySQL server printing notice and shutting down in the first command window, you know that you have installed MySQL 5.6 correctly.
Table of Contents
MySQL Introduction and Installation
Introduction of MySQL Programs
Perl Programs and MySQL Servers
Java Programs and MySQL Servers
Character Strings and Bit Strings
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
Window Functions for Statistical Analysis
Use Index for Better Performance
Transaction Management and Isolation Levels
Defining and Calling Stored Procedures
Variables, Loops and Cursors Used in Stored Procedures
System, User-Defined and Stored Procedure Variables
Storage Engines in MySQL Server
InnoDB Storage Engine - Primary and Secondary Indexes
Performance Tuning and Optimization
Installing MySQL Server on Linux
Connection, Performance and Second Instance on Linux
Archived: Installing MySQL 5.7.10 with Installer
Archived: Issues MySQL 5.7.10 Installer
Archived: MySQL Connector/J 5.1 Installation
►Archived: Installing MySQL 5.6.28
Archived: Installing MySQL 5.5.15
Archived: Installing MySQL 5.0.2 (Alpha)