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

 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 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

 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