Skip to content

Instantly share code, notes, and snippets.

@xgz123
Last active December 22, 2016 06:23
Show Gist options
  • Save xgz123/0af2b9e744d8f75a2b5d77c951a4a89d to your computer and use it in GitHub Desktop.
Save xgz123/0af2b9e744d8f75a2b5d77c951a4a89d to your computer and use it in GitHub Desktop.
set password for 'root'@'localhost'=password('123456')
RANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456';
alter table User rename user;
show full columns from chat; #查看所有列
alter table chat modify column createtime bigint; #修改字段类型
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment