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:\>\local\mysql\bin\mysql -u root

mysql> CREATE DATABASE HerongDB;
Query OK, 1 row affected (0.03 sec)

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| herongdb           |
| mysql              |
| test               |
+--------------------+
4 rows in set (0.00 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)

Now I am ready to login to the MySQL server with "Herong" and use "HerongDB" through mysqli interface.

Last update: 2015.

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

 References

 PDF Printing Version