mysql初始化脚本建表_mysql初始化数据库建表脚本

set names utf8;

set global validate_password.policy=LOW;

set global validate_password.length=6;

CREATE DATABASE If Not Exists ai_teaching Character Set UTF8;

CREATE USER ‘ai‘@‘localhost‘ IDENTIFIED BY ‘shixun‘;

GRANT all ON ai_teaching.* TO ‘ai‘@‘localhost‘;

GRANT all ON ai_teaching.* TO ‘root‘@‘%‘;

use ai_teaching;

create table IF NOT EXISTS `tbl_user_images`(

`id` INT UNSIGNED AUTO_INCREMENT,

`user_id` VARCHAR(40) NOT NULL,

`label_name` VARCHAR(255) NOT NULL,

`image` LONGBLOB NOT NULL,

`vector` VARCHAR(4000) NOT NULL,

PRIMARY KEY (`id`)

)ENGINE=InnoDB DEFAULT CHARSET=utf8;

mysql初始化数据库建表脚本

标签：key   host   word   policy   ima   roo   cal   ges   tab

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：https://www.cnblogs.com/yinliang/p/11784918.html