mysql有数据库添加不了表

GRANT CREATE ON database_name.* TO 'username'@'localhost';

df -h

SHOW TABLES LIKE 'table_name';

CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    ...
) ENGINE=InnoDB;

CREATE TABLE table_name (
    column1 datatype CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    column2 datatype,
    ...
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE example_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL
);

CREATE TABLE users (
    user_id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL UNIQUE,
    email VARCHAR(100) NOT NULL UNIQUE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;