Chinese Web Sites Using PHP - v2.23, by Herong Yang
MySQL 8.0 Download, Installation and Start
This section provides a tutorial example on how to download, install and start MySQL 8.0 server on Windows systems.
MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com. You can download a copy and install it on your local Windows system very easily. Here is what I did to download and install MySQL 8 Community Server on my Windows system:
1. Go to "Download MySQL Community Server" page at dev.mysql.com/downloads/mysql/.
2. Click "Download" button next to the "Windows (x86, 64-bit), ZIP Archive 8.0.13 192.3M" line.
3. Click "Login" button, if you already have Oracle account. Otherwise, click "Sign Up" to create one first.
4. Fill in the download survey form.
5. Click "Download Now" to start downloading.
6. Save the download file, mysql-8.0.13-winx64.zip, 201,641,671 bytes, to a temporary directory.
7. Unzip mysql-8.0.13-winx64.zip. You see all files are extracted to a sub-directory .\mysql-8.0.13-winx64.
8. Move and rename .\mysql-8.0.13-winx64 to \local\mysql.
9. Initialize the data directory by running the following command:
C:\herong> \local\mysql\bin\mysqld --initialize-insecure --console ... 0 [System] [MY-013169] [Server] \local\mysql\bin\mysqld (mysqld 8.0.13) initializing of server in progress as process 8568 ... 5 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. ... 0 [System] [MY-013170] [Server] \local\mysql\bin\mysqld (mysqld 8.0.13) initializing of server has completed
10. Run the "mysqld" program to start the MySQL server:
C:\herong> \local\mysql\bin\mysqld
"mysqld" will run quietly without printing any message in you command window. So you will see nothing after entering the "mysqld" command. You should trust "mysqld" and believe that MySQL server is running ok on your local computer now.
Table of Contents
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 8.0 Download, Installation and Start
Creating Database and User with MySQL Monitor
Creating a Test Table - Comment
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