建立一个新数据库 CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_specification ...]create_specification: [DEFAULT] CHARACTER SET charset_name | [DEFAULT] COLLATE collation_name mysql> create database myTestDB;[align=center]====思想重于技巧==== [/align]
建立一个用户名和密码 CREATE USER user [IDENTIFIED BY [PASSWORD] 'password'] [, user [IDENTIFIED BY [PASSWORD] 'password']] ... mysql> create user testuser identified by 12345; [align=center]====思想重于技巧==== [/align]
这个用户名只能对这个数据库操作 mysql> grant all on myTestDB.* to testuser;[align=center]====思想重于技巧==== [/align]
[create_specification ...]create_specification:
[DEFAULT] CHARACTER SET charset_name
| [DEFAULT] COLLATE collation_name
mysql> create database myTestDB;[align=center]==== 思想重于技巧 ====
[/align]
[, user [IDENTIFIED BY [PASSWORD] 'password']] ...
mysql> create user testuser identified by 12345;
[align=center]==== 思想重于技巧 ====
[/align]
[/align]