mirror of
https://github.com/dotnetcore/CanalSharp.git
synced 2026-10-19 06:31:42 +08:00
stulzq
23 lines
310 B
SQL
23 lines
310 B
SQL
|
|
CREATE USER canal IDENTIFIED BY 'canal';
|
|
GRANT ALL PRIVILEGES ON *.* TO 'canal'@'%' ;
|
|
FLUSH PRIVILEGES;
|
|
|
|
CREATE DATABASE `test`;
|
|
|
|
USE test;
|
|
|
|
|
|
CREATE TABLE `test` (
|
|
`id` INT(11) NOT NULL,
|
|
`name` VARCHAR(50) NOT NULL
|
|
)
|
|
ENGINE=InnoDB
|
|
;
|
|
|
|
ALTER TABLE `test`.`test`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
|
|
|