MySQL - Installation on Windows

∟MySQL - Installation on Windows

This chapter provides tutorial notes on MySQL installation on Windows systems. Topics include downloading, installing and starting MySQL database server; using mysqladmin tool; using command line tool; creating new database and new user.

MySQL 8.0 Download, Installation and Start

mysqladmin - MySQL Admin Tool

mysql - Command Line Tool

Creating Database and User with MySQL Monitor

Creating a Test Table - Comment

Takeaways:

Installing MySQL Server is easy. You can download the archive ZIP version, unzip it, and run the initialization command.
The .\bin\mysqld.exe program allows you to start the MySQL server.
The .\bin\mysqladmin.exe program allows you to manage the MySQL server.
The .\bin\mysql.exe program allows you to interact with the MySQL server.

Table of Contents

About This Book

PHP Installation on Windows Systems

Integrating PHP with Apache Web Server

charset="*" - Encodings on Chinese Web Pages

Chinese Characters in PHP String Literals

Multibyte String Functions in UTF-8 Encoding

Input Text Data from Web Forms

Input Chinese Text Data from Web Forms

►MySQL - Installation on Windows

MySQL - Connecting PHP to Database

MySQL - Character Set and Encoding

MySQL - Sending Non-ASCII Text to MySQL

Retrieving Chinese Text from Database to Web Pages

Input Chinese Text Data to MySQL Database

Chinese Text Encoding Conversion and Corruptions

Archived Tutorials

References

Full Version in PDF/EPUB