Chinese Web Sites Using PHP - v2.23, by Herong Yang
Creating Database and User with MySQL Monitor
This section describes how to create a new database and a new user with MySQL monitor.
MySQL server organizes database objects into databases. In order to test mysql driver for MySQL server, I created a new database called, HerongDB, and a new user, Herong, with the MySQL command line interface:
C:\herong> \local\mysql\bin\mysql -u root mysql> CREATE DATABASE HerongDB; Query OK, 1 row affected (0.03 sec) mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | herongdb | | information_schema | | mysql | | performance_schema | | sys | +--------------------+ 5 rows in set (0.06 sec) mysql> CREATE USER Herong IDENTIFIED BY 'TopSecret'; Query OK, 0 rows affected (2.75 sec) mysql> GRANT ALL ON HerongDB.* TO Herong; Query OK, 0 rows affected (0.34 sec) mysql> exit; Bye
Now I am ready to login to the MySQL server with "Herong" and use "HerongDB".
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