How to create a table to a specific user First good evening every body.
assume that you are logged in as a super user and you want to create a user. 

  CREATE USER 'user1'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*483EC567DF968A6AD5E279257828E7CC4A12F0C2' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK;


and you want to create some tables for that user something like this 

CREATE TABLE user1.user1Table -- table for user1  
(
idUser INTEGER PRIMARY KEY AUTO_INCREMENT,
Name VARCHAR(30)
) ENGINE=INNODB ;


when I run the sql script I get an error like this

ERROR 1049 (42000): Unknown database 'user1'


I thought at the beginning that I would have something like that

mysql&gt; desc user1Table ;
+--------+-------------+------+-----+---------+----------------+
| Field  | Type        | Null | Key | Default | Extra          |
+--------+-------------+------+-----+---------+----------------+
| idUser | int(11)     | NO   | PRI | NULL    | auto_increment |
| Name   | varchar(30) | YES  |     | NULL    |                |
+--------+-------------+------+-----+---------+----------------+
2 rows in set (0.01 sec)

mysql&gt;


why that is not possible ??? i have wamp server

thank you in advance
CREATE TABLE {database}.{tablename}

creates a table in the specified database. As such you'll need a user only table
CREATE TABLE user1Table...

To give a user access to the table:

GRANT ALL ON {database}.user1Table TO 'user1'@'%'

Where {database} is the database in which the tables are created.