Create MySQL users and databases under Linux, and bind

Linux under input command:

Mysql-uroot-proot123

Enter MySQL after entering:

See which databases are currently present:
Mysql> SHOW DATABASES;

Creating a database: Create schema [database name] default character set UTF8 collate utf8_general_ci;
Example:
Mysql> Create schema estuntest default character set UTF8 collate utf8_general_ci;
Query OK, 1 row Affected (0.00 sec)

Create User: ' [user name] ' @ '% ' identified by ' [user password] ';
Example:
mysql> create user ' estuntest ' @ '% ' identified by ' estuntest123 ';
Query OK, 0 rows Affected (0.00 sec)

User Authorization database: Grant select,insert,update,delete,create on [database name].* to [user name];
* represents the entire database.
Example:
Mysql> Grant Select,insert,update,delete,create on estuntest.* to Estuntest;
Query OK, 0 rows Affected (0.00 sec)

Create MySQL users and databases under Linux, and bind